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
