http://www.perlmonks.org?node_id=85871


in reply to Querying Select Number of Rows

set rowcount 11

select
  first_name
from
  database
where
  start_date <= '2001/04/14'
  and stop_date > '2999/12/31'

[download]

Something similar to that concept in your sql may help.... rowcount works with Sybase. MySQL, I dont know.

Update:I took the talk about his posted code out, and realized it just didnt fit in this thread. Regardless, the rowcount idea, kind of follows the suggesstion(s) above.

_14k4 - webmaster@poorheart.com (www.poorheart.com)

In Section Seekers of Perl Wisdom