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
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
2 matches
Mail list logo