Re: [sqlite] client/server

Eugene Wee wrote: Not at all (if I correctly understand what you're trying to say). For example, there exists a SQLite extension in PHP (which comes bundled by default in PHP5, but currently does not support SQLite3). pecl, PDO extensions allows PHP to use SQLITE Version 3.X too :-) http://it

Re: [sqlite] Basic Text Bind Question

Thanks Dan! Works like a charm now. On 6/7/05, Kiel W. <[EMAIL PROTECTED]> wrote: > > Ok, thanks for the responses. > > --Ulrik > >I think it stops right here, because you've got fname twice. That > >induces an error. > > You are correct, I'm not sure when I introduced that error, but thanks f

Re: [sqlite] Basic Text Bind Question

Ok, thanks for the responses. --Ulrik >I think it stops right here, because you've got fname twice. That >induces an error. You are correct, I'm not sure when I introduced that error, but thanks for pointing it out. Its not in my running code so it was either C/P error or something else dumb.

Re: [sqlite] Basic Text Bind Question

> size = sprintf( buf, "SELECT * FROM People WHERE lname = '?'" ); ^^^ > rc = sqlite3_prepare( database, buf, -1, &statement, 0 ); > sqlite3_bind_text(statement, 1, "Fullman", 7, SQLITE_STATIC ); > rc = sqlite3_step(statement); As other

Re: [sqlite] Basic Text Bind Question

Kiel W. wrote: size = sprintf( buf, "CREATE TABLE People( fname varchar(25), fname varchar(25) );" ); size = sprintf( buf, "INSERT INTO People VALUES( 'John', 'Fullman' );" ); size = sprintf( buf, "INSERT INTO People VALUES( 'Sally', 'Fullman' );" ); size = sprintf( buf, "INSERT INTO People V

Re: [sqlite] Basic Text Bind Question

On Tue, 2005-06-07 at 16:53 -0700, Kiel W. wrote: > size = sprintf( buf, "CREATE TABLE People( fname varchar(25), fname > varchar(25) );" ); > rc = sqlite3_prepare( database, buf, -1, &statement, 0 ); > sqlite3_prepare only processes the first statement in your list of SQL statements. It then

Re: [sqlite] Basic Text Bind Question

Hi, Kiel W. wrote: Could someone point out what I missing or not understanding on this? I'm trying to do a simple text bind to search for people with the last name "Fullman". However my return code (rc) from sqlite3_step() is the same as SQLITE_DONE. I'm assuming this means it doesn't find an

[sqlite] Re: Basic Text Bind Question

Added note... rc = sqlite3_prepare( database, buf, -1, &statement, 0 ); > I also tried this with rc = sqlite3_prepare( database, buf, strlen(buf), &statement, 0); -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

[sqlite] Basic Text Bind Question

Could someone point out what I missing or not understanding on this? I'm trying to do a simple text bind to search for people with the last name "Fullman". However my return code (rc) from sqlite3_step() is the same as SQLITE_DONE. I'm assuming this means it doesn't find anything. Also, how do

Re: [sqlite] client/server

On Tue, Jun 07, 2005 at 11:52:30AM -0300, Mart?n Schamis wrote: > Hi, Eugene and everybody. > > The problem I have is this, I?m implementing a web aplication that will > require up to 300 users writing at Then why are you even looking at SQLite? IMNSHO, unless you have some compelling reasons ot

Re: [sqlite] client/server

Martín Schamis said: > Hello, I´ve seen inthe sqllite page that,"If you have many client > programs accessing a common database over a network, you should consider > using a client/server database engine instead of SQLite" > > 1 .- This means that I can´t use a php on the web and the users accedin

Re: [sqlite] client/server

Martín Schamis a écrit : > Hi, Eugene and everybody. > > The problem I have is this, I´m implementing a web aplication that will > require up to 300 users writing at > The same time to the database file simultaneously. you mean 300 users connected simultaaneously, writing occasionaly to the data

RE: [sqlite] client/server

Hi, Eugene and everybody. The problem I have is this, I´m implementing a web aplication that will require up to 300 users writing at The same time to the database file simultaneously. The question is, if sqllite will supported ? Thanks for your help. Martín -Mensaje original- De: Eugene

Re: [sqlite] client/server

Hi, Martín Schamis wrote: 1 .- This means that I can´t use a php on the web and the users acceding to that page can`t modify the base ? Not at all (if I correctly understand what you're trying to say). For example, there exists a SQLite extension in PHP (which comes bundled by default in PHP5,

[sqlite] client/server

Hello, I´ve seen inthe sqllite page that,"If you have many client programs accessing a common database over a network, you should consider using a client/server database engine instead of SQLite" 1 .- This means that I can´t use a php on the web and the users acceding to that page can`t modify th

Re: [sqlite] Tiger: Error: file is encrypted or is not a database

On Jun 6, 2005, at 10:36 AM, Helmut Tschemernjak wrote: Hello, I try to look into the sqlite database in Mac OS X Tiger at: /.Spotlight-V100/ I cannot dump any data or schema and the file magic is not containing sqlite. The data is not encrypted. It looks like the file is incompatible wi

[sqlite] Integrity Check Pragma

Hi, Sorry to ask a stupid question, but how exactly do I get the return value from this pragma? Thanks in advance, Steve

Re: [sqlite] Only 128 inserts with NULL value for INTEGER PRIMARY KEY

Tom Deblauwe wrote: Tom Deblauwe wrote: D. Richard Hipp wrote: What happens when you try to insert the 129th value? I tried now the following: I get the same results in the windows commandline tool: MAX(iID) gives met 127 and COUNT(iID) gives me 29... Hereby is the database attached!