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