well like i said you might need to mess around with it some but the SQL%ROWCOUNT is the oracle equivilant to mssql servers @@ROWCOUNT
hopefully someone with a bit more oracle expertise (and an available oracle db) can step in here and offer some further insight. On Thu, 18 Nov 2004 16:18:54 +0100, Xavi <[EMAIL PROTECTED]> wrote: > select SQL%ROWCOUNT into numberDeleted FROM DUAL doesn't works, and u > should do 2 cfquery's > [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character > > On Thu, 18 Nov 2004 09:38:52 -0500, Bill Rawlinson > > > <[EMAIL PROTECTED]> wrote: > > i don't know, but I will ask a guy who will and get back to you shortly. > > > > > > > > > > On Thu, 18 Nov 2004 15:33:50 +0100, Xavi <[EMAIL PROTECTED]> wrote: > > > Im using Oracle 8. Is there a CF solution? or only DB one. > > > > > > On Thu, 18 Nov 2004 09:29:11 -0500, Bill Rawlinson > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > If your using MS SQL server there is an easier way to get the number > > > > of rows effected by an update and delete. > > > > > > > > <cfquery name="users" datasource="#request.dsn#"> > > > > SET NOCOUNT ON > > > > > > > > UPDATE user SET role = <cfqueryparam cfsqltype="cf_sql_varchar" > > > > value="newrole"> > > > > WHERE role = <cfqueryparam cfsqltype="cf_sql_varchar" value="oldrole"> > > > > > > > > select @@ROWCOUNT as numberModified from USER > > > > > > > > SET NOCOUNT OFF > > > > > > > > </cfquery> > > > > > > > > if deleting just replace the update statement with the delete > > > > statement but leave the other things alone.. > > > > > > > > you could then reference this number as users.numberModified > > > > > > > > -- > > > > Bill > > > > http://blog.rawlinson.us > > > > > > > > > > > > ---------------------------------------------------------- > > > > You are subscribed to cfcdev. To unsubscribe, send an email > > > > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > > > > in the message of the email. > > > > > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported > > > > by Mindtool, Corporation (www.mindtool.com). > > > > > > > > An archive of the CFCDev list is available at > > > > [EMAIL PROTECTED] > > > > > > > > > > -- > > > Xavi (http://xavicl.blogspot.com) > > > ---------------------------------------------------------- > > > > > > > You are subscribed to cfcdev. To unsubscribe, send an email > > > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > > > in the message of the email. > > > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported > > > by Mindtool, Corporation (www.mindtool.com). > > > > > > An archive of the CFCDev list is available at > > > [EMAIL PROTECTED] > > > > > > > -- > > Bill > > http://blog.rawlinson.us > > ---------------------------------------------------------- > > > > You are subscribed to cfcdev. To unsubscribe, send an email > > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > > in the message of the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported > > by Mindtool, Corporation (www.mindtool.com). > > > > An archive of the CFCDev list is available at > > [EMAIL PROTECTED] > > > > -- > Xavi (http://xavicl.blogspot.com) > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > [EMAIL PROTECTED] > -- Bill http://blog.rawlinson.us ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
