Is there another solution to this Ricardo? what is it you are trying to do? we do this sort of thing often by making two trips.. sometimes you just have to. But sometimes there is a work around. What app is giving you the problem.
Gareth. -----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
