If Windows get FART (find and replace text) from here: http://blog.secaserver.com/2011/07/windows-find-and-replace-text-command-line-utility/ If Unix learn sed: http://www.thegeekstuff.com/2009/09/unix-sed-tutorial-replace-text-inside-a-file-using-substitute-command/
Then sqlite3 test.db create table engine(id,partnumber,pic); insert into engine values(1,11,'1.jpg'); insert into engine values(2,22,'2.jpg'); insert into engine values(3,33,'3.jpg'); D:\SQLite>sqlite3 -html test.db "select id,partnumber,'XXLTimg src='||\"XXQUOTE\"||pic||\"XXQUOTE\"||' height=220XXGT' from eng ine;" fart test.html XXGT ">" fart test.html XXLT "<" fart test.html XXQUOTE ''" And you end up with: <TR><TD>1</TD> <TD>11</TD> <TD><img src='1.jpg' height=220></TD> </TR> <TR><TD>2</TD> <TD>22</TD> <TD><img src='2.jpg' height=220></TD> </TR> <TR><TD>3</TD> <TD>33</TD> <TD><img src='3.jpg' height=220></TD> </TR> Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of YAN HONG YE [yanhong...@mpsa.com] Sent: Wednesday, October 24, 2012 4:00 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] FW: how to select " char in sqlite 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,'<img src=\" '||pic||' \" height=220/>' as img,pcs from engine where id>7; ">> n.html Same problem. 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"); Same problem. _______________________________________________ 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
