Thread: Weird Random ColdFusion error :confused:

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

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.