I agree with Russ - i'm not sure if you can but although i can't test on the machine i'm on at the mo it might be worth looking at whats returned in the metadata (getMetaData) and the query result structure
http://www.succor.co.uk/index.cfm/2006/3/21/The-cfquery-result-structure On 19/04/06, Russ Michaels <[EMAIL PROTECTED]> wrote: > > erm, god knows what this guys reply has to do with your question but. > > No, only selects return a recordcount. > Although SQL does return a message about how many records are updated, but > I cannot recall if this is stored in the query object, so try cfdumping it > and see if its there. > > Russ > > -----Original Message----- > From: "Nashir Sunderji" <[EMAIL PROTECTED]> > To: CF-Talk <cf-talk@houseoffusion.com> > Date: Wed, 19 Apr 2006 08:25:58 +0100 > Subject: RE: Why is there query.recordcount with non-SELECT queries? > > > You log in....go to 'search' and type in search by name the letters > > naf and > > you should be able to find him > > Customer service > > > > > > -----Original Message----- > > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > > Sent: 18 April 2006 16:16 > > To: CF-Talk > > Subject: Why is there query.recordcount with non-SELECT queries? > > > > 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:238069 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