I have a MySql database and am using Lasso 7. The user enters search information on a form on a search.lasso page and an inline search is then run on a results.lasso page. I want to parse out what the user enters and search the text field and retrieve only those records that contain each word of the search.
For example: Where field is 'NAME'
Record 1 contains 'John Michael Smith'
Record 2 contain 'John Adams'
Record 3 conains 'John Smith'
Record 4 contains 'Michael Smith'
If the user searches the field by typing 'John Smith' his found set should contain Record 1 and Record 3 only.
How do I accomplish this?
This is the inline that I'm using.
[Inline:(Action_Params),-Search,-database='DATABASE',- Layout='CONTACTS',-Operator='ft','NAME'=(Action_Param:'NAME')]
Thanks for your help, David
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]