i have a form in html which uses textboxes(fieldname=mobilecode) as its input type. upon clicking the submit button, the checked items would add to the user's personal data in my database. here is the code:


sql_send= "insert into tblprofiles
(mobilecode, status)
values ('" & request("chkmcode")
& "' , 'cleared')"


the code works if only one checkbox is marked. but if it exceeds 1, the page gets an error (something like data is truncated). can i really insert n number of "mobilecode" with one similar "status" for all of them? please help. thanks in advance.