Sitemap

Amicuk Programming Answers

Coldfusion.runtime.UndefinedVariableException Error

-0001-11-30   Views:4

Advertisement

We have existing site in CF6 and it is working fine.We have installed CF9 on same server for testing purpose and using the copy of DB/application files that is used for CF6.What happens is that in CF9 it gives the error coldfusion.runtime.UndefinedVa

We have existing site in CF6 and it is working fine.We have installed CF9 on same server for testing purpose and using the copy of DB/application files that is used for CF6.What happens is that in CF9 it gives the error
coldfusion.runtime.UndefinedVariableException: Variable Q_DATA_STAT is undefined
in a CFC file that has the variable Q_DATA_STAT which is used inside a function like 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 I check in sqlserver,and I get the above error from where this CFC fcntion is called.The same CFC file and script works in CF6 even though it also has 0 records.Is there a setting in CF9 to handle the resultset that returns 0 records? Or anyone has idea how to handle this error.
Thanks in advance
Harish

The replay answer
Advertisement
CF9, or CF9.0.1?
There was a bug in CF9 in that - with some combinations of SQL - a zero-row result set would actually not be returned, instead the variable was set to null.
Here's the ticket for it:
http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=82311
I think it was fixed in 9.0.1.  Of course with the CF bug tracker, there's no way to confirm that, other than inferring "closed" means "fixed" (it could mean "not going to fix", or "could not reproduce" - although I know they could reproduce this one - or various other things though).
Adam

Go to See the other 2 answers

Coldfusion.runtime.UndefinedVariableException Error

Category:DefaultRelease time:-0001-11-30Views:130

We have existing site in CF6 and it is working fine.We have installed CF9 on same server for testing purpose and using the copy of DB/application files that is used for CF6.What happens is that in CF9 it gives the error coldfusion.runtime.UndefinedVa[More]

Help coldfusion.runtime.CookieScope error

Category:DefaultRelease time:-0001-11-30Views:130

Hi I'm new. I have a problem I have a web site created with coldfusion and I'm bulding an application in java who insert automatically information in the field of a form in a page of the site and then send this information with the post method. The a[More]

Coldfusion.runtime.CookieScope error in IE

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I receive the following error message: "Element 1 is undefined in a Java object of type class coldfusion.runtime.CookieScope referenced as" when trying to view my site with Internet Explorer 6. I use the customtag cf_inputFilter as a safety[More]

Could not initialize class coldfusion.runtime.report.Report

Category:DefaultRelease time:-0001-11-30Views:130

I have inherited an application that contains a number of reports. This application was developed on our CF7 server, and when we upgraded, the application was copied to 8, but not fully tested. Now, when we request the reports, we get the following e[More]

SesConverter with extension throws coldfusion.runtime.TemplateNotFoundException

Category:DefaultRelease time:-0001-11-30Views:130

Hello, i change my CF application from CF9 to CF10 and have some trouble with my SES URLs now. I use the (SES) Converter (http://developer.fusium.com/tools/ses.cfm) CustomTag to get Search Engine URLS. With Cold Fusion 9 both ways are working correct[More]

I'm trying to download office 365 small business package, and every time I try the website it says there is a runtime service error in the '/' application. Is this my mac or is it the website, and how can I fix it?

Category:DefaultRelease time:2015-10-11Views:130

I'm trying to download office 365 small business package, and every time I try the website it says there is a runtime service error in the '/' application. Is this my mac or is it the website, and how can I fix it?If a phone is sold from one friend t[More]

ITunes crashes when doing a power search. I get a Microsoft Visual C   Runtime Library Error message: Program C:\Program Files (x86)\iTunes\iTunes.exe R6025.  Pure virtual functional call.  If I select ok, Windows 7 pops up with iTunes has stopped working

Category:DefaultRelease time:2015-10-11Views:130

iTunes crashes when doing a power search. I get a Microsoft Visual C   Runtime Library Error message: Program C:\Program Files (x86)\iTunes\iTunes.exe R6025.  Pure virtual functional call.  If I select ok, Windows 7 pops up with iTunes has stopped wo[More]

B575: Microsoft Visual C++ Runtime Library Error on Startup? Please Help!

Category:DefaultRelease time:2015-10-11Views:130

This came out of the blue, I just started up my laptop and out of no where my Windows 7 Ultimate transperancy graphics are gone and I can't connect to the internet! I get this message on startup saying 'Microsoft Visual C++ Runtime Library Error', fo[More]

Microsoft Visual C++ Runtime Library Error in T430S during HP printer install

Category:DefaultRelease time:2015-10-11Views:130

I just bought a T430S Windows 8 and I'm having problems installing the software and drivers for my HP Photosmart D-110-a printer. I've owned the printer for a year and it was no problem installing the software that it came with on my previous Dell Wi[More]

Runtime environment error when starting MaxDB

Category:DefaultRelease time:2015-10-11Views:130

Hi, I downloaded SAPNetWeaver04SneakPreviewSlimSP11.zip edition from the SDN. I followed the preinstallation directions very closely and believe I have the correct environment set up.  However, during the installation process I ran into the following[More]

ITunes Error 7, (windows error 1114) runtime library error R6034

Category:DefaultRelease time:2015-10-11Views:130

Need help, update failed, iTunes Error 7, (Windows error 1114) runtime library error R6034, lost iTune library.Try the following user tip: Troubleshooting issues with iTunes for Windows updatesRead other 4 answers[More]

Hot
This all started when I had a problem with my first pc, a gateway laptop, would not wake up from sleep due to, supposedly, a driver problem. I didn't want to send it off for my free, under-warrantee, repair and be without a computer for however long [More]
I got an X100E nearly a year ago and have never been happy with all the extra 'junk' software that came pre-installed with it.  Sure there are a few useful items, but like many business users, I'd much prefer a clean installation of Windows so I coul [More]
Hello, I have a problems with my macbook pro 13. I do the backup with time machine, but it do really slowly. And at 20%, the system error print the message " error ... The backup can't do... Restart the laptop!" I have done many time on the diff [More]
I am having problems renting a movie from the apple TV. The download only goes to 46%. I have tried changing the resolution to 720, I have gone to the settings and check for rentals it advises that there is no additional rentals found. Any suggestion [More]
Hi My requirement is ABAP program should call java program through JCO. So i have created RFC destination in SAP machine. I have created the java and ABAP programs also for the same. After setting every thing I have executed a function module in ABAP [More]
Hi All, I am trying to export(Instead of running a daily backup using RMAN, I want to schedule a daily export) a Oracle 11gR2 non-ASM database to ASM file system that we have on the server. Basically I want to use ASM file system as the backup direct [More]
Hi I would like to know if there is a standard functinality in Receivables module to send invoices and reminders to client via e-mail? I there is please inform where i can get some information, if not please advise in a few words how we can customise [More]
I'm trying to set up AAA on a new ASA running 8.2(1) and I can't get the ACS (4.2(0) Build 124 Patch 6) and ASA keys to agree for TACACS+. I've done this before on a bunch of systems and it's always been a typo, but I've set both ends to a key of 'a' [More]
Can I restore previous ipad operating system? Not happy with OS7 updateNo.  Downgrading is not supported by Apple.Read other 2 answers [More]
I have just bought a 15" macbook pro retina with Mavericks and FaceTime has never worked. My account works fine on my iPad and iPhone but macbook version just won't connect and says 'FaceTime call failed. Can anyone help?Hello there, alparkinsonpm. T [More]