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&#34 & " FROM tblPrice WHERE quantity like " & session("quantity&#34

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&#34

"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&#34 . But then, I would have to already have the quantity-pricecode info from the second part.

As always, thanks in advance.
Ted Moore