var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Check Boxes in select statement
I am working on a database, and some of the records in it are not meant to show up on the website. the determining factor is a check box in a column called Web_Site.
how do i select only those with the checked check box?
WHERE Sub_Category='" & This_Sub_Cat & "' & Web_Site=??? ORDER BY Sub_Category"
thanks in advance,
Checkbox fields in columns evaluate to either Yes or No, True or False. Just check for whichever condition you need in your query, i.e.
WHERE Sub_Category='" & This_Sub_Cat & "' & Web_Site=Yes ORDER BY Sub_Category"
This would give you all the records where Web_Site is checked.
If you need some more help, post back!
Hope it helps,
You can beleive or not but since Web_Site field is a boolean one following statement should work too:
WHERE Sub_Category='" & This_Sub_Cat & "' & Web_Site ORDER BY Sub_Category"
Good call on that. Your statement is a little more concise as well. I sometimes forget that you can write things in that way with Yes/No fields.