My guess is that "#somevalue#" returned an empty string, which is the wrong data type for an SQL_integer field...the data should be numeric..
On 30 Nov 2009, at 20:34, fun and learning <[email protected]> wrote: Hi All, I am getting the following error when I am trying to insert data into the database: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER The line one which the error is shown is using a <cfqueryparam cfsqltype="cf_sql_varchar" value = "#somevalue#"> but the error says cf_sql_integer. can anyone please let me know what could possibly have gone wrong? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
