Access & SQL Search HELP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Access & SQL Search HELP

Author

Topic

malhyp
Starting Member

21 Posts

Posted - 2005-12-10 : 06:19:41

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.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-10 : 07:07:32

dup [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58914[/url]

-----------------
[KH]
Where Am I ?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources