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

We ship hundreds of orders every week.

Below is just a small sample of our customer feedback

a

Sent: 15 February 2008 18:36
To: Gus Sutton
Subject: Re: shop@ajsutton

Hi,

Order arrived today, thank you very much for the excellent and prompt service.

Len Harvey
Sent: Friday, September 29, 2006 1:18 AM
Subject: Re: Piaggio spares

Thank you very much. The part turned up this morning. I am most impressed with your service, your online parts list/catalogue is simply the best I have used and the online ordering could not have been easier. Thankyou also for your prompt answer to the numpty enquiry I made a week or two ago before I ordered.


Oh how I wish Suzuki parts were so easy to get online !!!

Best Regards,

Dave Lush
Sent: Thursday, August 17, 2006 10:53 PM
Subject: Re: T5 Kickstart

Thanks and I will look forward to doing business with you in the future as you've been very helpful

Thanks again Lee
Sent: Friday, September 01, 2006 2:37 PM
Subject: Vespa GT200 Parts

Hi

Have spent a while searching your excellent website for parts for my recently acquired GT200. It seems that you really are the only company out there really offering a good line of parts for the new GT's and GTS's. I tried the supposed Piaggio dealer in Hereford for a Speedo cable recently and after a very lengthy wait while they tried to find a part number they did order it for me but weren't at all interested so it is to you I turn.......................

Best regards

Tristan

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