Invalid data '' for CFSQLTYPE CF_SQL_INTEGER

[curro_bravo]

Every time I enter data, I get this error report:

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER

It might be related to this problem:

<cfloop collection="#cities#" item="cityID">

  products["#cityID#"] = [<cfset first = true><cfloop collection="#cities[cityID].products#" item="productID"><cfif first><cfset first = false><cfelse>,</cfif>{value:"#productID#", text:"#cities[cityID].products[productID]#"}</cfloop>];

  </cfloop>

There is a syntax error I cannot find in the line starting with product[

Can anyone help?

Thanks,

[haxtbh]

I don't think this error relates to that line of code.

The error you are getting means that you are trying to pass a non integer to a cfqueryparam tag which has the type of integer specified. Which means that this error will be in a "cfquery" tag.

If you log into the coldfusion administrator and look at the logs (Application.log or coldfusion-out.log) it may tell you the line number of the error making it easier to find.

[CutterBl]

If the value you are passing in is empty, and your database column allows nulls, then you might want to look at the "null" attribute of the cfqueryparam tag.

[curro_bravo]

I have review your answer, and you are absolutely right. I have found that I have a conflict between two programs. One is known as raw_materials_decision_action and the second is raw_materials_decision.

The first one state that the rawMat variable is a money variable, and the second, practically states it as an integer.

Except, that I do not know how to correct the second variable, in spite that I have tried.

Thank you very much.

You were very kind.

[BKBK]

Rewrite the code in the following way, and you will find that there are quite a few things that don't quite match up:

<cfloop collection="#cities#" item="cityID">

products["#cityID#"] = [

<cfset first = true>

<cfloop collection="#cities[cityID].products#" item="productID">

    <cfif first>

        <cfset first = false>

    <cfelse>

        ,

    </cfif>

    {value:"#productID#", text:"#cities[cityID].products[productID]#"}

</cfloop>

];

</cfloop>

[curro_bravo]

Thank you. I have already made the change. I have not been able to know if it will work, because, I have not been able to test the change yet.

But, it appears to be a great improvement.

I appreciate very much your kind assistance,