I never figured out why recordcount never worked - always returned -1 for whatever reason, and this is not just here - it also happens at work when I'm working with Oracle - go figure.
I typically do -
While NOT RS.EOF(1)
Wend
..and iterate through the recordset.
I think ADO does not work well with many aspects of MySql such as BLOB Objects and Time/Date stamps
GeorgeS
|