Forums

This topic is locked

Autocomplete 1.04 search problem

Posted 23 Jun 2009 01:23:53
1
has voted
23 Jun 2009 01:23:53 Jason Burns posted:
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

Reply to this topic