If you just upgraded to MX with this code, you'll need to try the jdbc-odbc
bridge drivers ( if you're not already ) which I'm told com with CF MX
although I couldn't tell you at the moment how to set the datasource up on
them. This is the same problem that lead me to start using <cfstoredproc> in
my content management app. The JDBC drivers don't support the ODBC driver
feature which allows you to return data from a stored procedure using
<cfquery>
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
> <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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
