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
I use PSE 8 for my external editing program and iPhoto '09. This setup is great for what I do. At least until now, as I feel I may be outgrowing iPhoto. I'm wanting to add more information to metadata file info. I have keywords, but I would like to i [More]
Hello. Im new to Java, but I want to import this animated gif with Java in a Japplet using ImageIcon, but it does not work and I would really appreciate if anyone could help me with this. import java.applet.*;                                    impor [More]
I have to use a crappy software to take pictures. How do I fix this? I need a webcam app that has a timer and I was hoping that there'd a be built in webcam app on my laptop that would do the trick. But there's no app in the first place. Help. This q [More]
Hi there, I am using Panasonic GH4 and GX7. And according to my Lightroom 5, it is already the latest version but under the lens crorection profile. I cannot even find the word PANASONIC in the dropdown menu for cameras. Any ideas and tips ? Thank yo [More]
Hi SDN, I have enhanced 2LIS_02_SCL with EKKO-AEDAT field. Steps I have done: 1. Since EKKO is a base table for 2LIS_02_SCL  extractor, I have added AEDAT as is directly(with out ZZ  append to the field) to the MC02M_1SCL communication structure as a [More]
What is the relevance of "additional account assignment category" field while creating purchase order?Hello Ragini, If you entered an account assignment category other than u (unknown) while creating a purchase order then you need to enter addit [More]
Hi The Speech and Startup disc Icons in my system preferences pane have changed to something like a switch. The other accounts on the same mac have no such problems. Any suggestions? THanks MacBook Pro   Mac OS X (10.4.5)  Choose Go to Folder from th [More]
Hello, Just finished a site and two pages do not seem to overwrite. Local preview works fine. Just two pages are missing components and do not render correctly. I tried to re export with different folder locations and re naming pages to no avail. I d [More]
Hi I have a popup window that shows up over flash, and when I close it the flash objects gets all weird. It stops drawing, and does not work properly. If I remove the javascript popup window from the DOM entirely everything is fine. Can someone point [More]
Hello, I have written a program that would allow a user to quickly copy a list of files or directories (including all files in the directories) over a socket in Java. When I am transfering text files, there are no problems, and everyhting transfers p [More]