Thanks everybody. Gordon you hit the nail bang on, as far as what I was trying to do. Too bad this is the only way to do it.... Would've thought that CF being the elegant and efficient language it is, there'd be some way to pull it out without having to perform the main query and then a subsequent query to get the total records searched. Guess it's not a highly demanded or required option.
Thanks again everybody! > From: "Lipp, Gord" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Wed, 27 Feb 2002 14:33:02 -0500 > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: RE: [CFTALKTor] Number of records searched > > 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) - 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)
