AH.... i didnt know you could use parentheses! Cool... thanks for the help!
At 10:48 AM 6/21/2001 -0700, you wrote:
>it's because of the way you've structured the query.
>
>SQL is reading it like this:
>
>WHERE
>
>hidden = 1 AND DIM <= 200 AND COLOR1 = 'gold'
>
>OR
>
>COLOR2 = 'gold' AND WKSTN >= 2
>
>so your output of COLOR2=gold and WKSTN=4 is right in line with the 2nd half
>of the OR query.
>
>you should have:
>
>where hidden = 1 AND
> DIM <= 200 AND
> WKSTN >= 2 AND
> (COLOR1 = 'gold' OR
> COLOR2 = 'gold')
>
>i think that should do it.
>
>-----Original Message-----
>From: Chad Gray [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, June 21, 2001 10:33 AM
>To: CF-Talk
>Subject: SQL question
>
>
>Im wondering why this SQL statement would bring up results where DIM is
>greater then 200? I think it has something to do with the OR statement,
>but i dont know why.
>
>Select *
>from products
>where hidden = 1 AND
> DIM <= 200 AND
> COLOR1 = 'gold' OR
> COLOR2 = 'gold' AND
> WKSTN >= 2
>
>
>
>Here is my Output:
>ProductID : 3
>Dim : 600
>Color1 : blue
>Color2 : gold
>WKSTN : 4
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
