Conditional statement ASP

sccs wrote:
> I want to show information from a database using 2 WHERE statements.
> WHERE cat='restaurant'
> WHERE show='True'
> I have it working to show user but I also want it to show information based on
> mail as well.
> I tried WHERE cat='restaurant' AND show='True'
> but it did not work.
> What I am doing is setting up a form so when anyone adds anything it will not
> show until I authorise it. The initial state for show is False.
> Are there any tutorials for this.
> Thanks.
>

When you wrap True like this 'True' it is treating it as string, not a
boolean condition, all you need to do is drop the quotes so it is like this:

WHERE cat = 'restaurant' AND show = True

Steve