On Fri, Mar 28, 2008 at 05:29:06PM -0400, Terry Lee Tucker wrote:
> Thanks Sam. No, that is not what I tried. I had tried:
> UPDATE bill SET notes = 'blah, blah, yeaE'\n'more stuff.'
> It didn't dawn on me that the E went in front of the whole string!
it's always easy when you know how!
> Thanks
On Friday 28 March 2008 17:21, Sam Mason wrote:
> On Fri, Mar 28, 2008 at 05:06:10PM -0400, Terry Lee Tucker wrote:
> > HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
> >
> > The problem is a line like 'UPDATE bill SET notes = 'blah, blah,
> > yea\nmore stuff';
> >
> > How to I esc
On Fri, Mar 28, 2008 at 05:06:10PM -0400, Terry Lee Tucker wrote:
> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
>
> The problem is a line like 'UPDATE bill SET notes = 'blah, blah, yea\nmore
> stuff';
>
> How to I escape the newline embeded in the string? I've tried the advic
