[an error occurred while processing this directive] motor caricatures, motor caricatures <% Set objConn = Server.CreateObject ("ADODB.Connection") Set rs2 = Server.CreateObject ("ADODB.Recordset") objConn.Open strIDMS SQL1 = "SELECT DISTINCT TblCat.ID, TblCat.Catagory, TblManufacturers.Name, TblPrducts.ManCode FROM (TblPrducts INNER JOIN TblManufacturers ON TblPrducts.ManCode = TblManufacturers.ID) INNER JOIN TblCat ON TblPrducts.ProductCategory = TblCat.ID WHERE (((TblCat.ID)=1)) ORDER BY TblManufacturers.Name;" SQL2 = "SELECT DISTINCT TblCat.ID, TblCat.Catagory, TblManufacturers.Name, TblPrducts.ManCode FROM (TblPrducts INNER JOIN TblManufacturers ON TblPrducts.ManCode = TblManufacturers.ID) INNER JOIN TblCat ON TblPrducts.ProductCategory = TblCat.ID WHERE (((TblCat.ID)=2)) ORDER BY TblManufacturers.Name;" SQL3 = "SELECT DISTINCT TblCat.ID, TblCat.Catagory, TblManufacturers.Name, TblPrducts.ManCode FROM (TblPrducts INNER JOIN TblManufacturers ON TblPrducts.ManCode = TblManufacturers.ID) INNER JOIN TblCat ON TblPrducts.ProductCategory = TblCat.ID WHERE (((TblCat.ID)=3)) ORDER BY TblManufacturers.Name;" SQL4 = "SELECT DISTINCT TblCat.ID, TblCat.Catagory, TblManufacturers.Name, TblPrducts.ManCode FROM (TblPrducts INNER JOIN TblManufacturers ON TblPrducts.ManCode = TblManufacturers.ID) INNER JOIN TblCat ON TblPrducts.ProductCategory = TblCat.ID WHERE (((TblCat.ID)=8)) ORDER BY TblManufacturers.Name;" SQL5 = "SELECT DISTINCT TblCat.ID, TblCat.Catagory, TblManufacturers.Name, TblPrducts.ManCode FROM (TblPrducts INNER JOIN TblManufacturers ON TblPrducts.ManCode = TblManufacturers.ID) INNER JOIN TblCat ON TblPrducts.ProductCategory = TblCat.ID WHERE (((TblCat.ID)=9)) ORDER BY TblManufacturers.Name;" %>
SCREEN SAVERS
Cars
Race cars
Bikes
Personalities
Workers

A3 Print
£6.99
T-Shirt
£12.99

Key Rings
£1.99
Teddy Bear & T-shirt
£9.99

A3 Black Ash Framed Print
£14.99
Polo Shirt
£19.99
Mouse Mat
£7.99
CD Rom
£10.00 inc P&P

A3 Clip Framed Print
£10.99
Sweatshirt
£24.99


Mugs
£5.99


Paper Catalogue
£2.00
KOOLART WORLDWIDE
CD Version 3 © Motorsport World 2001  |  back orders  |  tax  |  credit card security  |  privacy policy

Visit Motorsport World on this CD