well it looks to me like the data type is wrong for the field you're trying to insert the string into. sure it's not an error in either the setup of the table, or the stored procedure code?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Paul Johnston" <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> tions.com> cc: Subject: [ cf-dev ] CF & SQL Server Error 02/27/03 02:06 PM Please respond to dev Okay... 2 servers, one dev, one live On one server, there is no error. On another server, I get this error: ----------code---------- Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value 'http://hiddenserver/blah/download.shtml' to a column of data type bit. SQL = "spMyStoredProc" Data Source = "MYDSN" The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (89:3) to (89:106) in the template file D:\MY\PATH\ORDERLATEST.CFM. Date/Time: 02/27/03 14:01:45 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 213.107.176.214 HTTP Referrer: https://hiddenserver/my/path/orderlatest.cfm ----------code---------- Any ideas (despite telling the client they need to sort out their dev and live servers)? Paul ------------------------------------------- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
