[ic] loop search fails with SQl database

[Mike Heins]

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.