On Thu, 10 Jul 2003 14:11:02 -0700 Bernard Golden <[EMAIL PROTECTED]> wrote:
> I have a select statement that I execute after preparing. Is there a > way to determine if it returns no rows? The doco I've seen says > execute in a select context returns true if it executed successfully > or undef if an error occurs. I want to know if it executed ok but > found no matching records. > > Any guidance would be appreciated. The only safe, portable way is to try to fetch a row. If you want to process the rows in a loop, just start the loop and handle the case of no rows at the loop's exit. -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
