I would post the whole query... sometimes the line number is not precisely correct :)
-mk Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Matthew Smith [mailto:[email protected]] Sent: Wednesday, February 17, 2010 6:12 PM To: cf-talk Subject: local sql error, not on live site. I have a local install of sql server developer edition 2005. I have used the data base publishing wizard to copy the db from crystaltech to my local server. I am getting an error in a query that does not happen with crystaltech. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision value This is the line: <cfif len(attributes.cfUserID)> AND cfUserID = <cfqueryparam value="#trim(attributes.cfUserID)#" "CF_SQL_VARCHAR"> </cfif> I have also tried "CF_SQL_LONGVARCHAR". The value of trim(attributes.cfUserID) is 1506_18149772. The data type of the column is nvarchar(100). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
