Skip navigation
<Bryan\>
Currently Being Moderated

CFSQLTYPE CF_SQL_INTEGER

Jan 24, 2011 9:03 AM

Using ColdFusion 9/Standalone, Access database

Can anyone tell me what this error means (CFSQLTYPE CF_SQL_INTEGER)? I received it while processing a simple form. Is it related to the data being processed or something to do with how the field is defined in Access?

 

Thanks!

 
Replies
  • Currently Being Moderated
    Jan 24, 2011 9:05 AM   in reply to

    Could you post the code used and the full error message?

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 24, 2011 9:32 AM   in reply to
    <input type="hidden" name="QQS_ID" value="#GetDetail.QQS_ID#">

     

    The error means the value provided for QQS_ID is not an integer.  It looks like you are missing <cfoutput> tags around the input field. So the field literally contains the string "#GetDetail.QQS_ID#", not the value of that variable.

     

    WHERE QQS_ID = #url.QQS_ID#

     

    As an aside, it is good to get into the habit of using cfqueryparam on all query parameters.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points