Scott is right in his guess for the MS SQL Server driver for ColdFusion. It totally disregards the dbvarname attribute of CFPROCPARAM. It relies on positional-notation. Stuff like "optional" parameters don't work with the MS SQL Server driver for ColdFusion.
Also be careful with that BIGINT data type (64 bit integer). ColdFusion's integers are 32bit. If all you do is output the value, you should be fine. Any arithmetic operation on the bigint value will cause the value to be treated as a float, and you immediately lose precision. Good luck! ---------------------------- James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -----Original Message----- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 4:26 PM To: CF-Talk Subject: Re: StoredProc Error From: "Owens, Howard" <[EMAIL PROTECTED]> >[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data >type datetime to bigint is not allowed. Use the CONVERT function to run this >query. What's probably happening is that your <cfstoredproc> call is only providing one of the output parameters declared in your stored_proc. And, I'm not certain how SQL Server handles those parameters with CF, but in some databases, the name you give your cfprocparams doesn't matter, because it looks only at the order you're giving them. So, try providing cfprocparams for each of your Stored_proc parameters in the proper order and see if that does it. Scott -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
