Re: [Reactor for CF] Ambiguous Record Problem

[Ray West]

That was just from typing it into the email. Setting the property does work. I can set it and then output. It is just the load that errors. R Jared Rypka-Hauer wrote: Ditto... I guess my suggestion wasn't much help then, eh? That's what I get for scanning messages instead of actually reading anything. :) I notice there's a space between ID and ( in your snippet below... is that there in the code or is that a transpositional error? Laterz, J On Aug 9, 2006, at 7:23 PM, 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]> 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]>> 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 >     reactor@doughughes.net <mailto:reactor@doughughes.net > >     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 > 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Chris Phillips www.dealerpeak.com Senior Application Developer -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --