You need to use CF_SQL_TIMESTAMP instead of CF_SQL_DATE.
> -----Original Message-----
> From: Dave Babbitt [mailto:[EMAIL PROTECTED]]
> Sent: 22 October 2001 16:21
> 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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
