[ic] loop search fails with SQl database

Kevin Walsh interchange-users@icdevgroup.org
Thu Jun 26 07:48:00 2003


Rolf Schaufelberger [rolf.schaufelberger@web.de] wrote:
> >
> > Have you tried adding st=db to your [loop] tag's search spec.?
> >
> Well this works. But it doesn't look veriy logical to me, as products has be 
> defined to be a sql-databse table. 
> 
Not true.  The default is for GDBM files.  If you need to search
against an SQL server then you must specify the non-default search
type.

>
> Appling the same to the search form doesn't work however.
> Taken the code form tutorial and taken the code from demo (foundation store , 
> search-box-samll) one works, the other doesn't:
> 
> code:
> =========   <
> form action="[area search]" method=post>
>    Suche:<br>
> <!-- code doesn't work -->
> 1   [set testname]su=yes/sf=description/st=db[/set]
> 2    <input type=hidden name=mv_profile value=testname>
> 3    <input type=text name=mv_searchspec size=15 value=""> 
> 
> <!--  code works
> 4	      <INPUT TYPE=hidden NAME=mv_searchtype VALUE=db>
> 5	      <INPUT TYPE=hidden NAME=mv_search_field VALUE="description">
> 6	      <input type=hidden NAME=mv_substring_match value=1>
> 7	      <INPUT type=text   NAME=mv_searchspec size=15>
> -->
> 
>     </form>==============
> 
Correct.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/