On Fri, 9 Jul 1999, Microwave Systems Eximlist Exploder wrote:
> Hrm.. how about being allow to specify the exact SQL query that is
> used, as an expanded string? Seems that would be the most flexible.
(Whether or not it is an expanded string is not relevant at the lookup
code level - that happens (or not) at higher levels.)
Yes indeed. I wonder why Paul did it the way he did? Maybe he will
respond to the message. I can think of some possible reasons:
(1) You probably need to specify the table_name separately anyway. (I
have discovered since my posting that from 3.22 onwards, MYSQL allows
you to specify "database.table" instead of just "table", so that handles
one of my points.)
(2) By not including the noise words "select" "from" and "where" in the
actual query, you keep the queries less verbose.
(3) You don't allow anything other than "select" commands, so you can't
mess with the database by accident.
I've never used SQL until I started playing (just a bit) in order to do
this work, though I'm familiar with the concepts. That's why I'm asking
for other opinions on the list...
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
