where = true

Results 1 to 2 of 2

Thread: where = true

  1. #1
    Join Date
    Dec 1969

    Default where = true

    Hi<BR><BR>I have a checkbox in a access database which i am using to sort through records. I am construcitng a query to select so have<BR><BR>("select * from table where company.checkbox = true")<BR><BR>This make sit hang currently. Can i use 1 or 0 for true or false.<BR><BR>ta<BR><BR>james

  2. #2
    Join Date
    Dec 1969

    Default RE: where = true

    Not sure what you are trying to accomplish by doing that. If you wanted to just sort records a simple order by clause might suffice. If you are trying to filter records, try using 1 or 0. I am confused since you are trying to mix client side code (checkbox.select) with server side TSQL.

Posting Permissions

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