I have a checkboxgroup listing products and a total field. Some of the items are the same price and when the data is stored in the response table, the list of product prices that have been selected is stored as a comma-delimited string in the response field.
the options have a question portion and a value portion. The demo page says use the format Value01_price, but when I do that the total field is populated with text (NaN). It will only total if I use numbers only.
EG User sees: choose product prod1 10.00 prod2 10.00 prod 3 10.00 prod 4 10.00
Total 0
Say the user orders prod 1 and prod 4. the results are stored in the Questionresponse table
results in a query of question, questionResponse and questionOption tables is: question Response question option choose product 10.00,10.00 product1 choose product 10.00,10.00 product2 choose product 10.00,10.00 product3 choose product 10.00,10.00 product4 Total 20
result string is 10.00,10.00 in all cases - how can I tell which products were ordered?
cheers |