On Wed, Oct 24, 2012 at 07:27:57AM +0000, YAN HONG YE scratched on the wall: > 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.
SQL string literals use single quotes. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users