like / contains query

[David]

Hi,

I am trying to put a very basic search function on a web page. I'm using
access 2000 as the database, and have a memo field I want to search using a
keyword entered via a form.

The problem I'm having is I can't work out the correct syntax for the query.
What I'm trying is the "like" command, and am trying to work the query
below. articletext is a memo field, and querystring is passed from the form
on the search page. What syntax should I use please?

set rsData = con.execute("select topic, title, ID, description, dateno,
linktooriginal, summaryavail from journals where articletext LIKE =
'%"&searchstring&"%' ORDER BY dateno DESC")

Also, are there any tutorials on making a search engine to search memo
fields? Maybe an already made one?

Thanks

David

 

[Alex Goodey]

remove the = after LIKE

 

[David]

The specific error I get is:-

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'articletext LIKE =
'%medical%''.

/journal/searchdisplay.asp, line 83

I know for a fact there are many entries in the articletext memo field that
contain the keyword "medical"

Thanks

 

[David]

Thanks Alex!