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

Steffen Dettmer steffen at dett.de
Sat Aug 23 19:57:59 EDT 2003


* 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?

Thank you and a nice weekend!

oki,

Steffen

-- 
Dieses Schreiben wurde maschinell erstellt,
es trägt daher weder Unterschrift noch Siegel.


More information about the interchange-users mailing list