RE: [Reactor For CF] Duplicate Insert vs. Update?

[Bowden, Beth \(NIH/NIEHS\) [E]]

The base dao.cfc has an “exists” function that returns true or false if the record already exists.   Beth Bowden Phone: 919-541-3355 FAX: 919-541-3687 E-Mail: [EMAIL PROTECTED] Address: NIEHS, MD EC-03, P.O. BOX 12233, Research Triangle Park, NC 27709 From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 2:04 PM To: reactor@doughughes.net Subject: [Reactor For CF] Duplicate Insert vs. Update?   Just thought I'd ask in case I'm missing something within the API. I just realized that if a user attempts to insert a duplicate record using the same primary key values as an existing record, when you call save() reactor will treat it as an UPDATE instead of throwing an error due to a duplicate primary key. I'm sure I could create something that checks to see if the record already exists (which is really what save() does under the hood) and skip the save(), but I wanted to ask the group first if they have any other ideas. Thanks. -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/