Originally Said By: Jason Byrnes
the value passed from the checkout page is note the selected city, it looks like it is the actual delivery fee?<select name="DeliveryCity" id="DeliveryCity">
<option value="15.00">Downtown Mpls</option>
<option value="15.00">Downtown Saint Paul</option>
<option value="15.00">Roseville</option>
<option value="15.00">Falcon Heights</option>
<option value="25.00">West Saint Paul</option>
<option value="25.00">South Saint Paul</option>
<option value="25.00">Maplewood</option>
<option value="25.00">New Brighton</option>
<option value="25.00">Shoreview</option>
<option value="25.00">Fridley</option>
<option value="25.00">Golden Valley</option>
<option value="25.00">Mendota Heights</option>
<option value="25.00">Robbinsdale</option>
<option value="25.00">Hopkins</option>
<option value="25.00">Edina</option>
<option value="25.00">Saint Louis Park</option>
<option value="25.00">Richfield</option>
<option value="35.00">New Hope</option>
<option value="35.00">Mahtomedi</option>
<option value="35.00">Woodbury</option>
<option value="35.00">Plymouth</option>
<option value="35.00">Brooklyn Park</option>
<option value="35.00">Brooklyn Center</option>
<option value="35.00">Bloomington</option>
<option value="35.00">Circle Pines</option>
<option value="35.00">White Bear Lake</option>
<option value="35.00">Hugo</option>
<option value="40.00">Maple Grove</option>
<option value="40.00">Anoka</option>
<option value="40.00">Blaine</option>
<option value="40.00">Coon Rapids</option>
<option value="40.00">Ham Lake</option>
<option value="40.00">Eagan</option>
<option value="40.00">Burnsville</option>
<option value="40.00">Eden Prairie</option>
<option value="40.00">Minnetonka</option>
<option value="40.00">Wayzata</option>
<option value="40.00">Inver Grove Heights</option>
<option value="40.00">Minnetrista</option>
<option value="50.00">Cottage Grove </option>
<option value="50.00">Apple Valley</option>
<option value="50.00">Hastings</option>
<option value="50.00">Stillwater</option>
<option value="50.00">Chanhassen</option>
<option value="50.00">Chaska</option>
<option value="50.00">Shakopee</option>
<option value="50.00">Forest Lake</option>
</select>
rays initial advice was to use the data base to populate the list, then use a recordset to lookup the delivery rate
the reason for doing it this way is that you probably want to show the selected delivery city, right? if the valuer in the select list is the delivery fee, there is no way to show what the delivery city selected is.
the delivery fee is not working because the recordset is filtering on the value posted by the select list. In this case the delivery fee, it s comparing the fee "15" to the city name column in the database. In other words, comparing apples to oranges.
Your absolutely right! We are trying to show that the city selected has a delivery fee "X" associated with it therefore creating a delivery charge for the selected city.
It sounds like I have the filter in the recordset wrong??? I've attached a screen shot of the recordset.
