[ic] interchange and SQL DBMSes: /scan/ fetches anything?!

Stefan Hornburg racke at linuxia.de
Mon Aug 25 12:57:02 EDT 2003


On Sat, 23 Aug 2003 18:57:59 +0200
Steffen Dettmer <steffen at dett.de> wrote:

> * Jonathan Clark wrote on Sat, Aug 23, 2003 at 16:34 +0100:
> > > Is this a bug in /scan/? Did I something wrong? Or does /scan/ is
> > > implemented to verify the condition by itself after fetching
> > > *any* possibly needed date from the DBMS?
> > 
> > My guess is that you are not performing a coordinated search.
> 
> I set co=yes. That's correct?
> 
> > If I do a search:
> > 
> > se=foo
> 
> You mean, without "sf"? I have two se and two sf fields.
> 
> > then where is Interchange going to look for 'foo'? Answer is all fields in
> > all records of the products table.
> 
> I had a customized menu_link that constructed:
> 
> /scan/st=db/co=yes/sf=category/se=Kleberoller/sf=products:shop_id/se=0/ml=10/va=banner_image=/va=banner_text=.html
> 
> and so on. Is that constructed wrongly, maybe misordered? The
> intention was to say something like:
> 
> SELECT * FROM products 
> 	WHERE category='Kleberoller' 
> 	  AND products.shop_id = 0;
> 
> What did I miss?

Try st=db/co=yes/sf=category/se=Kleberoller/op=eq/sf=shop_id/se=0/op=eq

Ciao	
	Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team



More information about the interchange-users mailing list