[sqlite] Multiple Writers and Database is Locked Problems

2009-07-17 Thread Cole
/Cole ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] View bindings for a statement

2008-04-25 Thread Cole Tuininga
. Thanks. -- Cole Tuininga http://www.tuininga.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] View bindings for a statement

2008-04-25 Thread Cole Tuininga
On Fri, Apr 25, 2008 at 4:13 PM, P Kishor [EMAIL PROTECTED] wrote: On 4/25/08, Cole Tuininga [EMAIL PROTECTED] wrote: Here is what I do in the Perl world for this problem -- # Create a string with the bound vars to write to a log $sql = SELECT col FROM table WHERE col = 'bound value here

[sqlite] selecting check constraints

2007-08-06 Thread Chris Cole
Hello, I was wondering what would be an example sql command that would allow you to return the check constraints on a specific column in a database? Thanks, --Chris - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] selecting check constraints

2007-08-06 Thread Chris Cole
Chris Cole wrote: Hello, I was wondering what would be an example sql command that would allow you to return the check constraints on a specific column in a database? Thanks, --Chris I've found that the .schema {table} command will list the checks being performed but I can't find a way

Re: [sqlite] uSQLiteServer Source code available

2005-11-12 Thread Alfredo Cole
El Sábado, 12 de Noviembre de 2005 18:24, [EMAIL PROTECTED] escribió: I have reorganized the archive and got all the source into it this time. http://users.iol.it/irwin It's an interesting concept. I downloaded it and will try it. Thank you, Roger. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] Book recommendation

2005-11-10 Thread Alfredo Cole
Amazon, that I'm having problems with. From Adobe's web site: Does the Acrobat eBook Reader run on Linux? We do not currently plan to develop a version for the Linux platform, but we may in the future if that platform becomes more widely used. Regards. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] Book recommendation

2005-11-09 Thread Alfredo Cole
the database bundled with PHP5? I'm looking primarily to use the API rather than the command line tool. Thanks Joe It's a good book. Get the paperback edition, unless you are using Windows and want to save money. There is no Acrobat reader for ebooks on Linux. Regards. -- Alfredo J. Cole

[sqlite] Number of rows in a query result

2005-10-27 Thread Alfredo Cole
Hi: In order to update a progress bar, I need to know the total number of rows returned by a query, similar to MySQL's mysql_num_rows. Is there a function like that in the C API? I may have overlooked it, but have not found it so far. Thank you. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] Number of rows in a query result

2005-10-27 Thread Alfredo Cole
thought there might be a method to get the number of rows directly. I will try the get_table funtion. Thank you. -- Alfredo J. Cole Grupo ACyC

[sqlite] Sample code

2005-10-26 Thread Alfredo Cole
Hi: I have searched, but have not found samples of actual uses of sqlite_compile, sqlite_step and sqlite_finalize. Could anybody point the way to where I can find samples with source code to use these functions? Thank you. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] Sample code

2005-10-26 Thread Alfredo Cole
El Miércoles, 26 de Octubre de 2005 08:53, escribió: On 10/26/05, Alfredo Cole [EMAIL PROTECTED] wrote: I have searched, but have not found samples of actual uses of sqlite_compile, sqlite_step and sqlite_finalize. Could anybody point the way to where I can find samples with source code

Re: [sqlite] Sample code

2005-10-26 Thread Alfredo Cole
El Miércoles, 26 de Octubre de 2005 16:17, John Stanton escribió: Alfredo, this simple example may may help (...) This is good! Thank you and regards. -- Alfredo J. Cole Grupo ACyC

[sqlite] C++ wrapper for SQLite C API

2005-10-25 Thread Alfredo Cole
appreciate your suggestions. Thank you. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] C++ wrapper for SQLite C API

2005-10-25 Thread Alfredo Cole
of SQLite are wrapped, but the code is easy to understand and can easily be expanded. Martin Thank you Martin. I will take a look at it. Regards. -- Alfredo J. Cole Grupo ACyC

[sqlite] Concat?

2005-10-25 Thread Alfredo Cole
Hi: What is the equivalent of: select concat(col1,col2,col3) from table in SQlite? How can I achieve the same results? Thank you. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] Concat?

2005-10-25 Thread Alfredo Cole
El Martes, 25 de Octubre de 2005 17:08, Puneet Kishor escribió: On Oct 25, 2005, at 6:08 PM, Alfredo Cole wrote: What is the equivalent of: select concat(col1,col2,col3) from table in SQlite? SELECT col1 || col2 || col3 FROM table should do, no? -- Puneet Kishor