set rowcount 11
select
first_name
from
database
where
start_date <= '2001/04/14'
and stop_date > '2999/12/31'
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)