|
| |
|
|
Guest
 |
How can a DB query and Count() go into same... - 3/13/2001 21:20:00
I can't figure out how to include a Count() of the results brought back by a query. I have a query:
"Select * FROM results WHERE" & query & ""ORDER BY Timestamp DESC" Is it possible to include a Count() of the results of the query in the above query? Thanks for your help, Pete Moss
|
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: How can a DB query and Count() go into same... - 3/14/2001 15:19:00
Theres a couple of ways Pete, one is, if you are looping through records to manualy count them like:recCount = recCount + 1 do that within the loop and then write the value of "recCount" Another is to use a client side cursor and use the obj.RecordCount method ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
