<%Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../db/cliffharveyangling.mdb") IF Request.Querystring("secondgroup")="" THEN set rs=conn.execute("SELECT * FROM products where maingroup = '" & Request.Querystring("maingroup") & "' ORDER BY item") IF Request.Querystring("secondgroup")>"" THEN set rs=conn.execute("SELECT * FROM products where maingroup = '" & Request.Querystring("maingroup") & "' AND secondgroup = '" & Request.Querystring("secondgroup") & "' ORDER BY item") IF Request.Querystring("search")>"" AND Request.Querystring("category")="all" THEN set rs=conn.execute("SELECT * FROM products where descriptiontext LIKE '%"&Request.Querystring("search")&"%' OR item LIKE '%"&Request.Querystring("search")&"%' OR secondgroup LIKE '%"&Request.Querystring("search")&"%'") IF Request.Querystring("search")>"" AND Request.Querystring("category") <>"all" THEN set rs=conn.execute("SELECT * FROM products where maingroup = '" & Request.Querystring("category") & "' AND descriptiontext LIKE '%"&Request.Querystring("search")&"%' OR maingroup = '" & Request.Querystring("category") & "' AND item LIKE '%"&Request.Querystring("search")&"%' OR maingroup = '" & Request.Querystring("category") & "' AND secondgroup LIKE '%"&Request.Querystring("search")&"%'") set rs2=conn.execute("SELECT DISTINCT secondgroup FROM products where maingroup = '" & Request.Querystring("maingroup") & "' ORDER BY secondgroup") %> Untitled Document
Fly fishing tackle and equipment Online UK fishing tackle shop specialising in fly fishing Online UK fishing tackle shop specialising in fly fishing
Site Search
Advanced Search
Accessories
Fishing Bags
Clothing
Fishing Flies
Fly Fishing Lines
Fly Fishing Reels
Fly Fishing Rods
Fly Tying Materials
Foot Wear & Waders
Landing Nets
Download our Catalogue
Cortland 444 Classic Lines.
A superb all round top of the water line. supple coating reduces memory and produces excellent shooting properties.
Vision Koma The new Vision Koma reel with free spool.
 A blazing retrieve rate and generous line capacity ensure you have the upper hand in any situation.
  £59.95 with free spare spool

Newsletter Signup!
Cancel Subscription
Call Us: 01443 400766
 
Company Information
<%num=0%> <% Do until rs.Eof%> <%num=num+1%> <%if num=3 then%> <%num=1%> <%else%> <%end if%>

Cliff Harvey Angling Supplies UK online


We are based in the South Wales area, specialising in game / fly fishing. Cliff Harvey Angling Supplies offers extensive tackle from all leading manufacturers such as: Redington, Daiwa, Cortland, Rio, Shimano, to name but a few... You can browse our online fishing tackle shop for fishing equipment and accessories by using the menu on the left hand side of the screen.

Our shop has been established since 1991 and the business has continued to grow. We have a wealth of experience which we are happy to share with all of our customers.

 
Company   |    Download Catalogue    |    Site Map    |    Links
Accessories | Fishing Bags | Fishing Clothing & Jackets | Fishing Flies | Fly Fishing Lines | Fly Fishing Reels | Fly Fishing Rods | Fly Tying Materials | Foot Wear, Waders & Wellingtons | Landing Nets

Copyright © Cliff Harvey Angling Supplies, 2005. All Rights Reserved
Unit 10, Albion Industrial Est. Cilfynydd, Pontypridd, Mid Glamorgan, CF37 4NX
Terms and Conditions of Sale | Privacy Policy | About Us