Yes, at least if you want to be able to update records using the reactor generated code.
Kevin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marc Funaro Sent: 07 August 2006 21:07 To: [email protected] Subject: RE: [Reactor for CF] Save Problem So basically, it is a given that ALL tables with which reactor interacts, MUST have a primary key defined specifically. (in mssql, "the little yellow key must appear on at least one field/column in design view!") Yes? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Roche > Sent: Monday, August 07, 2006 3:33 PM > To: [email protected] > Subject: RE: [Reactor for CF] Save Problem > > 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/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - - -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
