Never tried it on Oracle. It works great on MS SQL 7.
Check the Oracle docs for the correct SQL format of the statement and it
should work
Chris
----------------------------------------------
Original Message
From: "Frédéric LeMieux"<[EMAIL PROTECTED]>
Subject: RE: [Another Way...]Checking for a record, and then deleting it
Date: Fri, 23 Jun 2000 09:52:08 -0400
>hmmm.... I never saw that kind of SQL statement. So I tried, and it is not
>working !
>The Oracle Database returns "Invalid SQL statement".
>
>Where did you see that king of statement ? Can you give me more information
>on how to make this king of SQL working ?
>
>
>-----Original Message-----
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 23, 2000 9:48 AM
>To: [EMAIL PROTECTED]
>Subject: Re:[Another Way...]Checking for a record, and then deleting it
>
>
>Or you could do it all via SQL:
>
><CFQUERY datasource="bwpc" name="TestForExistingQuote">
>IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
>CFTOKEN=#CFTOKEN#)) > 0)
> DELETE FROM SystemQuote WHERE CFID = #CFID#
></cfquery>
>
>Chris
>----------------------------------------------
>Original Message
>From: "Chris Terrebonne"<[EMAIL PROTECTED]>
>Subject: Re:Checking for a record, and then deleting it
>Date: Fri, 23 Jun 2000 08:43:08 -0500
>
>>Just test for the RecordCount...
>>
>><CFQUERY datasource="bwpc" name="TestForExistingQuote">
>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>></cfquery>
>>
>><CFIF TestForExistingQuote.RecordCount>
>> <CFQUERY datasource="bwpc">
>> DELETE FROM SystemQuote WHERE CFID = #CFID#
>> </cfquery>
>></cfif>
>>
>>----------------------------------------------
>>Original Message
>>From: "Chris Farrugia"<[EMAIL PROTECTED]>
>>Subject: Checking for a record, and then deleting it
>>Date: Thu, 22 Jun 2000 21:24:46 -0400
>>
>>>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX
>>>(which is an array that I used CFWDDX on), and the date. It is for a
>>system
>>>configurator for new computer systems. When someone fills in the forms
>for
>>>what they want on their system, it puts it in a database, then they can
>>>click a reconfigure button... that takes them back to the form they just
>>>filled out so they can reconfigure their system. THen they hit the
submit
>>>button again and here I need to check if a record in the quotes table
>>>already exists (meaning this is at least the second time they've
>configured
>>>a system), and if it exists, then that record needs to be deleted. Here
>is
>>>the code I've tried but it doesn't work:
>>>
>>><CFQUERY datasource="bwpc" name="TestForExistingQuote">
>>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>>></cfquery>
>>>
>>><CFOUTPUT Query="TestForExistingQuote">
>>><CFIF IsDefined('#WDDX#')>
>>> <CFQUERY datasource="bwpc">
>>> DELETE FROM SystemQuote WHERE CFID = #CFID#
>>> </cfquery>
>>></cfif>
>>></cfoutput>
>>>
>>>
>>>Does anybody know of a way of doing this? Thanks in advance.
>>>
>>>-------------------------------------------------------------------------
-
>-
>>---
>>>Archives: http://www.eGroups.com/list/cf-talk
>>>To Unsubscribe visit
>>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>>the body.
>>>
>>
>>_____________________________________________
>>Free email with personality! Over 200 domains!
>>http://www.MyOwnEmail.com
>>
>>--------------------------------------------------------------------------
-
>---
>>Archives: http://www.eGroups.com/list/cf-talk
>>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>
>_____________________________________________
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>
>---------------------------------------------------------------------------
-
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
