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><img src=C:\t9\images\INSONO-SOUS-MOTEUR.jpg height=220/></TD> //here I wanna add " char between 'C:\t9\images\INSONO-SOUS-MOTEUR.jpg' <TD>1</TD> </TR> and the best way is change < to < > to > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users