[sqlite] Broken link

2004-11-13 Thread Tito Ciuro
Hello, The link to the 'precomp_test.c' file seems to be broken: http://cvs.hwaci.com/sqlite/attach_get?id=58,precomp_test.c Does someone have this file? Thanks, -- Tito

Re: [sqlite] SQLite Book

2004-11-13 Thread D. Richard Hipp
Bertrand Mansion wrote: Tiago Dionizio wrote: I just found that there is a book about SQLite and thought you would like to know. link to page: http://www.quepublishing.com/title/067232685X I prefer to wait for DR Hipp's book... :) I'm too busy writing software to take time to write a book right

Re: [sqlite] SQLite Book

2004-11-13 Thread Bertrand Mansion
Tiago Dionizio wrote: >I just found that there is a book about SQLite and thought you would >like to know. > >link to page: http://www.quepublishing.com/title/067232685X > >Book Description > >SQLite is a small, fast, embeddable database. What makes it popular is >the combination of the database

Re: [sqlite] SELECT SUM( IF(

2004-11-13 Thread Daniel K
--- [EMAIL PROTECTED] wrote: > Hello, > > Does SQLite have kind of conditional select > expression like: > SELECT SUM( IF(column1='Y', column2, 0 ) FROM ... ? > > > Rainer > > It has the CASE expression. i.e. SELECT sum( CASE WHEN column1='Y' THEN column2 ELSE 0 END) FROM ...

[sqlite] SELECT SUM( IF(

2004-11-13 Thread rainer
Hello, Does SQLite have kind of conditional select expression like: SELECT SUM( IF(column1='Y', column2, 0 ) FROM ... ? Rainer