M.C. Gill Corp. - Products

<% @LANGUAGE="VBScript" %> M.C. Gill Corp. - Products

Products Overview

OEM

Express Service
Products

Full Catalog

Material Safety
Data Sheets

Instruction Manuals

Glossary

Home

Return to Products

Download Acrobat Reader

<% SQL="SELECT Products.name, Products.prodNumber, Products.description, Products.file, Category.categoryName FROM Products INNER JOIN (Category INNER JOIN [Prod:Cat] ON Category.categoryID = [Prod:Cat].categoryID) ON Products.productID = [Prod:Cat].productID WHERE (((Category.categoryName) Like '%" & Request.QueryString("cat") & "%')) ORDER BY Products.prodNumber;" Set rsProducts = Conn.Execute(SQL) %>
<%= rsProducts("categoryName") %>

<% rsProducts.MoveFirst Do While Not rsProducts.EOF %> <% rsProducts.MoveNext Loop 'Close the recordset when all done looping and displaying rsProducts.close Set rsProducts = Nothing Conn.Close Set Conn = Nothing %>

M.C. Gill
Product Description

<% If rsProducts("file")="" Then %> <%= rsProducts("name") & " " & rsProducts("prodNumber") %> <% Else %> "><%= rsProducts("name") & " " & rsProducts("prodNumber") %> <% End If %> <%= rsProducts("description") %>

Back to Top

Return to Products

Viewing Product Data Sheets Online
The Data Sheets are provided in .pdf format. If you don't have Acrobat Reader installed on your computer already, click here for the free download.

Need help downloading or installing Acrobat Reader? Click here.

Product Search

Search for:
in

Site Map | FAQs | Legal | Privacy | Contact Us

M.C. Gill Corporation:

Castle | Insoleq | Alcore | Alcore Brigantine