SQL error with 2 statements

[woodywyatt]

Hi
Can anyone tell me whats wrong with this SQL statement below?
The first bit is supposed to only show records less than 1 year old (which
works fine on it's own) and the next a standard query for a search form
(also works fine on it's own).
I'm trying to put both statements together on one page but I keep getting
errors when I test the statement.

SELECT *
FROM upload
WHERE Date>DateAdd('yyyy',-1,Now()); WHERE area = 'varName' AND pax LIKE
'varName2' AND rooms LIKE 'varName3

[Julian Roberts]

You've got WHERE in there twice

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[woodywyatt]

Hi Jules
Excuse my ignorance but do I just leave it out? Something like -

SELECT *
FROM upload
WHERE Date>DateAdd('yyyy',-1,Now()); area = 'varName' AND pax LIKE
'varName2' AND rooms LIKE 'varName3

Thanks
Gary

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d3b18d$fpj$1@forums.macromedia.com...

> You've got WHERE in there twice
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>

[Julian Roberts]

You'd already got most of the logic sussed, you'd use AND. ie

SELECT *
FROM upload
WHERE Date>DateAdd('yyyy',-1,Now()) AND area = 'varName' AND pax LIKE
'varName2' AND rooms LIKE 'varName3


--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[woodywyatt]

Thanks for your hepl Julian
I found it worked the other way round with variable first -

SELECT *
FROM upload
WHERE area = 'varName' AND pax LIKE 'varName2' AND rooms LIKE 'varName3'AND
Date>DateAdd('yyyy',-1,Now())

Cheers
Gary


"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d3b3l2$if0$1@forums.macromedia.com...

> You'd already got most of the logic sussed, you'd use AND. ie
>
> SELECT *
> FROM upload
> WHERE Date>DateAdd('yyyy',-1,Now()) AND area = 'varName' AND pax LIKE
> 'varName2' AND rooms LIKE 'varName3
>
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>