Click to See Complete Forum and Search --> : Result dependant on range and pulling field results


jayty97
10-14-2010, 09:51 AM
I am not the most experienced and still have a lot of holes in my knowledge. I have 2 issues I'm pulling my hair out over trying to get to work. I'm sure both. are relatively simple. I have searched, but sometimes it is difficult to pull out the info I need from the vast sea available! I'm working on a custom order system. I have other systems up and running, giving prices using an equation of different form fields entered and those are working fine. Here is what I am trying to do now:

I'm pulling form fields from test1.asp submitted to the current page, test2.asp, that will be sent to a database. I'm basing a price and shipping off of the volume taken by multiplying Width, height and depth fields. What is the correct way to write the if/then using a range of numbers?

<%
If ("Width" * "Height" * "Depth") = 0 to 3000 Then
ItemPrice = 109.99
ShipPrice = 18.00
End If
%>
<%
If ("Width" * "Height" * "Depth") = 3000.1 to 6000 Then
ItemPrice = 119.99
ShipPrice = 20.00
End If
%>

Also, I want this info sent to another page test3.asp in order for the customer to see the results before submitting it to the shopping cart. Is it something along these lines?
<input type="text" name="Width" value="<%Response.Write request.form("Width")%>"><br>

Any help is much appreciated by this newb!

yamaharuss
10-15-2010, 03:45 AM
myTotal = "Width" * "Height" * "Depth"

ItemPrice = 109.99
ShipPrice = 18.00

If myTotal > 3000 then
ItemPrice = 119.99
ShipPrice = 20.00
End If

If myTotal > 6000 then
ItemPrice = 129.99
ShipPrice = 22.00
End If

etc..