[sqlite] trying to locate older version of SQLite

Hi, I have a website on a shared hosting which has PHP 5 installed on it. I ran a test program and created a SQLite database from it. When I opened the database file, it has as its first line "This file contains an SQLite 2.1 database". I am trying to download the 2.1 version of SQLite from

Re: [sqlite] trying to locate older version of SQLite

Thank you Dennis. Martin from this mailing list sent me an email detailing the same thing. This ticket is closed :) Shibu Narayanan Consultant, PrimeSourcing Division, Investment Banking Group Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 e-mail: [EMAIL PROTECTED] The answer is 42.

Re: [sqlite] Query to Find number of distinct records

Try select count(DISTINCT Name) nameCount from TableA Shibu Narayanan Consultant, PrimeSourcing Division, Investment Banking Group Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 e-mail: [EMAIL PROTECTED] The answer is 42. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[sqlite] export to SQL insert statements with column names

Hi, Is there a way to export/dump SQLite data into INSERT statements which also have column names? As of now, a sqlite dump looks like this INSERT INTO "ric_tb_language" VALUES('ENG','English'); INSERT INTO "ric_tb_language" VALUES('SPN','Spanish'); INSERT INTO "ric_tb_language"

Re: [sqlite] SQLite file security

I think the question by the original poster was about data security and not file security. He probably does not mind if the file is copied, but the data should be decipherable only by his application. -Shibu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

There should be no single quotes around question marks -Shibu -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor Sent: Monday, February 02, 2009 6:14 PM To: General Discussion of SQLite Database Subject: Re: [sqlite]