PDA

View Full Version : calculating 2 recordsets using ASP


mangofreak
01-16-2006, 03:48 PM
Hi all,

I am using DWMX 2004, Classic ASP, and Access DB. My problem is the following:

I have two recordsets:

<%=(rsSub2.Fields.Item("subtotal").Value)%> and <%=(rsTest.Fields.Item("subTaxes").Value)%> that I want to calculate.
My simplistic version would be:

<%=(rsSub2.Fields.Item("subtotal").Value)%> * <%=(rsTest.Fields.Item("subTaxes").Value)%> /100 = total

I have no clue how to do this using ASP, I have been trying to do it using SQL, but I haven't been able to succeed and as someone told me, since I'm using an Access Database, if I do my calculation via Queries, I would pay with processing load. Please, if anyone has a sample of how to approach such calculation using ASP would be great. Is it possible.? Any idea, suggestion? I am more of a front end guy but I'm trying to learn the back end.

Javier

davidj
01-17-2006, 01:22 PM
i am guessing ...

<%=(rsSub2.Fields.Item("subtotal").Value)*(rsTest.Fields.Item("subTaxes").Value)/100 %>

davidj
01-19-2006, 07:55 AM
this is broken

coz i cant delete a post

post above is missing <% asp tags - please put this post back the way it was