[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