2. ASPRunnerPro General questions
  3. multiple words in search page text field
This topic is locked

multiple words in search page text field

 		1/28/2008 10:54:49 PM
ASPRunnerPro General questions
M
 mandlebrian author

I am trying to figure out how I can search using more than one word in a text field on my search page. The search doesn't work if all of the words are not in the contained in the field even when you select the contains tab. Any help would be greatly appreciated. Thanks
J
 		Jane 1/29/2008

Hi,
you can do the following:

  • edit your SQL query on the Edit SQL query tab.

    Here is a sample:
    select field1,

    field2,

    field3,

    field3 as field3_2,

    ...

    from TableName


  • check field3_2 on the advanced search page only on the Choose fields tab,
  • and use this field for the second search word on the advanced search page.