Beth
On 8/10/06, Ray West <[EMAIL PROTECTED]> wrote:
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
