Dear Forum Members,
REM: working in dbPro
Thank you for all the help in recent weeks. I am very close to putting together all the pieces. I now have an SQL statement which pulls my price for a product-quantity combination from a table.
MyDb.dbSQL="SELECT " & session("pricecode" & " FROM tblPrice WHERE quantity like " & session("quantity"
I now need to insert a price for each item in our cart. I would like to do this on the order summary page. The dbSQL for that page looks like this:
MyDb.dbSQL="SELECT * FROM tblCart WHERE OrderID = " & session("OrderID"
"price" is a field in tblCart. How do I insert the price from the first SQL statement into my price field for each item in the cart? I have tried Magic Cell, but haven't come up with the right syntax. Am I on the right track?
I guess another possibility would be to run the ASPdb routine with the first SQL statement, export the price variable and set dbMagicCell="price,," & session(aspdb_802_price" . But then, I would have to already have the quantity-pricecode info from the second part.
As always, thanks in advance.
Ted Moore