try using varchar instead of datetime datatype?
-----Original Message-----
From: Damian Watson [mailto:[EMAIL PROTECTED]
Sent: 11 November 2003 17:13
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cfprocparam and dates
well.... I'm wondering whether the problem is in using the "where date >"
part of the statement:
CREATE PROCEDURE getEvents
@d_dateNow datetime
AS
SELECT EventID,Title,ShortSummary,EventDate
FROM ContentEvents
WHERE EventDate > @d_dateNow
ORDER BY EventDate
GO
...the date var is created thusly: <cfset
request.d_dateNow="#CreateODBCDateTime(now())#">
(Adrian, prints out {ts '2003-11-11 17:07:29'} )
----- Original Message -----
From: "Adrian Lynch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 11, 2003 4:35 PM
Subject: RE: [ cf-dev ] cfprocparam and dates
> What does the date string look like? Output it to screen.
>
> -----Original Message-----
> From: Damian Watson [mailto:[EMAIL PROTECTED]
> Sent: 11 November 2003 13:15
> To: [EMAIL PROTECTED]
> Subject: Re: [ cf-dev ] cfprocparam and dates
>
>
> Noone got any ideas what this might be?? I'm trying to pass a date
variable
> in to a stored proc on SQL 2000...
>
> ----- Original Message -----
> From: "Damian Watson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 10, 2003 11:31 PM
> Subject: [ cf-dev ] cfprocparam and dates
>
>
> > 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
> >
> >
> >
> > --
> > ** 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]
> >
> >
>
>
>
> --
> ** 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]
>
> --
> ** 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]
>
>
--
** 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]
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003
--
** 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]
