473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Keywords

If I want to use index keywords for a (simple) database of quotations, do I
need to set each word up in a separate field, or can I list multiple words
in a single field? Or is this the wrong question?
TIA

--
archy
"we only live, only suspire,
consumed by either fire or fire" (T.S. Eliot)
Nov 13 '05 #1
2 1659
"archy" <listsATactuallyDOTmeDOTuk> wrote in
news:43***********************@ptn-nntp-reader01.plus.net:
If I want to use index keywords for a (simple) database of
quotations, do I need to set each word up in a separate field,
or can I list multiple words in a single field? Or is this the
wrong question? TIA


The correct structure for a keywords table has two fields, the
first contains a word, the second contains the primary key to the
quotation record.

However, unless you are storing very long quotations, and lots of
them, the Jet engine is much quicker in finding the text directly
in the field that using a separate keywords table, routines that
then parse out your request and find a match.

SELECT * from Quotation WHERE Quotation.quotation LIKE "*brown fox
jumps*"

..
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #2
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1125615673.81ba7d99138a41266116cf6204c70855@t eranews...
"archy" <listsATactuallyDOTmeDOTuk> wrote in
news:43***********************@ptn-nntp-reader01.plus.net:
If I want to use index keywords for a (simple) database of
quotations, do I need to set each word up in a separate field,
or can I list multiple words in a single field? Or is this the
wrong question? TIA


The correct structure for a keywords table has two fields, the
first contains a word, the second contains the primary key to the
quotation record.

However, unless you are storing very long quotations, and lots of
them, the Jet engine is much quicker in finding the text directly
in the field that using a separate keywords table, routines that
then parse out your request and find a match.

SELECT * from Quotation WHERE Quotation.quotation LIKE "*brown fox
jumps*"

Thanks
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Nel | last post by:
Hi all, Before I re-invent the wheel here, has anyone willing to share a basic script to extract META keywords from a string. I have a string, let's say $pageText that contains the dynamic...
2
by: Cherry | last post by:
I have a trigger that won't compile: CREATE OR REPLACE TRIGGER TRG_CORRESPONDENCE_UPT AFTER UPDATE on TBLCORRESPONDENCE for each row BEGIN IF :OLD.Keywords <> :NEW.Keywords THEN
14
by: Jason Heyes | last post by:
I want to write a class that supports operations on keywords belonging to the C++ programming language. The following program repeatedly prompts the user for a keyword until 'explicit' is finally...
2
by: google | last post by:
I have a script which parses the BBC RSS feed once an hour, and drops any stories with certain keywords into a database. I would like to ban certain strings; at the moment the script will pick up...
2
by: dw | last post by:
Hi, everyone. I'm having difficulty understanding the difference of the keywords "friend" and "protected" vs. some of the other ways you can declare variables in ASP.NET ("dim", "public", and...
5
by: Digital.Rebel.18 | last post by:
I'm trying to figure out how to extract the keywords from an HTML document. The input string would typically look like: <meta name='keywords' content='word1, more stuff, etc'> Either single...
5
by: JP SIngh | last post by:
Hi All This is a complicated one, not for the faint hearted :) :) :) Please help if you can how to achieve this search. We have a freetext search entry box to allow users to search the...
9
by: Nenad Loncarevic | last post by:
I am a geologist, and over the years I've accumulated quite a number of proffesional papers on the subject, in various publications. I would like to make a database that would help me find the...
5
by: mforema | last post by:
Hi Everyone, I want to search records by typing in multiple keywords. I currently have a search form. It has a combo box, text box, Search command button, and a subform. The combo box lists the...
5
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
How can I get the list of connection string's keywords available in sqlclient programmatically? I have found the list in here...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.