Checkbox Question PART II

Results 1 to 3 of 3

Thread: Checkbox Question PART II

  1. #1
    Join Date
    Dec 1969

    Default Checkbox Question PART II

    Well I&#039;m a little bit further now...:<BR><BR>=================================== ========================<BR>SELECT *<BR>FROM T_Fonts<BR>WHERE (Font like &#039;%" + request.form("zoeken") + "%&#039; OR Trefwoorden like &#039;%" + request.form("zoeken") + "%&#039;) AND (S_Schreef = TRUE OR S_Schreefloos = TRUE)<BR>========================================= ==================<BR><BR>But it should not display all the records where S_Schreef, S_Schreefloos = TRUE, but ONLY when the user checked the checkbox. So only if S_Schreef, S_Schreefloos = TRUE AND the user checked the checkbox Schreef and Schreefloos.<BR><BR>Can anyone give me a clue?<BR><BR>:-)

  2. #2
    Join Date
    Dec 1969

    Default Do a Response.Write..

    .. on the SQL statement and post what it creates.<BR><BR>And, there wasn&#039;t really a reason to start a new thread. Ettiquette is to stick to your original.

  3. #3
    Join Date
    Dec 1969

    Default RE: Checkbox Question PART II

    True / False are stored in a database as 1 / 0 so you should have <BR>(S_Schreef = 1 OR S_Schreefloos = 1)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts