You need to replace < with the less than sign, " with a quote, > with the greater than sign
On 21 September 2012 09:30, YAN HONG YE <[email protected]> wrote: > C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'<img > src=&quo > t'||pic||"'height=120px>',pcs from engine where id>7 " >> n.html > > Error: near "&": syntax error > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

