On Mon, 18 Nov 2002 [EMAIL PROTECTED] wrote: > As an unfortunate user recently found out, this depends on the > database. DBI offers the 'rows' method that you would call on your > statement handle to tell you the number of rows it returned (this is > NOT matched rows, for example if you use a LIMIT these are two very > different things).
Geez. I forgot to say - PostgreSQL 7.2.1. Here I was thinking I was so careful and would get all the important pieces in the message. The Cheetah book says rows() should not be used and especially not with select statements. Thanks for the suggestion though. In the same area it's suggested to use a 'count(*)' with the same where clause but that seems really brute force. I'll get the snippets of code together and test the scalar() route. Cheers, Rod -- "Open Source Software - Sometimes you get more than you paid for..."
