Search using Combo Boxes

[patelajk]

Hi guys I have 3 combo boxes in a search form. A user makes a selection form
these combo boxes, clicks on search and all results based upon that search are
displayed. The problem is that users have to make a selection from all 3 boxes
in order for results to be displayed. If a users selects just one or two boxes
no results are displayed. Does anyone know how I can build a search in which
it will display data based on what they have selected, no matter if 1 or 2
combo boxes have been selected. Here is the SQL I am using: SELECT
hpamidas.tbl_manufacturers.Manufacturer,
hpamidas.tbl_manufacturers.Manufacturer_ID, hpamidas.tbl_products.Kit_Name,
hpamidas.tbl_products.Marker, hpamidas.tbl_products.Detection,
hpamidas.tbl_products.Format, hpamidas.tbl_products.Ce_marked,
hpamidas.tbl_products.image_url, hpamidas.tbl_products.pdf_url FROM
hpamidas.tbl_manufacturers FULL OUTER JOIN hpamidas.tbl_products ON
hpamidas.tbl_manufacturers.Manufacturer_ID =
hpamidas.tbl_products.Manufacturer_ID WHERE hpamidas.tbl_products.Marker =
'MMColParam' AND hpamidas.tbl_products.Detection = 'MMColParam2' AND
hpamidas.tbl_products.Format = 'MMColParam3' ORDER BY
hpamidas.tbl_manufacturers.Manufacturer ASC I know that the problem is me
using AND but I do not know an alternative, OR does not work I am using ASP
VBSctipt and SQL Server 2000. Any help would be great

[Julian Roberts]

Have a look at my 'select all' demo

[url]http://www.charon.co.uk/files.aspx?categoryid=15&filecategoryid=10[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004