SQL Server Performance Forum – Threads Archive
storing a lsit of checkbox
what is the most correct way to store a checkboxe’s that were selected,and save them by there id value for example.and if i want to make a search for example if a user have choosen : 1,5,9,32
and i want to search who has choosen 1 and 9 i will get the relevent user
thnaks in advance
peleg
Hi,<br />didn’t understand your question , would you re-form it !<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Post some sample data and the result you want Madhivanan Failing to plan is Planning to fail
ok say for example i have a form with 3 question
each question has a checkbox likethis :
[checkbox] blue
[checkbox] red
[checkbox] green
and i ask the user to mark his favorite color!
and he checks blue and red.
now there values are 1 and 3
and i want to store them in the DB and when needed to make a search for example on :
"who love the colors blue OR red"
and my user will be picked beacuse he likes blue.
so what the most correct way to store this detailes?
thanks in advance
peleg
]]>