If you did an export from one server to the other, you may have found that some datatypes didn't copy correctly.
> -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED] > Sent: 27 February 2003 14:07 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] CF & SQL Server Error > > > 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]
