Stored procedures is the way to go, otherwise it would be two trips one to check if it exists, the other to perform the action.
If you use stored procedures its one call to the sp.. Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn -----Original Message----- From: Ricardo Russon [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 April 2004 3:16 PM To: CFAussie Mailing List Subject: [cfaussie] SQL Update / Insert Hi guys. is there any way to updade a record to if it the key exists, if not insert it, within the same SQL statment. i don't realy want to be making to trips for this. I remember doing somthing like this a few years ago.. but that might ahve been in (gulp) ASP. TIA Ricardo. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
