From: Chuck E. <Chu...@ya...> - 2001-10-08 00:06:07
|
At 01:27 AM 10/7/2001 -0500, Ian Bicking wrote: >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. Perhaps they would write: "state='%(state)s' and %(field)s=%(value)s and duration>%(duration)s" % locals() Which still isn't so bad. >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. But many of these sql clause are both easy to understand and highly portable. At least the ones that simply filter on fields in a single table. -Chuck |