Forums
This topic is locked
SQL Search not working
10 Dec 2005 12:32:06 Malcolm X posted:
Can anyone suggest whey I dont get any results with this search?SQL reads:
SELECT SupplierName, Location, ShortDescription
FROM Query1
WHERE 'TimberSpecies' LIKE MMColParam AND 'CategoryTable' LIKE MMColParam2 AND 'Location' LIKE MMColParam3
MMColParam 1 Request.Form("keywordSearch"
MMColParam2 2 Request.Form("location"
MMColParam3 3 Request.Form("category"
Mally.