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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
