Adding multiplication to a recordset
Hi, I am trying to multiply the quantity of an item by it's unit price, but I am confused as to how to write this in my recordset. I ran the Data Assist wizard and I now have all pages working. I have all tables needed joined together properly and I am using MySQL and PHP along with all of your other extensions.
Here is what my current recordset query looks like:
SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderId = orderdetails.DetailOrderId
WHERE orderdetails.DetailOrderId = WADAOrderId OR ( -1= ParamOrderId AND OrderId=ParamSessionorderid)
How would I specify that I just need two fields to multiply? In other words..
orderdetails.DetailQuantity * orderdetails.DetailPrice =
Thanks!