Hi Karl I don't think CFquery has anything comparible to recordssearched in Verity. The only thing I can think of is doing
<CFQUERY name="name" datasource="datasource"> SELECT Count(*) AS allRecords FROM tablename </CFQUERY> Regards Gordon Lipp Systems Technician Guelph Public Library http://www.library.guelph.on.ca > -----Original Message----- > From: Karl Zarudny [mailto:[EMAIL PROTECTED]] > Sent: February 27, 2002 1:55 PM > To: CFUG > Subject: [CFTALKTor] Number of records searched > > > Hi All. > > How does one get the total number of records searched from a query? I > thought it was simply #queryname.recordssearched# but that > kicks back an > "error resolving param" message. Odd, since I seem to remember using > recordssearched once before but perhaps it worked that time > because I was > using it with a verity?.... > > Thanks, > Karl > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: Karl Zarudny > <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Lipp, Gord" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
