If you change something on the server (add a column to a table for example) ColdFusion still holds onto the "old" schema. Consequently it tries to insert into a column that is incorrectly mapped (via the tableid or whatever in the system tables of the db in question).
Here's a post with the scoop. http://www.coldfusionmuse.com/index.cfm/2005/4/29/dbschemaChange To mitigate it you need to force the schema to be recached. Restarting CF does it of course, but so does changing some of your queries - adding a space works well on selects for example. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: fun and learning [mailto:[email protected]] Sent: Monday, November 30, 2009 2:35 PM To: cf-talk Subject: cfsqltype error 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:328748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
