Note on the minor comment: not all db's will allow this. On 4/18/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > Minor comment, but I often will run an Update and a select in the same > CFQuery statement... This will return rows/recordcount (potentially). > ColdFusion doesn't know that this is happening as it is just sending the SQL > command to the Database. SQL is the only player that knows whether or not > rows will be returned, so CF has to be ready in case. > > ....................... > Ben Nadel > Web Developer > Nylon Technology > 350 7th Ave. > Suite 1005 > New York, NY 10001 > 212.691.1134 x 14 > 212.691.3477 fax > www.nylontechnology.com > > Sanders: Lightspeed too slow? > Helmet: Yes we'll have to go right to ludacris speed. > -----Original Message----- > From: Rob Wilkerson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 18, 2006 11:32 AM > To: CF-Talk > Subject: Re: Why is there query.recordcount with non-SELECT queries? > > Sorry, I should have been more clear. I meant that the return value > (queryname.recordCount) was not useful. Not the count itself. > > On 4/18/06, Mike Klostermeyer <[EMAIL PROTECTED]> wrote: > > I wouldn't say that. Sometimes it is helpful to know how many records > > were updated or deleted without having to do a select query > > beforehand. Is there a Java service factory way of getting at this > information? > > > > Mike > > > > -----Original Message----- > > From: Rob Wilkerson [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, April 18, 2006 10:22 AM > > To: CF-Talk > > Subject: Re: Why is there query.recordcount with non-SELECT queries? > > > > > > As I recall, the value gets returned, but always says "0". It's not > > useful for anything other than select queries. > > > > On 4/18/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > > Should queries that do an update return a queryname.recordcount > > > variable? I'm trying to determine how many records get changed > > > during an update statement. > > > > > > Pete > > > > > > > > > > > > > > > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238018 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
