Form Question - Displaying a checkbox value from t

Results 1 to 2 of 2

Thread: Form Question - Displaying a checkbox value from t

  1. #1
    Join Date
    Dec 1969

    Default Form Question - Displaying a checkbox value from t

    I have a form which has several checkboxes for the field "Interest". Each checkbox however has a different value such as Golf, Baseball, Hockey, Swimming. Those values get submitted into the DB field "Interest" seperated by a comma. However I&#039;m having problems getting the value back out of the DB on the modify form page I created. I looked at the FAQ&#039;s on this site but it didn&#039;t answer my question.<BR><BR>I have something like this:<BR><BR>&#060;input type="checkbox" name="Interest" value="Golf" &#060;% If RS("Interest") = "Golf" Then%&#062;CHECKED&#060;%End If%&#062;&#062;<BR><BR>&#060;input type="checkbox" name="Interest" value="Baseball" &#060;% If RS("Interest") = "Baseball" Then%&#062;CHECKED&#060;%End If%&#062;&#062;<BR><BR>Suggestions?<BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default Normalize the database

    Never put a comma-delimited into a field in the DB. Create a *NEW* table, named INTERESTS perhaps, with the ID of the person and the ID (or text, I suppose, though ID is "cleaner") of the interest. <BR><BR>

Posting Permissions

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