SQL call formatting style

Sergey A. Lipnevich sergeyli at pisem.net
Tue Mar 25 14:53:01 UTC 2003

I started coding SQL like this (as scalar, akin to shell's cat << EOF 
... EOF) some time ago and now I hate when the language that doesn't 
allow that (e.g. Java). In situations like Java+SQL I'm willing to go 
extra length and store SQL in external config file, but not concatenate
clauses together in the code. It's absolutely worth it, and 
parameterized (prepared) statements with question marks are what they 
call "enabler" in this case. My $.0029/line.

Bradley Baetz wrote:
> See my comments in the bug for why I think my way is better. Lots of " .
> " suck, basically, especially since we are no longer doing
> interpoliating, and " . sqlQuote($foo) . " everywhere, but are using
> laceholders instead.
> Bradley
> ----
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=gcbd-developers@gmane.org>

More information about the developers mailing list