brain fart

[WebSlave]

I can not for the life of me remember how to do the following: I want my
recordset to display the following: SELECT * FROM INVENTORY WHERE TYPE = 'NEW'
AND SUBTYPE = 'CLASS A' OR SUBTYPE = 'CLASS B' OR SUBTYPE = 'CLASS C' When I
do this, it selects those subtypes, but it is pulling both 'New' & 'Used'.
Please advise. Also, is it bad coding to rename Repeat1 to something unique
like RepeatNEWINVENTORY?

[Anthony Brown]

SELECT * FROM INVENTORY WHERE TYPE = 'NEW'
AND SUBTYPE = 'CLASS A' OR TYPE = 'NEW' AND SUBTYPE = 'CLASS B' OR TYPE =
'NEW' AND SUBTYPE = 'CLASS C'

I think, but I haven't finished my morning coffee yet :-)


"WebSlave" <webforumsuser@macromedia.com> wrote in message
news:d19gu5$h1c$1@forums.macromedia.com...

>I can not for the life of me remember how to do the following: I want my
> recordset to display the following: SELECT * FROM INVENTORY WHERE TYPE =
> 'NEW'
> AND SUBTYPE = 'CLASS A' OR SUBTYPE = 'CLASS B' OR SUBTYPE = 'CLASS C'
> When I
> do this, it selects those subtypes, but it is pulling both 'New' &amp;
> 'Used'.
> Please advise. Also, is it bad coding to rename Repeat1 to something
> unique
> like RepeatNEWINVENTORY?
>

[middletree]

As Anthony says, you have to specify the New part in each OR clause.

Also, this is off-subject, but you'll get better performance if you avoid
using the asterisk. Just name all the fields that you want in your SQL
statement.


"WebSlave" <webforumsuser@macromedia.com> wrote in message
news:d19gu5$h1c$1@forums.macromedia.com...

> I can not for the life of me remember how to do the following: I want my
> recordset to display the following: SELECT * FROM INVENTORY WHERE TYPE =

'NEW'

> AND SUBTYPE = 'CLASS A' OR SUBTYPE = 'CLASS B' OR SUBTYPE = 'CLASS C'

When I

> do this, it selects those subtypes, but it is pulling both 'New' &amp;

'Used'.

> Please advise. Also, is it bad coding to rename Repeat1 to something

unique

> like RepeatNEWINVENTORY?
>

[Kevin Marshall]

Try Enclosing the subtype selections in ()

SELECT * FROM INVENTORY WHERE TYPE = 'NEW' AND (SUBTYPE = 'CLASS A' OR
SUBTYPE = 'CLASS B' OR SUBTYPE = 'CLASS C')

--
Kevin Marshall
WebXeL.com Ltd
[url]http://www.webxel.com[/url]

ASP.NET Dreamweaver Extensions
[url]http://www.webxel-dw.co.uk[/url]
"WebSlave" <webforumsuser@macromedia.com> wrote in message
news:d19gu5$h1c$1@forums.macromedia.com...

>I can not for the life of me remember how to do the following: I want my
> recordset to display the following: SELECT * FROM INVENTORY WHERE TYPE =
> 'NEW'
> AND SUBTYPE = 'CLASS A' OR SUBTYPE = 'CLASS B' OR SUBTYPE = 'CLASS C'
> When I
> do this, it selects those subtypes, but it is pulling both 'New' &amp;
> 'Used'.
> Please advise. Also, is it bad coding to rename Repeat1 to something
> unique
> like RepeatNEWINVENTORY?
>