RE: [sqlite] new sqlite user - need help

2004-11-22 Thread ANANTHA NARAYANAN /NBP/INFOTECH/CHE
HI, YOU HAVE TO PASS THE FILE NAME THAT STORES THE DATABASE AS ARGUMENT TO EXECUTABLE Regards Anantha Narayanan.T.L ICICI Infotech Ltd., Alwarpet, Chennai. Ph: 09840372664 [EMAIL PROTECTED] [EMAIL PROTECTED], rediffmail.com http://www.geocities.com/tlananthu CELEBRATE FOR A REASON

[sqlite] new sqlite user - need help

2004-11-22 Thread ajit mote
  hello friend's, i am new to sqlite... read documenatation sqlite.org... but not able to understand how to store the created tables permnantly and access them next time when u again started the sqlite server. hoping u Ustand my problem... ajit.

Re: [sqlite] unable to open database

2004-11-22 Thread Steven Lloyd
Clark was exactly right. It was because the db folder only had read permissions. Once I changed the db folder permissions, all worked great. Thank you so much! Steve - Original Message - From: "Clark Christensen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 22,

Re: [sqlite] unable to open database

2004-11-22 Thread Clark Christensen
--- Steven Lloyd <[EMAIL PROTECTED]> wrote: > I have been using SQLite successfully for quite some > time. I recently installed it on a friends server in > order to use it there. > > While I am able to access the db file just fine when I > run my perl script from the shell prompt I get the >

Re: [sqlite] unable to open database

2004-11-22 Thread Clay Dowling
Steven Lloyd said: > I thought of that first but still no luck. I am using the full path to > the > file and still get the same error. > > Any other ideas? You might want to check if that path is really the full path. A lot of servers are set up in a chroot environment, which changes where the

Re: [sqlite] unable to open database

2004-11-22 Thread Steven Lloyd
I thought of that first but still no luck. I am using the full path to the file and still get the same error. Any other ideas? Steve - Original Message - From: "Clay Dowling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 21, 2004 7:38 AM Subject: Re: [sqlite]

RE: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-22 Thread mike cariotoglou
> In SQLite version 3.0, when a schema change occurs, SQLite > automatically goes back to step 1, rereads the schema, and > tries again. So you should never get an SQLITE_SCHEMA error > in version 3.0. Back in version 2.8, you could get an > SQLITE_SCHEMA error in some circumstances. When

[sqlite] unable to open database

2004-11-22 Thread Steven Lloyd
I have been using SQLite successfully for quite some time. I recently installed it on a friends server in order to use it there. While I am able to access the db file just fine when I run my perl script from the shell prompt I get the following error when trying to run it from a cgi-bin.

[sqlite] Attaching multiple in-memory databases

2004-11-22 Thread Demitri Muna
Hi, Is it possible to ATTACH more than one in-memory database to a given database? If so, how would you refer to the 2nd (or higher) :memory: db? Cheers, Demitri

Re: [sqlite] collation sequence not used?

2004-11-22 Thread Tiago Dionizio
On Mon, 22 Nov 2004 08:00:08 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > Tiago Dionizio wrote: > > > > The collation sequence "binary" was not being used when i declared the > > column a without a type, but when i included the *text* type the > > collation sequence was used to sort the

Re: [sqlite] collation sequence not used?

2004-11-22 Thread D. Richard Hipp
Tiago Dionizio wrote: The collation sequence "binary" was not being used when i declared the column a without a type, but when i included the *text* type the collation sequence was used to sort the result. Is this the expected behaviour? The collating sequence is only use to compare objects of