Damian

----------Original Message---------  

> Hi,
> 
> I get an error that says "Optional feature not implemented" when doing 
> this:
> 
> <cfprocparam type="In" value="#request.d_dateNow#" 
> dbvarname="@d_dateNow"
> cfsqltype="CF_SQL_DATE">
> 
> Can anyone tell me why? Happens in MX and CF 5...
> 
> Cheers
> d
> 

Perhaps setting the variable within the request scope has something to do 
with it? Try setting the variable using plain old 

<cfset d_dateNow = "#CreateODBCDate(Now())#"> 

and just having 

<cfprocparam type="In" value="#d_dateNow#" dbvarname="@d_dateNow"
cfsqltype="CF_SQL_DATE">

in the <cfstoredproc>

Does that work?

Terry

-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to