Ray,
Somehow reactor is not viewing your primary as it is. Are you in production
mode?
Set it to development and generate again your files. Check the
project/userDao.cfc. Inside the function read, you currently have this
<cfif Len(arguments.loadFieldList)>
<cfset UserQuery = UserGateway.createQuery() />
<cfloop list="#arguments.loadFieldList#"
index="field">
<cfset UserQuery.getWhere().isEqual("User",
field, arguments.to[field]) />
</cfloop>
<cfset qRead =
UserGateway.getByQuery(UserQuery,true) />
<cfelse>
<cfset qRead = UserGateway.getByFields(
) />
</cfif>
See the <cfset qRead = UserGateway.getByFields() /> part? It's here that
he's messing because he couldn't get the primary key.
HTH,
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:46
To: [email protected]
Subject: Re: [Reactor for CF] Ambiguous Record Problem
Sent, thanks.
R
João Fernandes wrote:
> 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/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
>
>
>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
