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
