As a test, I ran the following code:
<CFSET Reactor = CreateObject("Component",
"reactor.reactorFactory").init(expandPath("reactor.xml")) />
<cfset record = reactor.createrecord("gender")>
<cfset record.setgenderID(2)>
<cfset record.load()>
<cfdump var="#record.getlabel()#">
this returned the label from the record I loaded as expected.
then I went into enterprise manager and removed th PK attribute from
this table. Now I get an ambigious record error too. It it for sure a
primary key issue. when you go into design mode for that table, do you
see the little yellow key icon next to the UserID column?
On 8/10/06, Ray West <[EMAIL PROTECTED]> wrote:
frak... well... it is not working here and I need to be able to pass the
object into a method for processing (not to mention that that is the
better way to do it) so the shortcut method won't work for this.
R
Jared Rypka-Hauer wrote:
> I've been using it just fine with SQL Server for eons... well, not eons,
> but a long time.
>
> I'm trying to think of what the issue could be man. Coming up, as usual,
> with a big fat blank. ;)
>
> J
>
>
> ------------------------------------------------
>
> Jared C. Rypka-Hauer
>
> Continuum Media Group LLC
>
> http://www.web-relevant.com
>
> Member, Team Macromedia - ColdFusion
>
>
> "That which does not kill me makes me stranger." - Yonah Schmeidler
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Aug 10, 2006, at 9:25 AM, Ray West 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] <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/
>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>> -- -- -- --
>>
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- --
> 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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
