This is one of the most stupidest issues with mdac... You actually need to use cfsqltype="cf_sql_timestamp" for SQL Servers.
-----Original Message----- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 8:21 AM To: CF-Talk Subject: <CFPROCPARAM> Not Working With MSSQL Hi Guys! Thanx to Ian Rutherford's suggestion, I have discovered the source of the problem: <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_DATE" DBVARNAME="@TimeOutDateTime" VALUE="#CreateODBCDateTime(DateAdd('yyyy', 1, Now()))#" > As long as I create my stored procedure without it, and not try to pass the CF version of the ODBC date setting as an input variable, I can call my stored procedure using the <CFSTOREDPROC> tag. But... that kind of defeats the purpose. So, how do I get a date value in there? Thanx Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists