Aye, Kevin be right... But the next logical question is "why would you have a table with no pkey defined at all?" Granted, it'll work, but it's not ideal... maybe I'm just limited in my understanding of things. ;)
Any table should have a primary key defined... how else do you insure that at least one column has unique data? If you can't do that you can't guarantee data integrity... granted, a unique index would work, but a pkey is just so... standard. Screw the unique index, give me a pkey any day. ;) J On Mon, 7 Aug 2006 23:08:25 +0100 "Kevin Roche" <[EMAIL PROTECTED]> wrote: > 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/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
