Known Participant

Answered

CFSQLTYPE CF_SQL_INTEGER

Forum|Forum|15 years ago
January 24, 2011
1 reply
6466 views

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!

Getting started

This topic has been closed for replies.

Correct answer -__cfSearching__-

<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.

-

-__cfSearching__-

Inspiring

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

_

_Bryan_Author

Known Participant

Here's the form page and update page:

**** ERROR MESSAGE ****

Invalid data #GetDetail.QQS_ID# for CFSQLTYPE CF_SQL_INTEGER.

The error occurred in C:\ColdFusion9\wwwroot\QQSTracker\QQS_Update2.cfm: line 1

1 : <CFUPDATE datasource="qqstrack" Tablename="Detail">
2 : <cflocation url="Proj_List.cfm">

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SearchToolbar 1.2; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.2; MS-RTC LM 8)
Remote Address	127.0.0.1
Referrer	http://127.0.0.1:8500/QQSTracker/QQS_Edit2.cfm?QQS_ID=22
Date/Time	24-Jan-11 11:25 AM

**** FORM PAGE ****

<cfquery name="GetDetail" datasource="qqstrack">
SELECT *
FROM detail
WHERE QQS_ID = #url.QQS_ID#
</cfquery>

<table width="770" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" align="center" colspan="3"><img src="images/header_1.jpg" border="0"><br>
<img src="images/header_2.jpg" border="0"><br><img src="images/boxtop.jpg" border="0"></td>
</tr>
<tr>
<td width="18" id="sideleft"> </td>
<td width="744" id="boxinside">
   <cfoutput query="GetDetail">
      <table width="100%" cellpadding="5" cellspacing="0">
    <tr>
     <cfif #ProjectName# IS "No">
     <td valign="top" id="ProjName" colspan="2"><input type="text" name="ProjectName" size="30" value="#ProjectName#"></td>
     <cfelse>
     <td valign="top" id="ProjName" colspan="2">#ProjectName#</td>
     </cfif>
    </tr>
    <tr>
     <td valign="top" width="185" id="leftpane" style="padding:10px">
     <table width="100%" cellpadding="5" cellspacing="2">
      <tr>
       <td valign="top" id="text3"><b>Start Date</b>:
       <input type="text" name="Start_date" size="8" value="#dateformat(Start_Date, "mm/dd/yyyy")#"></td>
      </tr>
      <tr>
       <td valign="top" id="text3"><b>Due Date</b>:
       <input type="text" name="Due_Date" size="8" value="#dateformat(Due_Date, "mm/dd/yyyy")#"></td>
      </tr>
      <tr>
       <td valign="top" id="text3"><b>Target Date</b>:
       <input type="text" name="Target_Date" size="8" value="#dateformat(Target_Date, "mm/dd/yyyy")#"></td>
      </tr>
      <tr>
       <td valign="top" id="text3"><b>Actual Date</b>:
       <input type="text" name="Actual_Date" size="8" value="#dateformat(Actual_Date, "mm/dd/yyyy")#"></td>
      </tr>
      <tr>
       <td valign="top" id="text2"><b>Agency</b><br>
       <input type="text" name="agency" size="20" value="#agency#"></td>
      </tr>
      <tr>
       <td valign="top" id="text2"><b>Lead<b></br>
       <input type="text" name="lead" size="20" value="#lead#"></td>
      </tr>
      <tr>
       <td valign="top" id="text2"><b>Campaign: <b>
        <select name="Campaign">
        <option value="#Campaign#" selected>#Campaign#
        <option value="Infrastructure Building">Infrastructure Building
        <option value="Demand Generation">Demand Generation
        </select></td>
      </tr>
      <tr>
       <td valign="top" id="text2"><b>Funding Source: <b>
        <select name="Funding">
        <option value="#Funding#" selected>#Funding#
        <option value="Campaigns">Campaigns
        </select></td>
      </tr>
     </table>
     </td>
     <td valign="top" width="510" style="padding:10px">
     <table width="100%" cellpadding="0" cellspacing="4">
      <tr>
       <td valign="top" id="rightpane">
       <table width="100%" cellpadding="3" cellspacing="0">
        <tr>
         <td valign="top" id="tableheader">QQS Status</td>
         <td valign="top" id="tableheader">Dev Status</td>
         <td valign="top" id="tableheader">Phase</td>
         <td valign="top" id="tableheadernohr">Target Quarter</td>
        </tr>
        <tr>
         <td valign="top" id="text">
          <select name="Status">
          <option value="#Status#" selected>#Status#
          <option value="Proposed">Proposed
          <option value="QQS sent to vendor">QQS sent to vendor
          <option value="SOW sent to vendor">SOW sent to vendor
          <option value="Submitted for approval">Submitted for approval
          <option value="Approved">Approved
          </select></td>
         <td valign="top" id="text">
          <select name="Dev_Status">
          <option value="#Dev_Status#" selected>#Dev_Status#
          <option value="Planned">Planned
          <option value="In-progress">In-progress
          <option value="Completed">Completed
          </select></td>
         <td valign="top" id="text">
          <select name="Phase">
          <option value="#Phase#" selected>#Phase#
          <option value="Not Started">Not Started
          <option value="Development">Development
          <option value="On-going">On-going
          <option value="Completed">Completed
          </select></td>
         <td valign="top" id="textnohr">
          <select name="Target_Quarter">
          <option value="#Phase#" selected>#Target_Quarter#
          <option value="Q1">Q1
          <option value="Q2">Q2
          <option value="Q3">Q3
          <option value="Q4">Q4
          </select></td>
        </tr>
       </table>
       </td>
      </tr>
      <tr>
       <td valign="top" id="rightpane2">
       <table width="100%" cellpadding="3" cellspacing="0">
        <tr>
         <td valign="top" id="tableheader">Project Cost</td>
         <td valign="top" id="tableheader">Q1 Cost</td>
         <td valign="top" id="tableheader">Actual Q1 Cost</td>
         <td valign="top" id="tableheadernohr">Actual Q1 Cost</td>
        </tr>
        <tr>
         <td valign="top" id="text"><input type="text" name="Project_Cost" size="10" value="#Project_Cost#"></td>
         <td valign="top" id="text"><input type="text" name="Q1_Costs" size="10" value="#Q1_Costs#"></td>
         <td valign="top" id="text"><input type="text" name="Actual_q1_Costs" size="10" value="#Actual_q1_Costs#"></td>
         <td valign="top" id="textnohr"><input type="text" name="Agency_Estimate" size="10" value="#Agency_Estimate#"></td>
        </tr>
       </table>
       </td>
      </tr>

</table>
     </td>
    </tr>
    <tr>
     <td valign="top" align="center" colspan="2" style="border-top: solid 1px abcabe;">
     <input type="submit" value="Update">
     </td>
    </tr>
      </table>
   </cfoutput>
</td>

</tr>

</table>

</form>

****** UPDATE PAGE *****

-

-__cfSearching__-Correct answer

Inspiring

<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.

Invalid data #GetDetail.QQS_ID# for CFSQLTYPE CF_SQL_INTEGER.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded