[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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/