in reply to DBI:Mysql sql string multiline error
I write such things like so:
my $sql= join( ' ', "SELECT *", "FROM sometable", "WHERE something", );
It is a practice that has scaled very well for me for the several years I've been using it. Before that I tried quite a few different styles including here-docs (<<END), sprintf, and several flavors of qq<...\n...>. They all eventually sucked in too many cases.
- tye
|
|---|