Inserting checkbox

Dear,

I have a form with two fields which contains check box, and so I would like to know how I can insert check boxes in my database using DataAssist and also, to which type of colums should I set the particular table holding the checkboxes (if other than a set column)

thanks

Checkboxes are a special type of input. Whatever is present for the value attribute in the checkbox is what you will see inserted into your db, but only if the box is checked, if it is not checked there will be no value for that form element.

You can insert and update with checkboxes by using the regular DataAssist Insert and Update server behaviors. Since you can put any value into the checkbox the data type of the column will depend on what values you want the checkboxes to have. So if you are setting a checkbox to a string value like "test" then you would want to have a varchar type column in your db for this checkbox.

The thing is,

in my form, I have a field which has three check boxes, where people can either select one, or two, and I would like to know how I can make it to insert the selected value, because until now, it giving me only one value and not two, even when two check boxes are selected

Do you have a page that I can see this on? A checkbox should be an independent form element with it's own value. If it is checked then it will post what is in the value.