Mathew is correct of course. Also, the CF error rarely ever points to the correct line when the issue is with a SQL statement.
you could wrap your value in val() or try an iif() within the NULL attribute of cfqueryparam if your column allows null values. Matthew wrote: > 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:328754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
