<% 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: 29 October 2008 15:49
To: Anne Sutton
Subject: RE: Order Dispatched

thank you for the fast delivery and the product is perfect , i will use your company again for different parts

thank you nathan hills



Sent: 26 July 2008 20:35
To: shop@ajsutton.co.uk
Subject: Gilera Cougar parts.

Just a quick message to thank you for obtaining the right hand tank badge for my sons cougar-other spares outlets had said this was no longer available-I will certainly come to you first from now on and will recommend you to my friends-Thanks ,Rob McCool.


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

Hello,

Package received and bike is running great again cheers.

Thanks alot.

steve.


Sent: Saturday, November 18, 2006 1:06 PM
Subject: Thanks


Hi Gus & team,

Thank you for your excellent service & quick delivery for the cupolino
screen
for the Gilera dna, just what i was after.

I will recommed you to my fellow bikers.

Cheers Justin.


Sent: Wednesday, October 04, 2006 9:17 AM
Subject: Re: Rear disc VXR200

Hello again Gus

Just to say that the disc was here when I got back from holiday. The Post Office stated that the delivery before 1pm wasn't applicable for a Saturday morning unless an additional £2 was paid. I thought I would let you know. Anyway, I fitted the disc last weekend and am really chuffed that my brake judder has gone........

Many thanks

Iain


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 10, 2006 4:22 PM
Subject: Re: Gilera spares


It arrived this morning (thursday) many thanks for sending it so prompty, much appreciated

Yonnie


Sent: Saturday, August 12, 2006 4:17 AM
Subject: RE: Gilera spares

Hi Gus,

The order arrived last week. It was very quick. Thank you.

David


Sent: Thursday, August 10, 2006 6:47 PM
Subject: RE: Vespa spares


thankyou Gus...hopefully i'll have my baby back on the road soon!!

Alan



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