Mailing List Archive


Back to the month index Back to the list index
Dennis (dennis@etinc.com)
Sun, 1 Sep 1996 20:20:26 -0400 

Date: Sun, 1 Sep 1996 20:20:26 -0400
Message-Id: <199609020020.UAA13638@etinc.com>
From: dennis@etinc.com (Dennis)
Subject: Re: [mSQL] Multiple ORs - Possible?

>With operator precedence ("and" above "or") you could do it by expanding
>the query to
>
> A and C or A and D or B and C or B and D
>
>just like arithmetic; but if mSQL can get that far it may as well go for
>parentheses as well, since the big jump (implementing the necessary
>stacks) will have to be taken either way: parsing out parentheses is
>trivial after that.

Yucksters! This logic would be quite a bear when building dynamic queries
from form data!

It looks like I'll be doing some manual filtering after an initial query.

Is there an (easy) way to do 2 pass queries? With something like
paradox you can query_to_table, rename answer_table, re-query
which is ugly but easier than post-processing table results.

With much sadness,

dennis

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!