Ray, Can you send me a copy of your "project" generated files?
João Fernandes -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray West Sent: quinta-feira, 10 de Agosto de 2006 15:25 To: [email protected] Subject: Re: [Reactor for CF] Ambiguous Record Problem NP Chris, This is an exception thrown by Reactor and not a CF error. I don't get anything extra when I turn on debugging in CF. A query of some sort apparently runs fine, it just returns unexpected data. I am going to load the new version and see if there is any difference. Have anyone reproduced this or gotten it to run correctly with SQL Server? Ray Chris Phillips wrote: > I appologize Ray. > > I didn't catch that you were saying that > <cfset objUser.setUserID(1) /> > <cfset objUser.load() /> > didn't work > and > <cfset objUser.load(UserID=1) /> > did. > > Which makes this rather wierd. > > If it were me, I'd turn on debugging and watch the queries that CF is > generating to see how they are different. > Let us know what you see. > > Regards, > > Chris > > > On 8/9/06, *Ray West* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > It is... second guess? :-) > > Can anyone repro this? > > Ray > > Chris Phillips wrote: > > First guess is that UserID is not a PrimaryKey. > > > > On 8/9/06, *Ray West* < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: > > > > Hi, > > > > In MS SQL Server, whenever I create a record and do this: > > > > <cfset objUser.setUserID (1) /> > > <cfset objUser.load() /> > > > > I get an ambiguous record error, even though there is only one > > record in > > the table with that ID. > > > > When I do: > > > > <cfset objUser.load(UserID=1) /> > > > > It works fine. > > > > Any help appreciated... > > > > Ray > > > > > > > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > > -- -- -- -- -- > > Reactor for ColdFusion Mailing List > > [email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>> > > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > > < http://www.mail-archive.com/reactor%40doughughes.net/> > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- -- > > > > > > > > > > -- > > Chris Phillips > > www.dealerpeak.com <http://www.dealerpeak.com> > <http://www.dealerpeak.com> > > Senior Application Developer > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- > > Reactor for ColdFusion Mailing List > > [email protected] <mailto:[email protected]> > > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- > Reactor for ColdFusion Mailing List > [email protected] <mailto:[email protected]> > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > <http://www.mail-archive.com/reactor%40doughughes.net/> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- > > > > > -- > Chris Phillips > www.dealerpeak.com <http://www.dealerpeak.com> > Senior Application Developer > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- > 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
