<CFQUERY NAME="newQuery" DATASOURCE="DATASOURCE">
{call procedure( #argument1#, #argument2#, #argument3# )}
</CFQUERY>

<CFSET return = #newQuery.returnID#>


Source above... its a simple no brainer which works on older versions of CF
using the same datasource.  I've double checked the result set from the over
and over again.  I can't figure it out.  Here is the Error I recieve:

Error Occurred While Processing Request
Element RETURNID is undefined in NEWQUERY.

-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 5:14 PM
To: CF-Talk
Subject: Re: Referencing Query Object


> Has anyone seen anything funky when reference elements in
> query objects
> using stored procs, MSSQL 2000?  I've double checked the
> result set numerous
> times, and verified the field i'm referencing is indeed
> returned, however
> everytime I try to reference the field in CF, I get an
> undefined element
> error?  Any help would be much appreciated it.

I'd have to see the cf code to really offer helpful advice...

Did you recently upgrade to MX?
And are you using <cfstoredproc> or <cfquery> ?


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to