That explains the first character problem. Now to the other problem. I'm trying to select from dozens of check boxes individual items. Each item will be put in a table, one row per item. It's just like any shopping cart. Retrieve values from an array of items and put them together in an order with a new line in the database for each item.
I've looked at about 20 solutions for submitting data from multiple check boxes and none of them work. Am I going about this all wrong? Retrieving a list of products from a products table, giving each a check box, then expecting that if I select 5 products I'll be able to generate 5 new rows of data in the orders table.
For order number 10,
product 1 Checked
product 2 not checked
product 3 not checked
product 4 Checked
product 5 Checked
Insert records inserts these values into the table.
order 1 ID, Product 1 ID
order 1 ID, Product 4 ID
order 1 ID, Product 5 ID
Now I can call up order 1 and see all products where order ID = 1 using a repeat region method.
If I add one product at a time this works. I need to add a bunch of products with one submit button. Any ideas would help a lot.