tom smith <[EMAIL PROTECTED]> wrote:
> objectized, it worked but it sucked, and the first thing I did was to
> circumvent it to be able to add text ala "clauses". Because making a simply
> query used to take a fortnight.
>
> Using objects is great, but sql is great (ish) too. I think using 3 lines,
> like the example, above to write the one liner (below), which incidentally,
> reads well...
>
> "state = 'NJ' and 'extension' = 1111 and duration > 60"
>
> ...is overkill. The tables are "like" objects, so we should treat them so,
> queries are like more like prose.
Of course, no one actually writes that clause. They write something
like "state = '%s' and %s = %s and duration > 60" % ("NJ",
"extension", 1111, 60), or something of that sort. So it kinda sucks
any way you do it.
Prose is what the programming is itself. Unfortunately, a SQL query
means writing a program that runs on the DBMS, not in your native
language. That's awkward too, just like the builder is awkward.
Ian
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss
