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:238017 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