Product Options with eCart

Using the tutorial and the eCommerce database

I have a site with products being different bike tours and the options being camping tent packages to rent.

The options show fine (in a select menu) and add to the cart with the price increment.

But when i add a repeat region using the product recordset, the add to the cart does not work for the additional products.

thanks for your help,
Jim Balthrop

I have three recordsets
rs_products
rs_options and
rs_tentlookup

The repeat region is using rs_products which only selects the products table.

I must join to the other tables, I think, but not sure how to write sql for that.

See the page here products.php
Just testing.
the first tour select works fine.
I do have the first three productoptions for the second tour in the db, but when added to the cart it does not work correctly.

thanks
-Jim Balthrop

this is going to be problematic to get working correctly andf will require hand coding.

the issue is this:

for the product options to work correctly in a repeat region, the recordsets that control the options will need to be inside the repeat region, and they will need to be filtered on the ID of the recordset that is controlling the repeat region

so the code will have the following order:

product recordset - returns prodID
repeat region
option recordset - filtered on current prodID
options select list - uses option recordset
end repeat region

thanks Jason.

the options recordset was already filtered by ProductID.
I moved the options recordset inside the repeat region that is controlled by the products recordset, and it works perfectly.

Another question, if I may?
The select list has a static label 'Choose Your Package' with no value. If a person clicks add to cart with that selected, it adds a nothing value to the cart.
What is the best way to prevent that, Validation?

yes, you would need to add required server side validation to the option select list.