CheckBox and Update

Results 1 to 2 of 2

Thread: CheckBox and Update

  1. #1 Guest

    Default CheckBox and Update

    Hi ASP Gurus,<BR><BR>I am facing a problem with Checkbox. I am retriving a list of records from a table. I have a column called Rec_Status. If the Rec_status is A, I will insert a CheckBox and if the Rec_Status is not A, the checkbox will not appear.<BR><BR>Ok ... my question is how can I code in my ASP that can detect the checkbox is Checked or not so that I can only update on those Checked Record.<BR><BR>Thanks for any input.

  2. #2
    Join Date
    Dec 1969

    Default RE: CheckBox and Update

    I take it that the checkbox you&#039re talking about is the one that turns up when your Access field datatype is set to "Yes/No".<BR><BR>If so, then the numeric value of an unchecked checkbox is 0 and the numeric value is -1 , that&#039s right, -1 not 1.<BR><BR>So:<BR><BR>SQL = "SELECT * FROM MyTable WHERE MyYesNoField = -1"<BR><BR>Did that help?

Posting Permissions

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