Re: [libdbi-devel] dbi_result_next_row() in while() loop

[Christian M. S. <chr...@st...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Took me some time to understand what you where talking about. (I don't use=
=20
error handlers anywhere)

Not sure what my thought are about removing it, There are other ways then=20
while loops to call dbi_result_next_row() and in some of them the error fee=
ls=20
kosher.

There are  ways to ignore the problem.=20

You could just look at the error_flag ignoring BAD_IDX errors in your error=
=20
handler or change the behavior of your while loops.

In attaching some example code.

Cheers,=20

Christian

Ps.

While looking into the problem I found that dbi_result_seek_row()  don't=20
return -1 when retval is -1 from dbd_goto_row() it continues along trying t=
o=20
fetch the row (This is a bug and should be changed even though we don't=20
remove the error handler, guess it hasn't been found yet becouse all driver=
s=20
always return 1 from dbd_goto_row()).



On Friday 22 August 2003 20.13, Eric Bixby wrote:
: I'm using the error handler feature to catch bad db
: queries.
:
: Calling dbi_result_next_row() in a while loop causes
: _error_handler() to get called.  I think it would be
: better to ignore this condition rather than report it
: as an error.  This isn't an error in the context of a
: while loop.  Ignoring this error in my error handler
: doesn't work because I need to trap when someone
: requests a bad fields name which is the same error
: code.
:
: Can the call to _error_handler() be taken out of the
: baseline for this function?
:
:
: __________________________________
: Do you Yahoo!?
: Yahoo! SiteBuilder - Free, easy-to-use web site design software
: http://sitebuilder.yahoo.com
:
:
: -------------------------------------------------------
: This SF.net email is sponsored by: VM Ware
: With VMware you can run multiple operating systems on a single machine.
: WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
: at the same time. Free trial click
: here:http://www.vmware.com/wl/offer/358/0
: _______________________________________________
: libdbi-devel mailing list
: lib...@li...
: https://lists.sourceforge.net/lists/listinfo/libdbi-devel
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/Si2jj1ZSAMHYBOkRAnOjAKD0R6Zf4Y3VT0T3zw2n5Mb7F+G8tACguo/b
fYj6XfBIvHyij9eyuC1U4Ss=3D
=3DBUm3
=2D----END PGP SIGNATURE-----