Re: [sqlite] FW: how to select " char in sqlite

2012-10-26 Thread Patrik Nilsson
There is always the possibility of converting a string into hex. http://www.sqlite.org/lang_expr.html "Literal Values" Example: X'53514C697465' /Patrik On 10/26/2012 12:08 PM, Kees Nuyt wrote: > On Fri, 26 Oct 2012 01:25:24 +, > YAN HONG YE wrote: > >> char

Re: [sqlite] FW: how to select " char in sqlite

2012-10-26 Thread Kees Nuyt
On Fri, 26 Oct 2012 01:25:24 +, YAN HONG YE wrote: >char bh1[320]; >memset(bh1,0,320); >strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select >id,partnumber,substr(\'\',1,180) as >img,pcs from engine where id>7;\" >> n.html"); >system(bh1);

[sqlite] FW: how to select " char in sqlite

2012-10-25 Thread YAN HONG YE
char bh1[320]; memset(bh1,0,320); strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select id,partnumber,substr(\'\',1,180) as img,pcs from engine where id>7;\" >> n.html"); system(bh1); //here couldn't work error: sqlite3 -html -header t9_engine.db "select

[sqlite] FW: how to select " char in sqlite

2012-10-25 Thread YAN HONG YE
char bh1[320]; memset(bh1,0,320); strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select id,partnumber,substr(\'\',1,180) as img,pcs from engine where id>7;\" >> n.html"); system(bh1); //here couldn't work error: sqlite3 -html -header t9_engine.db "select

Re: [sqlite] FW: how to select " char in sqlite

2012-10-24 Thread Kees Nuyt
On Wed, 24 Oct 2012 09:00:31 +, YAN HONG YE wrote: > >sqlite3 -html -header t9_engine.db "select id,partnumber,\"abc.jpg\" as >img,pcs from engine where id>7;" >> n.html >here \"abc.jpg\" couldn't work. Please be more specific about "couldn't

[sqlite] FW: how to select " char in sqlite

2012-10-24 Thread YAN HONG YE
sqlite3 -html -header t9_engine.db "select id,partnumber,\"abc.jpg\" as img,pcs from engine where id>7;" >> n.html here \"abc.jpg\" couldn't work. sqlite3 -html -header t9_engine.db "select id,partnumber,'' as img,pcs from engine where id>7; ">> n.html Same problem.