Database related problem(s)

BackupUser · Post by **BackupUser** » Thu Sep 12, 2002 6:22 pm

Restored from previous forum. Originally posted by anil.

Hi,

This is what I want to do. I want to find the total records returned by a query. Is there any shortcut way to find that out? Currently I am using a While NextDatabaseRow()...Wend loop to run a counter to find that out. But the problem here is I am unable to reverse the pointer back to the first record after this loop has finished. I tried the PreviousDatabaseRow command but it was not working after this. Anyone has any ideas?

Thanks,
Anil

BackupUser · Post by **BackupUser** » Thu Sep 12, 2002 8:07 pm

Restored from previous forum. Originally posted by woki.

Hi,

use the SQL statement "select count(*) as totalrecs from TABLE where QUERY" with DatabaseQuery(Request$). Totalrec is a column alias.

Greetings
woki

BackupUser · Post by **BackupUser** » Thu Sep 12, 2002 8:08 pm

Restored from previous forum. Originally posted by woki.

Hi,

use the SQL statement "select count(*) as totalrecs from TABLE where QUERY" with DatabaseQuery(Request$). Totalrec is a column alias.

Greetings
woki

BackupUser · Post by **BackupUser** » Fri Sep 13, 2002 2:39 am

Restored from previous forum. Originally posted by anil.

yes, that is a shorter method indeed. Thanks!