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:330856
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
