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