Very true, not all DBs can handle the multiple query calls... Which means again that CF has to be able to handle different scenarios... Hence, always returning row count.
....................... 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: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 1:02 PM To: CF-Talk Subject: Re: Why is there query.recordcount with non-SELECT queries? 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238027 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
