Ray, I had the same problem on a table without a primary key. Might be worth checking it.
Kevin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ray West Sent: 07 August 2006 19:57 To: [email protected] Subject: [Reactor for CF] Save Problem Hi, I am having a similar problem to Tom below. Using SQL Server and a numeric Identity column, I can load a record, verify that it is loaded correctly, change something and save() and it ALWAYS creates a new record. Code is below. In the body section below, the first cfoutput shows the correct info, but the second after the save shows a new ID that was created by the Identity column in the DB on save(). <!--- create the reactorFactory ---> <cfset Reactor = CreateObject("Component", "reactor.reactorFactory").init(expandPath("reactor.xml")) /> <!--- create a userGateway ---> <cfset User = Reactor.createRecord("Company").load(ID=2) /> <cfset User.setDBA("Test DBA") /> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <!--- dump the results ---> <cfoutput>#User.getID()# #User.getName()# #User.getDBA()#</cfoutput><br /> <cfset User.save() /> <cfoutput>#User.getID()# #User.getName()# #User.getDBA()#</cfoutput> </body> </html> Any help is appreciated. Ray -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - - -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
