Hello everyone!
Could someone please assist me with the following: how do I insert a string
into an SQLite database that contains a CR or LF character? C-style escapes
(like \r and \n) are not working with SQLite, so how can I do this?
Thanks in advance!
With best regards,
J.R.
VALUES ('blablabla'||x'0A'||'yadayadayada');
I'm getting "Expression tree is too large (maximum depth 1000)" error...
Any ideas on how to cope with this?
Thanks again!
With best regards,
J.R.
On Nov 14, 2007 3:19 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Jevgenijs Rogov
am I doing wrong?
With best regards,
J.R.
On Nov 14, 2007 3:38 PM, 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\nyadayadaya
AIL PROTECTED]> wrote:
> On Wed, 2007-11-14 at 15:38 +0200, Jevgenijs Rogovs 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');
> >
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
Thanks!
Simplest solutions tend to be forgotten, unfortunately...
What I did was to simply replace every occurence of \r\n in my script with
LF character...
And it worked like a charm!
Thanks again!
With best regards,
J.R.
On Nov 14, 2007 4:46 PM, <[EMAIL PROTECTED]> wrote:
> &
Hi everyone,
I have a script that does some backup. Amongst other things, it dumps
certain SQLite database, like sqlite3 /path/to/db/dname.db .dump > somefile.
When I run the script manually from the command line, it works like a charm.
If, however, I launch it via crontab - it fails. sqlite3
7 matches
Mail list logo