[ic] Searching multiple fields question

David Bordas interchange-users@interchange.redhat.com
Thu Nov 15 02:37:00 2001


Hi,

here an exemple that i use and it works great
<<
  <form action="[area search]" method=post>
<input type=hidden name="mv_searchtype" value="sql">
<input type=hidden name="mv_sort_field" value="category">
<input type=hidden name="mv_sort_field" value="description">
<input type=hidden name="mv_sort_field" value="">
<input type=hidden name="mv_coordinate" value="yes">
<INPUT TYPE=hidden NAME=mv_search_map VALUE="
        mv_searchspec=search1
        mv_searchspec=search2
        mv_searchspec=search3
        mv_searchspec=search4
        mv_searchspec=search5">
<INPUT TYPE=hidden NAME="mv_search_field" VALUE="marque">
<INPUT TYPE=hidden NAME="mv_search_field" VALUE="category">
<INPUT TYPE=hidden NAME="mv_search_field" VALUE="age">
<INPUT TYPE=hidden NAME="mv_search_field" VALUE="description">
<INPUT TYPE=hidden NAME="mv_search_field" VALUE="comment">
>>

If this can help you...
David
----- Original Message -----
From: "Steffen Dettmer" <steffen@dett.de>
To: <interchange-users@interchange.redhat.com>
Sent: Wednesday, November 14, 2001 11:40 PM
Subject: [ic] Searching multiple fields question


> Hi,
>
> I just don't get it. What I try to do is the following: searching
> a text in products comment and description. I have a second
> condition, the shop_id must match a scratch value. I tried for
> instance:
>
> <INPUT TYPE=hidden NAME=mv_search_map VALUE="
> mv_searchspec=search_id
> mv_searchspec=search_word
> ">
>
> <INPUT TYPE=hidden NAME=mv_coordinate VALUE=1>
> <INPUT TYPE=hidden NAME=mv_searchtype VALUE=db>
> <INPUT TYPE=hidden NAME=mv_matchlimit VALUE=[control matches 10]>
> <INPUT TYPE=hidden NAME=mv_sort_field VALUE=category>
> <INPUT TYPE=hidden NAME=mv_search_field VALUE="products:shop_id">
> <INPUT TYPE=hidden NAME=mv_search_field
> VALUE="products:comment,products:description">
> <input type=hidden name=mv_substring_match value=1>
> <INPUT TYPE=hidden NAME=mv_column_op VALUE=em>
> <INPUT TYPE=hidden NAME=mv_column_op VALUE=rm>
> <INPUT TYPE=hidden NAME=search_id VALUE="[scratch shop_id]">
> <INPUT MAXLENGTH=30 NAME=search_word type=text size=8>
>
> This is not working as I want. Is
> <INPUT TYPE=hidden NAME=mv_search_field
> VALUE="products:comment,products:description">
>
> equal to:
> <INPUT TYPE=hidden NAME=mv_search_field
> VALUE="products:description">
> <INPUT TYPE=hidden NAME=mv_search_field
> VALUE="products:comment">
>
> ? In that case I understand why it's not working as I need it.
> Then I would need to use mv_searchor, but it seems that this can
> be used only once, so this would search for the right shop_id or
> the word.
>
> Any suggestions?
>
> Thank you!
>
> oki,
>
> Steffen
>
> --
> Dieses Schreiben wurde maschinell erstellt,
> es trägt daher weder Unterschrift noch Siegel.
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users