<% Dim adoCon Set adoCon = Server.createObject("ADODB.Connection") adoCon.Open "Provider=MSDASQL; Driver={SQL Server}; Server=172.6.0.3; Database=Spares; UID=SA; PWD=;" dim masterPart, stockPrice, partPrice GPN = trim(request.QueryString("GPN")) 'get master record ----------------------------------------------------------------- Set masterPart = Server.CreateObject("ADODB.Recordset") mySQL = "SELECT * FROM [stock_master] WHERE [GPN] = '" & GPN & "'" masterPart.Open mySQL, adoCon, 1, 1 'Opened as Read-Only dim ve Set ve = Server.CreateObject("ADODB.Recordset") mySQL = "SELECT * FROM [ve] WHERE [product id] = '" & GPN & "'" ve.Open mySQL, adoCon, 1, 1 'Opened as Read-Only ' get the price ----------------------------------------------------------------- set stockPrice = Server.CreateObject("ADODB.Recordset") mySQL = "SELECT [RETAIL], [VAT], [SUPPLIER] FROM [stock_price] WHERE [GPN] = '" & GPN & "'" stockPrice.Open mySQL, adoCon, 1, 1 'Opened as Read-Only %>
home company services news contacts

TNT

We can supply all TNT performance parts for your Gilera.

a


TNT Tuning

TNT Product a wide range of Aftermarket replacement and performance parts.

Product Highlight
Listed below are just a few of the TNT products we can supply. You will find a complete listing in the aftermarket section for your gilera.


TNT STREET BIKE HANDLEBARS

TNT BRAKE DISC

TNT RACING EXHAUST

TNT FAN COVER

TNT HANDLEBAR GRIPS

TNT HELIX AIR FILTER

TNT TWIN HEADLAMP

TNT SPOT LAMPS

TNT ARROW INDICATORS

CHROME LED TAIL LAMP

You will find all the available TNT parts listed in the aftermarket section for your machine. Click here for a complete list.


Copyright © gileraSpares.co.uk
designed by Deep Blue Systems Ltd
Home | About Us | Services | Support | Contact Us | Forum