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

[YAN HONG YE]

char bh1[320];
memset(bh1,0,320);
strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select 
id,partnumber,substr(\'<img src=\"\'||pic||\'\" height=220/>\',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 id,partnumber,substr('<img src="'||pi
c||'" height=220/>',1,180) as img,pcs from engine where id>7;" >> n.htmlError: n
ear "'<img src='": syntax error
'pic' is not recognized as an internal or external command,
operable program or batch file.
The system cannot find the path specified.

char bh1[320];
memset(bh1,0,320);
strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select 
id,partnumber,substr(\'<img src=\"\'||pic||\'\" height=220/>\',1,180) as 
img,pcs from engine where id>7;\" >> n.html");
strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select id,partnumber,'<img 
src='||pic||' height=220/>' as img,pcs from engine where id>7;\" >> n.html");
system(bh1);                          //here could work
the result is:
<TR><TD>8</TD>
<TD>AA34841687 000 INSONO-SOUS-MOTEUR--</TD>
<TD>&lt;img src=C:\t9\images\INSONO-SOUS-MOTEUR.jpg height=220/&gt;</TD>   
//here I wanna add " char between  'C:\t9\images\INSONO-SOUS-MOTEUR.jpg'  
<TD>1</TD>
</TR>

and the best way is change 
&lt;    to      <
&gt;    to      >

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users