re-hi, but how do we do if we are on unix and there is some CR on those field? I cannot insert CR in my statement (only line feed)
do you have any suggestion? Cheers, Sylvain On Fri, Apr 3, 2009 at 2:15 PM, Sylvain Pointeau <sylvain.point...@gmail.com > wrote: > Hi, > thank you very much for your answers, > > I didn't think to put the real line feed into my shell script command line. > > Cheers, > Sylvain > > > On Fri, Apr 3, 2009 at 1:35 PM, Emil Obermayr <n...@nobswolf.info> wrote: > >> On Fri, Apr 03, 2009 at 12:25:18PM +0200, Sylvain Pointeau wrote: >> > >> > How do I specify the character "line feed" (\n) >> > in my query? >> >> Depends a little on your wrapper (outer) programming language. >> >> A technic that works in most language is to fill a variable with the >> code of LF and then use this variable to concatenate the string. Even >> the \n stuff should work in many languages. >> >> Tell us your coding language to get more specific hints. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users