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
%>