Hi there , I started working on this project ,already developed by someone in '05 , and the client wants some changes to be done.so i went ahead and did some small modifications to the appearance of the form (insertdata.cfm page) like adding some more options to a drop down menu , changing the label names and so on and am very sure this changes would not have effected the application in any way.And the place where the message says the error can be , i didnt even touch that part.Now after 4 days i start getting this weird error saying " Error Occurred While Processing Request The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code." Null Pointers are another name for undefined values." And this happens randomly not everytime i access the website or different webpages.Here are the errors. FIRST ERROR The error occurred in /export/web/virtual/web3_unt_edu/cps/webaccess/sites/Amarillo/index.cfm: line 8 5 : SELECT UserName,Password FROM user_data WHERE UserName= 6 : <cfqueryparam value="#FORM.UserName#" maxlength="8"> 7 : AND Password= 8 : <cfqueryparam value="#FORM.Password#" maxlength="8"> 9 : </cfquery> 10 : <cfif MM_rsUser.RecordCount NEQ 0> I tried adding " cfsqltype="cf_sql_clob" & varchar but it doesnt work out. SECOND ERROR The error occurred in /export/web/virtual/web3_unt_edu/cps/webaccess/sites/Amarillo/InsertData.cfm: line 13 11 : <cflocation url="#MM_failureURL#" addtoken="no"> 12 : </cfif> 13 : <cfquery name="rsDay" datasource="cps"> 14 : SELECT days FROM days 15 : </cfquery> THIRD ERROR The error occurred in /export/web/virtual/web3_unt_edu/cps/webaccess/sites/Amarillo/InsertData.cfm: line 27 25 : ORDER BY ethnicity ASC 26 : </cfquery> 27 : <cfquery name="rsHospitals" datasource="cps_amarillo"> 28 : SELECT * 29 : FROM hospitals I have attached the screen shots too if anyone wants to take a look. I am having tough time figuring out where the error can be. I am not much experienced with CF. Please if any one can put some light on the error i would appreciate it greatly . Thank you Craj
Use your backup copy to revert the code to its previous state. Then try making the changes one at a time. So it is easier to spot the problems.
When a NULL value is returned it generally is your datasource. I had this experience with Hosting.com ( Formerly HostMySite.com ) I had to write a script that would loop over until it returned no error.