<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> Bishopstrade Pty Ltd <% DIM objConn,objRS,strSQL DIM dbr,dbrTwo dbrTwo = Request.QueryString("cnt") dbr = Request.QueryString("sid") Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../users/sosjhb.mdb") strSQL = "SELECT destinations.sourceDestination,menuHead.itemText,collDel.collDelWeights,collDel.collDelDesc,collDel.collDelPrice,collDel.collDelUnits " & _ "FROM destinations,menuHead,collDel " & _ "WHERE menuHead.idf_countries = " & dbrTwo & " AND menuHead.idf_display = " & dbr & " AND destinations.id_countries = menuHead.idf_countries AND collDel.idf_countries = menuHead.idf_countries " & _ "ORDER BY collDel.collDelOrder;" SET objRS = objConn.Execute(strSQL) %>
<%=objRS("sourceDestination")%>: <%=objRS("itemText")%>
Collection tariffs
<%CALL ratesTable()%>
Weight Price
<%CALL ratesTable()%> <% DO WHILE NOT objRS.EOF %> <%=objRS("collDelWeights")%> <%=objRS("collDelDesc")%> R <%=formatNumber(objRS("collDelPrice"), 2, , 0)%> <%=objRS("collDelUnits")%> <% objRS.MoveNext LOOP objRS.Close Set objRS = Nothing objConn.Close Set objConn = Nothing %> Freight tariffs <%CALL ratesTable()%> Weight Price <%CALL ratesTable()%> <% DIM objConnTwo,objRSTwo,strSQLTwo DIM dbs,dbsTwo dbsTwo = Request.QueryString("cnt") dbs = Request.QueryString("sid") Set objConnTwo = Server.CreateObject("ADODB.Connection") objConnTwo.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../users/sosjhb.mdb") Set objRSTwo = Server.CreateObject("ADODB.RecordSet") strSQLTwo = "SELECT destinations.sourceDestination,menuHead.itemText,destinationPrices.ratesWeight,destinationPrices.ratesDesc,destinationPrices.ratesPrice,destinationPrices.ratesUnit " & _ "FROM destinations,menuHead,destinationPrices " & _ "WHERE menuHead.idf_countries = " & dbsTwo & " AND menuHead.idf_display = " & dbs & " AND destinations.id_countries = menuHead.idf_countries AND destinationPrices.idf_countries = menuHead.idf_countries " & _ "ORDER BY destinationPrices.priceOrder;" objRSTwo.Open strSQLTwo, objConnTwo, adLockOptimistic, adCmdTable %> <% DO WHILE NOT objRSTwo.EOF %> <%=objRSTwo("ratesWeight")%> <%=objRSTwo("ratesDesc")%> R <%=formatNumber(objRSTwo("ratesPrice"), 2, , 0)%> <%=objRSTwo("ratesUnit")%> <% objRSTwo.MoveNext LOOP objRSTwo.Close Set objRSTwo = Nothing objConnTwo.Close Set objConnTwo = Nothing %> Delivery tariffs <%CALL ratesTable()%> Weight Price <%CALL ratesTable()%> <% DIM objConnThree,objRSThree,strSQLThree DIM dbt,dbtTwo dbtTwo = Request.QueryString("cnt") dbt = Request.QueryString("sid") Set objConnThree = Server.CreateObject("ADODB.Connection") objConnThree.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../users/sosjhb.mdb") SstrSQLThree = "SELECT destinations.sourceDestination,menuHead.itemText,collDel.collDelWeights,collDel.collDelDesc,collDel.collDelPrice,collDel.collDelUnits " & _ "FROM destinations,menuHead,collDel " & _ "WHERE menuHead.idf_countries = " & dbtTwo & " AND menuHead.idf_display = " & dbt & " AND destinations.id_countries = menuHead.idf_countries AND collDel.idf_countries = menuHead.idf_countries " & _ "ORDER BY collDel.collDelOrder;" SET objRSThree = objConnThree.Execute(strSQL) %> <% DO WHILE NOT objRSThree.EOF %> <%=objRSThree("collDelWeights")%> <%=objRSThree("collDelDesc")%> R <%=formatNumber(objRSThree("collDelPrice"), 2, , 0)%> <%=objRSThree("collDelUnits")%> <% objRSThree.MoveNext LOOP objRSThree.Close Set objRSThree = Nothing objConnThree.Close Set objConnThree = Nothing %> © Copyright Bishopstrade Limited <%=year(date)%>, all rights reserved