Re: [sqlite] C++ Samples

centipede moto wrote: > I am new to c++ (I know php, c# etc), and thanks to this list I've gotten > sqlite3 to open a db connection without failing to find its libraries. But > now that I have an open db connection I am lost, I can work my way through > the c++ itself but I'm having a hard time

[sqlite] Execute import from php

I'd like to import a file into a table from php. Is there anyway to execute the .import from php. I am using the pdo interface. Patty ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] busy_timeout() doesn't work

Hello all, I have found that busy_timeout doesn work in this case: ---%< #include #include int check_error (int rc, char *zErrMsg) { if( rc!=SQLITE_OK ){ fprintf(stderr, "SQL error: %s\n", zErrMsg);

Re: [sqlite] Subselects negating benefit of index?

>> So it seems that the subselect is preventing the ordering index from >> being used. What's interesting is that if I select the ids in a >> different sql statement, concatenate them together in a big list of >> numbers, and supply that in the extra statement,  the ordering index >> is still not

Re: [sqlite] sqlite3_step() returning SQLITE_OK

On Apr 3, 2009, at 9:03 PM, Radcon Entec wrote: > According to the documentation, assuming I'm reading it correctly, > and assuming there are no locks on the database, and assuming the > query sent to sqlite3_prepare_v2() was valid, sqlite3_step() should > return either SQLITE_ROW or