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 3 2641
remove the = after LIKE
"David" <da***@brown6669.freeserve.co.uk> wrote in message
news:CL*************@newsfep3-gui.server.ntli.net... 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: QueenArenA.com |
last post by:
I have a big problems because I have to query a database which
contents contains some - ' - characters and obviously the query back
with errors.
An example is in www.queenarena.com/turbol.php
...
|
by: Jeffrey A. Hawkins |
last post by:
Hi,
I have been able to JOIN ON CONTAINS(column, 'whatever'), but can't seem to
get the syntax right to join on one field containing a related field.
The query below is what I am working...
|
by: Rick Brown |
last post by:
I'm trying to scan a barcode that contains the text string
"BPWOT08762" into a textbox for use in a DLookup or query grid.
I want to look thru a table's field that contains the last 6
characters...
|
by: Jack |
last post by:
Hi,
I am trying to find rows where a memo field in table1 contains the text in
table2.
Example:
table1.memo contains:
row 1: This is a long sentence that goes on and on...
row 2: This is...
|
by: David Garamond |
last post by:
Reading the archives and the FAQ, it seems to be implied that LIKE can
use index (and ILIKE can't; so to do case-insensitive search you need to
create a functional index on LOWER(field) and say:...
|
by: Kevin Macdonald |
last post by:
I expected Postgresql to use an indexed access method, but in certain cases
it is using a sequential scan. Details are below:
Table:
P1_NRN_ROAD (
sobjid int8 primary key,
v int8...
|
by: nethravathy |
last post by:
Hi,
The following table namely elcbtripselect contains 5147 records.I want to know wether this table contains duplicate records or not.
I tried with following query
1)SELECT...
|
by: Ralf Rottmann \(www.24100.net\) |
last post by:
I recently stumbled across a pretty interesting LINQ to SQL question and
wonder, whether anybody might have an answer. (I'm doing quite some
increasing LINQ evangelism down here in Germany.).
...
|
by: Andy |
last post by:
Hi,
I'm trying to add a where clause to my query:
List<stringtypes = new List<string>();
types.Add( "A" );
types.Add( "B" );
query = query.Where( c =types.Contains( c.Type ) );
|
by: dmorand |
last post by:
I've got a table which contains some items that I need to compare against another table which contains a more detailed look at the items, and there could be multiple.
Example:
Table1:
Field:...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |