SQL call formatting style

[David Miller]

On 3/25/03 5:56 AM -0500, Jake wrote:

> Myk Melez wrote:
>
>> (queries with strings that may have newlines in them can't be easily
>> stripped of newlines with s/\s+/ /g).
>>
> In my brief testing, it also collapses newlines.

if you do s/\s+/ /gs (note the s on the end) it'll remove newlines.

What you want to be careful of is what if you have a quoted string which
contains multiple spaces within the query?  you don't want to remove the
spaces from the content of the string....

On the other hand, if we're using placeholders we shouldn't have to worry
about that because there won't be anything quoted in the query itself.
-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/