Re: [sqlite] Date problem

On Fri, 2 Jan 2004, KL Chin wrote: > Can anyone help on this problem, why with the query below > > DELETE FROM ABC WHERE datein < '12/29/03'; > > All my record date from '1/1/04' to '1/6/04' were delete. > Where datein was date type. SQLite is typeless, see:

Re: [sqlite] Select from Select

On Sun, 19 Oct 2003, Brian Pugh wrote: > How many records in a certain Postcode area (Zip code to our > US friends!); > How many of those have telephones (ie, the field is blank if > they don't have a telephone); > How many with telephones can be canvassed (I have a field called > Canvass that