coldfusion.runtime.UndefinedVariableException Error

we have existing site in cf6 , working fine.we have installed cf9 on same server testing purpose , using copy of db/application files used cf6.what happens in cf9 gives error

coldfusion.runtime.undefinedvariableexception: variable q_data_stat undefined

in cfc file has variable q_data_stat used inside function this

<cffunction name="get_total_status" access="public" returntype="query">

 

<cfquery maxrows="#arguments.top#" name="q_data_stat" datasource="#application.datasource#">

 

the query in actual returns 0 records if check in sqlserver,and above error cfc fcntion called.the same cfc file , script works in cf6 though has 0 records.is there setting in cf9 handle resultset returns 0 records? or has idea how handle error.

 

thanks in advance

harish

cf9, or cf9.0.1?

 

there bug in cf9 in - combinations of sql - zero-row result set not returned, instead variable set null.

 

here's ticket it:

http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugid=82311

 

i think fixed in 9.0.1.  of course cf bug tracker, there's no way confirm that, other inferring "closed" means "fixed" (it mean "not going fix", or "could not reproduce" - although know reproduce 1 - or various other things though).

 

--

adam

More discussions in ColdFusion Server Administration

adobe