Ray - I think that's what I have already used to create this page in the first place. The code I pasted into my initial post shows the select statement that resulted from that.
But - I started a new page, added a recordset to it. Then I inserted DataAssist > Database Search Wizard. Next, I chose a search page and a form name. Then I Add a search element that is Advanced Text Search. I select the fields I want to search, and specify a New Form Field (text) that I have called "Keywords". I make no further changes by clicking through the next step. The summary shows me -
Creating Search Page: test3-search.php
Creating Form: form1
Creating form element: Keywords
Applying to Recordset: rsData2
Advanced Text Search in item_primary, item_secondary, item_content from Keywords
This new search results page looks identical to my original post - it has:
//comparison list additions
So I added
the exit command, and uploaded.
When I fill in and submit the form, I'm getting exactly what I posted before -
SELECT * FROM items WHERE ((((item_primary LIKE '%Remington%') OR (item_secondary LIKE '%Remington%') OR (item_content LIKE '%Remington%')) OR ((item_primary LIKE '%military%') OR (item_secondary LIKE '%military%') OR (item_content LIKE '%military%'))) OR ((item_primary LIKE '%weapon%') OR (item_secondary LIKE '%weapon%') OR (item_content LIKE '%weapon%')))
I'm not getting the "AND" conjunction in there as you say I should be.