[ic] loop search fails with SQl database
Mike Heins
interchange-users@icdevgroup.org
Wed Jun 25 11:10:01 2003
Quoting Rolf Schaufelberger (rolf.schaufelberger@web.de):
> I have Interchange V4.8.7 up an d running whith the foundation store.
> Next I implemented the tutorial store which also worked fine. Now I changed
> the products database from txt file to mysql table. The table was created
> manually (not filled by makecat). Now, my index.html with [loop search=..]
> does'nt show anything, while [sql typ=list...] works.
> In detail :
>
[snip]
> Next
> =========================
> rs@linux:~/catalogs/tutorial> ls -l products/
> insgesamt 16
> -rw------- 1 rs users 19 Jun 25 10:30 products.autonumber
> -rw------- 1 rs users 1 Jun 25 10:16 products.sql
> -rw-r--r-- 1 rs users 0 Jun 25 10:51 products.txt
There you go. By default, the search is a text search, and you have
nothing in the text file. Either:
[loop search="
ra=yes
ml=1000
st=db
"][loop-code]<br>[/loop]
or:
[index table=products export-only=1]
[loop search="
ra=yes
ml=1000
"][loop-code]<br>[/loop]
--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.513.523.7621 <mike@perusion.com>
Prove you aren't stupid. Say NO to Passport.