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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
