now I get: ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification SQL = "sp_psactualsbyweek" -----Original Message----- From: S. Isaac Dealey [mailto:info@;turnkey.to] Sent: Thursday, November 07, 2002 10:22 AM To: CF-Talk Subject: Re: Stored proc help > Hello all > I am trying to call a storedproc from an SQL 7 db. > and I get this error. Does anyone know what it means. > ODBC Error Code = S1C00 (Driver not capable) > [Microsoft][ODBC SQL Server Driver]Optional feature not implemented > I have tested the connection through CF admin and it tests ok. > If I leave out a param. I get the error the param is missing. > SO I think the connection to the db if ok. > Thanks > Rodney This usually means you're using cfsqltype="cf_sql_date" ... change that to cfsqltype="cf_sql_timestamp" and you should be good to go. :) S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
