yeah, but enddate isn't required by the db, because there won't always be
one...
Ian W
- Original Message -
From: "Kevin Faulkner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 5:27 PM
Subject: RE: [ cf-dev ] syntax err
Wouldnt be faster?
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent: 30 September 2003 09:31
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] syntax error
yeah, it was that. I changed the code to
and now it works fine.
ta ;-)
Ian W
- Original Message
yeah, it was that. I changed the code to
and now it works fine.
ta ;-)
Ian W
- Original Message -
From: "Kevin Faulkner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 5:27 PM
Subject: RE: [ cf-dev ] syntax error
>
seems like a null enddate?
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 17:18
To: cfug dev list
Subject: [ cf-dev ] syntax error
another good old syntax error. I've stared at this for half an hour, can't
see what's wrong. anyone else any ideas?
check your value for enddate, it's trying to insert a null value just now:
{d '2003-10-04'}, , 0,
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
---
y 29, 2003 3:51 PM
Subject: Re: [ cf-dev ] syntax error...
> is it not being treated as a text string now?
>
--
** 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 he
nal Message -
From: "Ian Westbrook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 3:37 PM
Subject: Re: [ cf-dev ] syntax error...
> doesn't seem to make any difference to it working, but at least I'm
getting
> a _differe
the date is definitely the problem, tho, cause if I comment out that section
of the query it works...
Ian W
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 3:44 PM
Subject: Re: [ cf-dev ] syntax error...
> but can y
is it not being treated as a text string now?
well, that's what i thought, whihc is why originally it was unquoted...
Ian W
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 3:44 PM
Subject: Re: [ cf-dev ] syntax error...
> but can you do a greater/less than t
but can you do a greater/less than test succesfully on a text date string
such as this in quotes?
-
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 3:26 PM
Subject: Re: [ cf-dev ] syntax error...
> I reackon it might be the quoteless dates!
>
> In a message dated 29/07/2003 15:25:59 GMT Daylight Time,
> [EMAIL PROTECTED] writes:
>
well, there's some concensus, so I'll give that a go! ;-)
sure it worked last time I tried it a few days ago, tho...
ta
Ian W
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 3:26 PM
Subject: Re: [ cf-dev ]
I reackon it might be the quoteless dates!
In a message dated 29/07/2003 15:25:59 GMT Daylight Time,
[EMAIL PROTECTED] writes:
> -Original Message-
> From: Ian Westbrook [mailto:[EMAIL PROTECTED]
> Sent: 29 July 2003 15:16
> To: cfug dev list
> Subject: [ cf-dev ] syntax error...
>
>
Is it not something to do with your dates? Shouldn't they be in quotes:
i.e.
diary.startdate >= 'Tuesday July 29, 2003'
Instead of how you have it:
diary.startdate >= Tuesday July 29, 2003
Tim.
---
RAWNET LTD - Internet, New Media and ebu
Have you tried quoting the date?
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent: 29 July 2003 15:16
To: cfug dev list
Subject: [ cf-dev ] syntax error...
Hi
been staring at this for half an hour now, and can't see what's wrong with
it. anyone else have an idea?
th
don't you need ' ' around your date string? i.e. instead of
diary.startdate >= Tuesday July 29, 2003
it should say
diary.startdate >= 'Tuesday July 29, 2003'
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative sol
17 matches
Mail list logo
