[ic] interchange and SQL DBMSes: /scan/ fetches anything?!
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:
> 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?
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