Igor Tandetnik wrote: > YAN HONG YE <yanhong...@mpsa.com> wrote: >> 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. > > Define "couldn't work". What outcome do you observe, what outcome do you > expect, and how do the two differ?
I'd guess the purpose of these queries is to generate an HTML table with images. sqlite> .mode html sqlite> select '<img src="something.jpg">'; <TR><TD><img src="something.jpg"></TD> </TR> But the sqlite shell always escapes special characters and thus cannot generate HTML tags. I'd recommend to export the data in some other format and then reformat it to HTML. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
