Need a bit of help creating a charge for a certain product based on one of its column values in the recordset.
I have a table with a column called ChargeType.
I have created a column in the eCart Object Called ChargeType1
The information held in the column field for ChargeType in the database can either be "" (empty), INJ or DISP
If the product chosen has an empty field value for ChargeType then the normal price is to be passed through.
If the product chosen has a field value of DISP for ChargeType then I want it to add 3.89 to the existing price.
If the product chosen has a field value of INJ for ChargeType then I want it to add 7.00 to the existing price
Can you help?