Okay. I was wrong in my earlier post.
<br />
if ( rs.first() == false ) {....}<br />
That will check for a null query.
Okay. But now for the goofy part. This will move the recordset from BEFORE the First Record to the First Record. Make sense? So now, when you do your
, it will start where? The SECOND record.
Solution: put
BEFORE your
and it will start right back at the beginning.
It was incredibly painful to find this simple information. Why Java doesn’t have a RecordSet.Count or something along those lines, I just do not know. It’s stupid. That’s right. STUPID. You simply have to be easily be able to check for null queries. How else can you have dynamic, database-driven sites with conditional logic?
Thanks to Nash Foster for the help in figuring this out. He dug up the information that was freaking buried at the Java Sun Site.