Re: [sqlite] export html error

2012-09-21 Thread Simon Davies
On 21 September 2012 10:35, Kevin Benson wrote: > On Fri, Sep 21, 2012 at 4:30 AM, YAN HONG YE wrote: > >> C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img >> src= >> t'||pic||'height=120px',pcs from engine where id>7 " >> n.html

Re: [sqlite] export html error

2012-09-21 Thread Kevin Benson
On Fri, Sep 21, 2012 at 4:30 AM, YAN HONG YE wrote: > C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img > src= > t'||pic||'height=120px',pcs from engine where id>7 " >> n.html > C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img

Re: [sqlite] export html error

2012-09-21 Thread John Clegg
You need to replace with the less than sign, with a quote, with the greater than sign On 21 September 2012 09:30, YAN HONG YE wrote: > C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img > src= > t'||pic||'height=120px',pcs from engine where id>7 " >>

[sqlite] export html error

2012-09-21 Thread YAN HONG YE
C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img src= t'||pic||'height=120px',pcs from engine where id>7 " >> n.html Error: near "&": syntax error ___ sqlite-users mailing list sqlite-users@sqlite.org