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.
