[ic] extended text based search with where statements

Marko kuzio marko-kuzio-fisi at gmx.de
Fri Sep 8 20:24:34 EDT 2006


hello list,

i use the follow code for the text-based search engine:

  <form action="[area search]" method=post>
  Search:<br>
  [set search_param]
     su=yes
     fi=article
     sf=description
     tf=1
     to=n
   [/set]
  <input type=hidden name=mv_profile value=search_param>
  <input type=text name=mv_searchspec size=15 value="">
  </form>

this is equal to "select * from article where description = param "
(in the sql mode)

is it possible to create an search form profile which is equal
to the follow sql statement for an text based search in the search engine:

select * from article where description = param
and type ~* 'criteria|criteria2' OR group like 'n*';

my target is to filter the search results to type and group values.

thx.


More information about the interchange-users mailing list