<% Dim strCategory, strArea, strUnit, strDuration, strPrice, strNotes Dim Conx, RecSet strCategory=request.querystring("Category") strArea=request.querystring("Area") strUnit=request.querystring("Unit") strDuration=request.querystring("Duration") Set Conx = server.createobject("adodb.connection") Conx.Provider = "Microsoft.Jet.OLEDB.4.0" Conx.Open server.mappath("kh_data.mdb"), "admin", "" Set RecSet = server.createobject("adodb.recordset") Select Case strCategory Case "1" 'General RecSet.Open "SELECT Top 1 Duration, Price FROM tb_GenInsurance WHERE AreaID = " & strArea & " AND UnitID = " & strUnit & " AND Duration >= " & strDuration & " ORDER BY Duration", Conx, , , adCmdText strDuration=RecSet("Duration") Case "2" 'Ski if strArea = "3" then strArea = "4" if strUnit = "5" then strUnit = "4" RecSet.Open "SELECT Top 1 Duration, Price FROM tb_SkiInsurance WHERE AreaID = " & strArea & " AND UnitID = " & strUnit & " AND Duration >= " & strDuration& " ORDER BY Duration", Conx, , , adCmdText strDuration=RecSet("Duration") Case "3" 'General if strUnit = "3" then strUnit = "1" RecSet.Open "SELECT Price FROM tb_AnnInsurance WHERE UnitID = " & strUnit, Conx, , , adCmdText End Select strPrice=RecSet("Price") RecSet.Close RecSet.Open "SELECT Notes FROM tb_InsuranceNotes WHERE CategoryID = " & strCategory & " AND UnitID = " & strUnit, Conx, , , adCmdText strNotes=RecSet("Notes") RecSet.Close Conx.Close Set RecSet = Nothing Set Conx = Nothing %> Travel Insurance from Holiday Bargains
Home < Market Place < Travel Insurance click to get Holiday Bargains on your mobile
Travel Insurance
The original Top Ten Holiday Bargains
Car Hire Pricebusters
Spain from 59pw
discounted rates from Holiday Bargains
Our travel insurance can be half the price of some High Street Travel Agents... and you don't have to book your holiday with us to get these discounted rates (although it might be wise to do so)!

Enter your insurance requirements below and click the 'Price' button to get a quote. To book, just give us a call on 08707 571 571 and we'll have you covered in minutes.
Order holiday money on-line
Category <%If strCategory = "1" then%> <%else%> <%end if%> General single trip Holiday Bargains Price
<%If strCategory = "2" then%> <%else%> <%end if%> Ski single trip <%=strPrice%>
<%If strCategory = "3" then%> <%else%> <%end if%> Annual
Area
Notes
<%=strNotes%>
Cover Type
Duration <%if strCategory = "3" Then%> xxxxxxxxxxxxxxx <%else%> <%End If%>
08707 571 571   Summary of Cover   Summary of Conditions   Email us
Home | Top Ten Bargains | The Boards | Enquiry Form | Quotebuster | Market Place | Mailing Lists | Resource Centre | Travel Industry
About us | Contact us | Link to us                      Site Map | Settings