Getting Error with CFQUERY and INSERT INTO 1

[dunskii]

Hi All,

When trying to send info to a table using this code:

<CFQUERY datasource=&quot;demo_site&quot; dbtype=&quot;ODBC&quot; name=&quot;AddBasketItem&quot;>
INSERT INTO basket (order_id, prod_id, qty)
VALUES ('#Cookie.BasketID#', '#Form.ProdID#', 1)
</cfquery>

I am getting the error:

Data type mismatch in criteria expression

Error Code: 22005

 

[dallasweb]

Have you tried losing the single quotes on Cookie.BasketID
and Form.ProdID ?
If these are numeric in database it will throw an error with the single quotes.

<CFQUERY datasource=&quot;demo_site&quot; dbtype=&quot;ODBC&quot; name=&quot;AddBasketItem&quot;>
INSERT INTO basket (order_id, prod_id, qty)
VALUES (#Cookie.BasketID#, #Form.ProdID#, 1)
</cfquery>

 

[dunskii]

thanks for your fast reply, i had tried that...it keeps saying that there is something wrong with the CFQUERY statement not the SQL

 

[JHoarty]

A data type mismatch is exactly what dallasweb refers to. That is, you have single ticks (valid for &quot;text&quot; datatype) around a value that is being inserted into a field with a &quot;number&quot; datatype. Can you tell us what the datatypes are for the values order_id, prod_id and qty in the database? John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com