-
Inserting multiple records
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|