Re: [sqlite] problem about output html in c++

2012-09-19 Thread Simon Slavin
On 19 Sep 2012, at 6:43am, YAN HONG YE wrote: > sqlite3 -html -header t9_engine.db "select id,partnumber,pic,pcs from engine > where id>7;" >> mm.html > > the pic result is "c:\abc.jpg"... > but I wanna the result is > "" You can use '||' to add strings together. So it could be SELECT id,p

[sqlite] problem about output html in c++

2012-09-18 Thread YAN HONG YE
sqlite3 -html -header t9_engine.db "select id,partnumber,pic,pcs from engine where id>7;" >> mm.html the pic result is "c:\abc.jpg"... but I wanna the result is "" how to do? maybe use sqlite3_step, but I don't know how to realize. thank you! ___ s