This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » Ajax & JavaScript » Autocomplete 1.04 search problem

Autocomplete 1.04 search problem
Jason Burns Member Since: 05 Apr 2001 Posts: 24	Posted 23 Jun 2009 01:23:53 Hi For a table column that contains the text ' orange blue green ' If a user types 'orange blue' Autocomplete finds the column If a user types 'blue green' Autocomplete finds the column If a user types 'orange green' Autocomplete DOES NOT find the column For the actual search when the user submits the form, I am using a SearchArray = Split(SearchField," ", for i = 0 to Ubound(SearchArray) ... method to generate a SQL statement that returns results that contain all keywords ANYWHERE in a table column. Any ideas how to change the SQL for this, please? Jason Burns Touch Web Edited by - Jason Burns on 25 Jun 2009 12:34:44 Hi For a table column that contains the text ' orange blue green ' If a user types 'orange blue' Autocomplete finds the column If a user types 'blue green' Autocomplete finds the column If a user types 'orange green' Autocomplete DOES NOT find the column For the actual search when the user submits the form, I am using a SearchArray = Split(SearchField," ", for i = 0 to Ubound(SearchArray) ... method to generate a SQL statement that returns results that contain all keywords ANYWHERE in a table column. Any ideas how to change the SQL for this, please? Jason Burns Touch Web Edited by - Jason Burns on 25 Jun 2009 12:34:44

Autocomplete 1.04 search problem

Jason Burns
Member

Since: 05 Apr 2001
Posts: 24

Posted 23 Jun 2009 01:23:53

Hi

For a table column that contains the text ' orange blue green '

If a user types 'orange blue' Autocomplete finds the column
If a user types 'blue green' Autocomplete finds the column
If a user types 'orange green' Autocomplete DOES NOT find the column

For the actual search when the user submits the form, I am using a SearchArray = Split(SearchField," "

, for i = 0 to Ubound(SearchArray) ... method to generate a SQL statement that returns results that contain all keywords ANYWHERE in a table column.

Any ideas how to change the SQL for this, please?

Jason Burns
Touch Web

Edited by - Jason Burns on 25 Jun 2009  12:34:44

Hi

For a table column that contains the text ' orange blue green '

If a user types 'orange blue' Autocomplete finds the column
If a user types 'blue green' Autocomplete finds the column
If a user types 'orange green' Autocomplete DOES NOT find the column

For the actual search when the user submits the form, I am using a SearchArray = Split(SearchField," "

, for i = 0 to Ubound(SearchArray) ... method to generate a SQL statement that returns results that contain all keywords ANYWHERE in a table column.

Any ideas how to change the SQL for this, please?

Jason Burns
Touch Web

Edited by - Jason Burns on 25 Jun 2009  12:34:44

Forums

Autocomplete 1.04 search problem

Reply to this topic

Live Support

On Sale

Advanced HTML Editor 3

Image Gallery Add-on

File Manager Add-on

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Message
Reply