<%
Set PValue = Server.CreateObject("ADODB.Recordset")
PValue.ActiveConnection = conn
PValue.LockType = 1
PValue.CursorType = 0
PValue.Open "select * from CostingDetails"
If Not PValue.EOF or Not PValue.BOF Then
OnlineServiceCharge=PValue("OnlineServiceCharge")
StandardCar=PValue("StandardCar")
MPV=PValue("MPV")
ECLASS=PValue("ECLASS")
SCLASS=PValue("SCLASS")
Surcharge_To_Airport=PValue("Surcharge_To_Airport")
Surcharge_From_Airport=PValue("Surcharge_From_Airport")
End If
Set PValue=Nothing
If Request("pickup")<>"" and Request("postcode")<>"" and Request("destination")<>"" then
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.ActiveConnection = conn
Rs.LockType = 1
Rs.CursorType = 0
Rs.Open "select * from RouteDetails where pickup='"&Request("pickup")&"' AND postcode='"&Request("postcode")&"' AND Destination='"&Request("Destination")&"'"
If Not Rs.EOF or Not Rs.BOF Then
StandardCar_1=Rs("Miles") * StandardCar + Surcharge_To_Airport
MPV_1=Rs("Miles") * MPV + Surcharge_To_Airport
ECLASS_1=Rs("Miles") * ECLASS + Surcharge_To_Airport
SCLASS_1=Rs("Miles") * SCLASS + Surcharge_To_Airport
%>
| Your journey from <%=Request("pickup")%>
- <%=Request("PostCode")%> to <%=Request("Destination")%>
|
| Standard Car |
MPV |
E-CLASS |
S-CLASS |
| £<%=StandardCar_1%> |
£<%=MPV_1%> |
£<%=ECLASS_1%> |
£<%=SCLASS_1%> |
|
Book Now |
Book Now |
Book Now |
Book Now |
<%
Else
%>
No Records Found
For Your journey from <%=Request("pickup")%>
- <%=Request("PostCode")%> to <%=Request("Destination")%>
<%
End If
Set Rs=Nothing
end if
If Request("pickup1")<>"" and Request("postcode1")<>"" and Request("destination1")<>"" then
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.ActiveConnection = conn
Rs.LockType = 1
Rs.CursorType = 0
Rs.Open "select * from RouteDetails where PickUp='"&Request("pickup1")&"' AND postcode='"&Request("postcode1")&"' AND Destination='"&Request("destination1")&"'"
If Not Rs.EOF or Not Rs.BOF Then
StandardCar_2=Rs("Miles") * StandardCar + Surcharge_From_Airport
MPV_2=Rs("Miles") * MPV + Surcharge_From_Airport
ECLASS_2=Rs("Miles") * ECLASS + Surcharge_From_Airport
SCLASS_2=Rs("Miles") * SCLASS + Surcharge_From_Airport
%>
| Your journey from <%=Request("pickup1")%>
to <%=Request("destination1")%> - <%=Request("postcode1")%>
|
| Standard Car |
MPV |
E-CLASS |
S-CLASS |
| £<%=StandardCar_2%> |
£<%=MPV_2%> |
£<%=ECLASS_2%> |
£<%=SCLASS_2%> |
|
Book Now
|
Book Now
|
Book Now
|
Book Now
|
<%
Else
%>
No Records Found
For Your journey from <%=Request("pickup1")%>
to <%=Request("destination1")%> - <%=Request("postcode1")%>
<%
End If
Set Rs=Nothing
end if
set conn = Nothing
%>
Back 
Please select the vehicle that you require
to make a booking, if you would like to add
a return booking then please click back to
add this journey to your booking.
|
|