Re: [sqlite] Re: Re: INSERT: how to include CR & LF symbols in a string constant?

2007-11-14 Thread Simon Davies
On 14/11/2007, Jevgenijs Rogovs <[EMAIL PROTECTED]> wrote: > Sounds too complicated for this simple situation... > Can anything be done w/o coding? > Why not change INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada'); into INSERT INTO sometable VALUES ('blablabla yadayadayada'); (real r

Re: [sqlite] Re: Re: INSERT: how to include CR & LF symbols in a string constant?

2007-11-14 Thread Jevgenijs Rogovs
Sounds too complicated for this simple situation... Can anything be done w/o coding? On Nov 14, 2007 3:53 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Jevgenijs Rogovs <[EMAIL PROTECTED]> > wrote: > > Thanks, but how do I use those? > > See, I have a huge file of INSERT statements, which look

[sqlite] Re: Re: INSERT: how to include CR & LF symbols in a string constant?

2007-11-14 Thread Igor Tandetnik
Jevgenijs Rogovs <[EMAIL PROTECTED]> wrote: Thanks, but how do I use those? See, I have a huge file of INSERT statements, which look like this: INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada'); Prepare a single statement of the form INSERT INTO sometable VALUES (?); Then read your