Re: [ cf-dev ] cfprocparam and dates

Damian --Original Message- > Hi, > > I get an error that says "Optional feature not implemented" when doing > this: > > dbvarname="@d_dateNow" > cfsqltype="CF_SQL_DATE"> > > Can anyone tell me why? Happens in MX and CF 5... > > Cheers > d > Perhaps setting the variable w

Re: [ cf-dev ] cfprocparam and dates

*hanging head in shame* -- it was TIMESTAMP that did it: Thanks Ade :) - Original Message - From: "Adrian Lynch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 5:53 PM Subject: RE: [ cf-dev ] cfprocparam and dates > I just tr

RE: [ cf-dev ] cfprocparam and dates

ember 2003 17:41 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cfprocparam and dates Nope, I get the same error when I put the date in statically... - Original Message - From: "Adrian Lynch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 5:35

Re: [ cf-dev ] cfprocparam and dates

tried that, same error. Aye caramba! Has anyone got anything similar that works to compare it to? - Original Message - From: "Colm Brazel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 5:47 PM Subject: RE: [ cf-dev ] cfprocparam a

RE: [ cf-dev ] cfprocparam and dates

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 "

Re: [ cf-dev ] cfprocparam and dates

Nope, I get the same error when I put the date in statically... - Original Message - From: "Adrian Lynch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 5:35 PM Subject: RE: [ cf-dev ] cfprocparam and dates > I've always staye

RE: [ cf-dev ] cfprocparam and dates

ber 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

Re: [ cf-dev ] cfprocparam and dates

e date var is created thusly: (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

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

RE: [ cf-dev ] cfprocparam and dates

] Sent: 11 November 2003 10:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cfprocparam and dates SQL 2000 - Original Message - From: "Neil Robertson-Ravo - Team Macromedia" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 10:06 AM

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 ] c

Re: [ cf-dev ] cfprocparam and dates

SQL 2000 - Original Message - From: "Neil Robertson-Ravo - Team Macromedia" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 10:06 AM Subject: Re: [ cf-dev ] cfprocparam and dates > which db? > > > > > - Origin

Re: [ cf-dev ] cfprocparam and dates

which db? - 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 implemen

[ cf-dev ] cfprocparam and dates

Hi, I get an error that says "Optional feature not implemented" when doing this: 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: