Hi,
I would like to be able to run a query on my names and addresses
database, returning the following:
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
I've noticed that, on Mac OS X at least, I'm getting a lot of temporary
files filling up my in my /private/tmp directory as I use SQLite, and
they aren't being deleted even when I close the database. I've seen
comments in the archives for this mailing list that suggest that the
files should be
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
(Sorry if this comes through twice. I changed email addresses when I changed to the
new sqlite list and got things confused on my end. All is fixed now.)
Any chance of adding the standard List-Id header to the new mailing list? This header
is handy for filtering messages and some email
William Trenker wrote:
Any chance of adding the standard List-Id header to the new mailing list?
If I made the change correctly, this reply should have the List-Id header
line.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
* D. Richard Hipp ([EMAIL PROTECTED]) [031019 14:08]:
> William Trenker wrote:
> >
> >Any chance of adding the standard List-Id header to the new mailing list?
>
> If I made the change correctly, this reply should have the List-Id header
> line.
I'm getting the backspace character in that
I don't have Mac knowledge, but the automatic deletion of temp files is done on the
sqliteOsClose() function, at "os.c".
Just a clue...
Regards,
~Nuno Lucas
=== On 2003-10-19, Will Leshner wrote ===
>I've noticed that, on Mac OS X at least, I'm getting a lot of temporary
>files filling up my
Yes, I think that is what is supposed to happen, but it doesn't appear to be working. But I have made modifications to my os.c file, so maybe I screwed something up.
Nuno Lucas wrote:
I don't have Mac knowledge, but the automatic deletion of temp files is done on the
sqliteOsClose() function,
I have a table that looks like this..
#
#SQLite Admin Structure Dump for table quotes
#
create table quotes(id INTEGER PRIMARY KEY, author varchar(50), quote TEXT, category
varchar(20))
I am trying to auto increment the id field with this query
INSERT INTO quotes (id, author, quote, category)
This one time, at band camp, Kevin Waterson <[EMAIL PROTECTED]> wrote:
> OK, that sounds fine, but is it possible to determine the type of field so my script
> will be able to add the quotes if it is of type INTEGER?
I guess what I really need is something like MySQL's mysql_field_type()
Kind
This one time, at band camp, "Ian VanDerPoel" <[EMAIL PROTECTED]> wrote:
> You can find the info you want in the sqlite_master
> table. There is some doco on it at the sqlite.org the website. I am not sure if the
> info is held anywhere else but
> select * from sqlite_master where name =
Hi Kevin,
You could also query the table or view but don't return any rows. If you set the
option to get the column types in the resultset this should do what you want . AN
example of what I am trying to say would help :)
PRAGMA show_datatypes = ON;
select COl3 from tablename where 0 = 1
D. Richard Hipp wrote:
> William Trenker wrote:
> >
> > Any chance of adding the standard List-Id header to the new mailing list?
>
> If I made the change correctly, this reply should have the List-Id header line.
>
Thanks for the quick response.
Regards,
Bill
13 matches
Mail list logo