Re: [sqlite] Unrecognized token error

On 3/20/06, Tito Ciuro <[EMAIL PROTECTED]> wrote: > If I escape single quotes (that is, from "'" to "''"), then > everything is fine. I usually do that when I want to query for a > value that contains a quote (i.e. O'Rourke). > > However, why do I have to manipulate the string value to be stored?

Re: [sqlite] Unrecognized token error

Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? If I escape single quotes (that is, from "'"

[sqlite] [LONG]Re: [sqlite] Unrecognized token error

Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? Here's the string (it's a preferences file):

Re: [sqlite] Unrecognized token error

Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string?

[sqlite] Unrecognized token error

Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito

[sqlite] DBD::SQLite

Hi, I'm using DBD::SQlite with Perl. How do I know that the execution of a statement failed because the database was locked? Should I examine the $DBI::errstr? Does DBI set an error code or something? Thanks, Raj

[sqlite] "Database is locked" error in PHP via PDO despite setting timeout

Hi all, I'm using Sqlite3 from PHP via PDO. My application was working fine as long as there was only one process accessing the database, then I ran two instances at once. Now one of the processes is getting "Error message: SQLSTATE[HY000]: General error: 5 database is locked" when trying

Re: [sqlite] multiple queries, one thread

On Sun, Mar 19, 2006 at 06:40:51AM -0500, [EMAIL PROTECTED] wrote: > Tim Larson <[EMAIL PROTECTED]> wrote: > > I did not find anything that lets us do work specifically > > during the time spans when sqlite is waiting on the disk drive > > Most of the disk drive wait time is spent inside the

Re: [sqlite] Missing files?

"Patrick Bangert" <[EMAIL PROTECTED]> wrote: > Hello SQLite Community, > > I found the package and want to test it, it seems very cool indeed from what > I hear. So I downloaded the tar-ball of the complete source for version > 3.3.4 and tried to compile it. > > This tar-ball is missing the

Re: [sqlite] File locking additions

"mohsen ahmadian" <[EMAIL PROTECTED]> wrote: > hello All > the sqlite cant lock db for security data base if i have a DB and must be > close from Other program and cant Open this DB ,this DBMS not protect DB by > User name and password > i think a sqlite must be have > Mohsen Ahmadian

[sqlite] Re: help in triggers(calling functions)

"Chethana, Rao \(IE10\)" <[EMAIL PROTECTED]> wrote: > Hello! > > > > How do I call functions(user defined) or stored procedures from > triggers in sqlite? > > For example, how do I do this in sqlite? > > CREATE TRIGGER TrgIns_PTable AFTER > INSERT ON

Re: [sqlite] multiple queries, one thread

Tim Larson <[EMAIL PROTECTED]> wrote: > I did not find anything that lets us do work specifically > during the time spans when sqlite is waiting on the disk drive Most of the disk drive wait time is spent inside the fsync() or FlushFileBuffers() system calls. There is no way to have the same

Re: [sqlite] Missing files?

On 3/19/06, Patrick Bangert <[EMAIL PROTECTED]> wrote: > This tar-ball is missing the following files: sqlite3.h, parse.h and > opcodes.h Those files should be auto generated during build process on UNIX based system. If you're on windows you can either download preprocessed source archive that

[sqlite] Missing files?

Hello SQLite Community, I found the package and want to test it, it seems very cool indeed from what I hear. So I downloaded the tar-ball of the complete source for version 3.3.4 and tried to compile it. This tar-ball is missing the following files: sqlite3.h, parse.h and opcodes.h The "pure C"

Re: [sqlite] File locking additions

You have discovered sqLITE. For the features you need, go to an sqlHEAVY such as Oracle, DB2 or PostgreSQL. mohsen ahmadian wrote: hello All the sqlite cant lock db for security data base if i have a DB and must be close from Other program and cant Open this DB ,this DBMS not protect DB by

Re: [sqlite] File locking additions

hello All the sqlite cant lock db for security data base if i have a DB and must be close from Other program and cant Open this DB ,this DBMS not protect DB by User name and password i think a sqlite must be have Mohsen Ahmadian