there must be a way to return the number of record from a query, without having to do a count in the query. Can't I somehow refer to the query and get a recordcount with some kind of code?
rs.getrows() give you a 2D array, the upper bound of it is nothing but the record count.
See in ColdFusion, I can write the simple, following code to retunr the numbers of records.<BR><BR><cfoutput>#getResults.Re cordCount#</cfoutput<BR><BR>getResults is the name of my query. There must be similar cod ein ASP to do this.
Thanks though to all who helped!