We're talking MS SQL here but it was more curiosity rather than anything else.
Thanks though James > -----Original Message----- > From: Jon Austin [mailto:[EMAIL PROTECTED] > Sent: Thursday, 11 November 2004 3:46 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: [Slightly OT] Database INSERT or UPDATE > > > Which DBMS? > > I would probably create a stored procedure for this; you only make one > connection fro CF -> DB, it does all the grunt. > > I had the same requirement the other day, I just did it in code. No > need to reuse for this app. > > Regards, > > Jon > > On Wed, 10 Nov 2004 17:56:54 +1100, James Macpherson > <[EMAIL PROTECTED]> wrote: > > Hey all, > > > > Just a quick question which is possibly a mental blank in > my department; > > > > Is it possible in a single statement to do an update if a > record exists or an insert if it doesn't? > > > > I could do it with a trigger but I'm curious as to whether > there is a SQL command that covers this? > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
