Skip to main content
M
mohdsiraj
Participant
August 12, 2009
Question

Wierd ColdFusion erro : Error occurred while processing request.

  • August 12, 2009
  • 2 replies
  • 3365 views

Hi there ,

I am a graduate student and new to ColdFusion.I started working on this already developed project by someone couple of years ago , 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.

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"  " in cfqueryparam also on my friends advice , but it doesnt work out.

2nd 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>


3rd 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

Can anyone help me with this. I have to get the modifications done in 2 weeks.
Thank you
Craj

    This topic has been closed for replies.

    2 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    August 16, 2009

    1st error

    It seems  there isn't a field called 'password' in the form. Verify this.

    2nd and 3rd error

    It seems the datasources, cps and cps_amarillo, aren't well defined in the Coldfusion Administrator. Verify this.

    M
    mack_
    Participating Frequently
    August 13, 2009

    For the first error try using cfsqltype="cf_sql_varchar". For the

    second and third errors there's no error message in your message so

    unless you're a computer-mind-reader it's quite hard to understand

    what the problem might be.

    Mack

    M
    mohd_siraj
    Participant
    August 13, 2009

    Hi mack,

                I appreciate you're help , but i already tried that cfsqltype="cf_sql_varchar" for my first error and it doesnt work . Coming to the 2nd and 3rd error its the same error message i am getting saying that " 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 then it displays the same lines of code which i gave in my first post. Now i m trying to use the CFAdministrator's log file and debuggin tools to find it . Lets hope it works out. If u find anythng else abnormal pls let me know.

    Thank you

    Craj

    M
    mack_
    Participating Frequently
    August 14, 2009

    Can you paste the full stack trace for those errors ? (I think you

    need to enable Robust Exceptions - in the CF Admin Debugging

    department - to see the stack trace )

    Mack

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices