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.
> To view or change your list settings, click here:
More information about the developers