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
>>
>
> C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img
> src='||pic||'height=120px',pcs from engine where id>7 " >>
> n.html
> --
>--
>   --
>  --Ô¿Ô--
> K e V i N

Or
C:\t9>sqlite3 -html -header t9_engine.db "select
id,partnumber,'imgsrc='||pic||'height=120px',pcs
from engine where id>7 " >>n.html

to fix the specific error message...

Regards,
Simon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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
src='||pic||'height=120px',pcs from engine where id>7 " >>
n.html
--
   --
  --
 --Ô¿Ô--
K e V i N
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 " >> n.html
>
> Error: near "&": syntax error
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users