[ic] select * from products

Alexander Schmitz interchange-users@icdevgroup.org
Tue May 20 12:19:01 2003


...
> co=1
> st=db
> lf=description
> ls=example
>
> should add
>
> where description like 'example%' (or the Postgres equivalent)
> to your query.

Thanks Racke, i  watched the thread and used the Information to speed up my 
searches. One thing i recognized brings up some Questions.

Not to use the se=SEARCHWORD in the search brings up an Error in the Log Files 
but it works with the expected Search Result.:

------------------
127.0.0.1 QxabMuy9:127.0.0.1 - [20/May/2003:18:06:26 +0200] shop 
/cgi-bin/ic/shop/scan/fi=products/co=yes/st=db/sf=comb_category/lf=comb_category/ls=SEARCHWORD 
search error: Search strings must be at least 1 characters.
> You had no search string specified.
------------------

Code example:
-------------------
[page   search="
                        fi=products
                        co=yes
                        st=db
                        sf=comb_category
                        lf=comb_category
                        ls=SEARCHWORD
                "]
------------------
Interchange Version = 4.8.6

A Bug or am i wrong ? 

Thanks Alex