Invalid SQL: INSERT INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('f0bb8b84ab5a7ce5aa9688917cb61ffc', '54.81.154.223', '1498227843', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1498227843', '0'); (The table 'swsessions' is full)
Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\support.inm.com\includes\functions.php:410) in C:\Inetpub\support.inm.com\includes\functions.php on line 1612
Performing text searches in a V12 database - Support Center
inm logo
Corporate Website | Contact | Store | Support | Login  
     


Knowledgebase
View categorized listing of all common frequently asked questions.
Downloads
View our categorized library of downloads for all necessary manuals, software, etc.
 Article Options
Support Center » Knowledgebase » INM V12 Database for Director » Performing text searches in a V12 database
Support Page Banner
 Performing text searches in a V12 database
Product:Platform:Area:Version:
INM V12 Database for DirectorWindows, MacintoshSearching and sorting3.x Regular & Light

Summary

It is possible to search through the text content in a V12 Database file by defining an index on a field. This will allow for quick sorting and searching of the first few characters of a field. In some applications – typically when fields contain extensive information – you need to search for words that appear anywhere in a field, very efficiently. This is where you need to define a full-text index [or full-index for short] on that specific field. A full-index is an index defined on every single word of a field.

Example

Let's suppose that we are using the following database.

none

In this example, looking for the word "Soup" in the Publication Title field requires a full-index for optimal search performance. If no index is defined on the Publication Title field, the same result can be achieved, but with slower performance. If a regular index is defined on the Publication Title field, publications that start with the word "Soup" can be quickly located, but publications that contain that word require more time. Full-indexes apply only to fields of type "string", including those which contain styled text (see Field Types, International Support and Managing Styled Text in the V12 user manual).

For optimal full-text search efficiency, some level of control is required on the way it is performed. For example, indexing trivial words such as "and", "or", "the", etc. (or equivalent words that appear frequently in your application's language) is useless, as most records would contain one or more occurrences of those words. INM V12 Database allows for this control via the use of Stop Words (see Stop Words in the V12 user manual).

To configure a field as full-indexed, you have to specify it as such in the database structure. For instance, if we want the publication title to be indexed in the precedent database, the structure should be the following one:

[TABLE]
Publications

[FIELDS]
LastName string
FirstName string
PublicationTitle string full-indexed

[END]

Then you can do your search as in any other search, using the mSetCriteria and mSelect method as described in the V12 user manual. For a complete code sample, we recommend that you download the open source "TextSeeker" sample available at the end of this page.

Note


Each index takes up disk space, so it is not recommended that all fields be indexed! Full-indexes require much more space than regular indexes. Indexed fields should be limited to those likely to be searched and sorted most often.

Sample


This sample is supported on Director 6.5 and later. zip   sit



Article Details
Article ID: 100
Created On: 26 Sep 2006 02:12 PM

 This answer was helpful  This answer was not helpful

inm general footer
Services Xtras Go Products Support Gallery Store Download About Us Contact Newsroom