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? The easiest way with the least number of database connections from ColdFusion I can think of is always delete then insert as many of these can be done in a single transaction. Regards, James --- 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/
