[ic] loop search fails with SQl database
Rolf Schaufelberger
interchange-users@icdevgroup.org
Thu Jun 26 12:50:01 2003
>> 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.
Maybe I have to learn more "interchange thinking'. I thought, when I define
products in catalog.cfg to be a sql-database table, this would be valid for
all components.
>> 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.
What do mean with correct? I wanted to know, why lines 1-3 don't work. Well,
I've got a solution for this problem, see other posting.
Rolf Schaufelberger
rolf.schaufelberger@web.de