<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> Untitled Document <% DIM objRS DIM strSQL DIM tid tid = Request.QueryString("sid") strSQL = "SELECT ratesPrices.ratesWeight,ratesPrices.ratesPrice,ratesAreas.ratesAreas,ratesCountries.ratesCountries " & _ "FROM ratesPrices,ratesAreas,ratesCountries " & _ "WHERE ratesPrices.idf_areas = " & tid & " AND ratesAreas.id_areas = " & tid & " AND " & _ "ratesCountries.id_countries = ratesPrices.idf_countries ORDER BY ratesPrices.priceOrder;" SET ObjRS = Server.CreateObject("ADODB.RecordSet") objRS.Open strSQL,objConn %>
<%=objRS("ratesCountries")%>
<%=objRS("ratesAreas")%>
<% DO WHILE NOT objRS.EOF %> <% objRS.MoveNext LOOP %>
<%=objRS("ratesWeight")%>   Kgs    <%=formatNumber(objRS("ratesPrice"), 2, , 0)%>
Back to Country selection
Back to Area selection
<% objRS.Close Set objRS = Nothing objConn.Close Set objConn = Nothing %>