Re: [sqlite] export html error

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 " >>

Re: [sqlite] Count(*) help

Yes, that was the problem thanks. Even though sqlitebrowser declared them as empty with '' ! On 17 September 2012 15:50, Black, Michael (IS) wrote: > Or just fix the existing table: > > update members set year2007=NULL where year2007=''; > update members set year2008=NULL

Re: [sqlite] Count(*) help

se by any chance the ISUG members? > Doing a count without a WHERE clause is always likely to give different > results > with the various SQL implications as far as I know. > Why not add a WHERE? > > RBS > > > On Sun, Sep 16, 2012 at 5:17 PM, John Clegg <john.cl...@nailsea.net&g

[sqlite] Count(*) help

I have a table Members with 896 rows and a text field "Year2012". It contains "Paid" 156 times, "Comp" 13 times and the rest are null (confirmed in sqlitebrowser as "empty") Back in the olden days when this table was in Access, select count("Year2013") from Members used to return 169. In