You would of course no name a user defined proc with "sp_" :-)
-----Original Message----- From: Paul Arnold [mailto:[EMAIL PROTECTED] Sent: 12 October 2006 22:46 To: SQL Subject: SQL Error Message 22005 I get the following error when trying to access my .cfm page using a stored procedure on MSSQL. Here is the error message: Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification SQL = "sp_SearchResult" Data Source = "artSql" The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (119:1) to (119:147) in the template file D:\HTML\USERS\mysite\HTML\RESULTS_ADV2.CFM. Line 119 of the RESULTS_ADV2.CFM file states: <cfstoredproc procedure="sp_SearchResult" datasource="#MM_connArtSql_DSN#" username="#MM_connArtSql_USERNAME#" password="#MM_connArtSql_PASSWORD#"> I have a feeling it does not have anything to do with this line, but something else in the code. I am looking for someone to help us out off forum, and to help us implement other coldfusion projects on our site. Any help appreciated. Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2580 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
