Re: [Bayonne-devel] db problems

[David Sugar]

I believe the way that sql data is read was changed in the testing 
branch.  I used to have some test scripts around for db which I could 
have confirmed this, but this particular usage example seems like the 
1.2 series db scripting.  Instead of read #sql, you now have sql.fetch 
to extract a row result, and the ability to use a "fordata" loop 
statement.  I think the sql.fetch works the same as how "read #sql" used 
to work in 1.2, that is, you just list the variables to dump the columns in.

Beto . wrote:
> hi. i have bayonne 20040818, and postgresql 7.2.2.
> when i do a select , the %sql.cos and %sql.rows vars are ok, but when i do
>    sql query=%querySelect
>    # to read a single row
>    read #sql %id %description
>    slog.info "id: " %id " description: " %description
>
> in /var/log/messages i get :" id: 0 description: 0"
>
> where is the error?
> thanks.
>
> _________________________________________________________________
> Charla con tus amigos en línea mediante MSN Messenger: 
> http://messenger.latam.msn.com/
>
>
>
> _______________________________________________
> Bayonne-devel mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/bayonne-devel