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
ug dev list" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]cc:
eam.net>
another good old syntax error. I've stared at this for half an hour, can't see what's
wrong. anyone else any ideas?
SELECT *
FROM story_info
WHERE name = 'gardner'
AND story_type = 'diary'
AND
(( event_start_date >= #fromdate#)
OR
( event_end_date >= #fromdate#))
INSERT INTO dia
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
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 ha
"Ian
Westbrook" To: "cfug dev list" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]cc:
Hi
been staring at this for half an hour now, and can't see what's wrong with it. anyone
else have an idea?
this is the query:
SELECT diary.id AS diaryid, diary.directoryid, diary.artform AS diaryartform,
diary.*, directory.id AS directoryid, directory.fullname, directory.town, towns.id AS
19 matches
Mail list logo
