Confused... Where statement? RRS feed

  • Question

  • User356974890 posted
    Hi All, I'm new to ASP.NET! I need to use the where statement but i don't know how this works exaxctly! The problem is as following. I have a database which contains a column of checkboxes. Now I want to open a page which only shows de data of the rows where the checkbox is checked! How do i do this? Please give complete code?? Thx very much! Greetz, Janus
    Thursday, July 8, 2004 7:25 AM

All replies

  • User1796948403 posted
    This post is not in the right forum, but here you go. "check boxes" in database? You mean that you have bit field types (or boolean true false?) try this: SELECT fieldname1 fieldname2 FROM Tablename WHERE CheckBoxField1 = true AND CheckBoxField2 = true
    Tuesday, August 3, 2004 6:19 PM