-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 2:23 PM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: Re: [sqlite] Solaris make test compilation error
Ken [EMAIL PROTECTED] wrote:
Solaris 5.8 (solars 8)
make test
-Original Message-
From: Ken [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 2:55 PM
To: sqlite
Subject: [sqlite] Solaris bus error
After addressing the -lrt sched yield on solaris.
make test resulted in:
async3-1.0... Ok
async3-1.1...make: *** [test] Bus Error
-Original Message-
From: P Kishor [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 3:35 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Using LIKE to check the first digits?
On 1/31/08, Gilles [EMAIL PROTECTED] wrote:
Hello
I'm no SQL guru, and need to look up
David Hautbois wrote:
Hi
I have an odd issue.
My function :
char * get_config_value (sqlite3 * db, char * config_name) {
[...]
configvalue = (char *) sqlite3_column_text(stmt, 0);
[...]
return
David Hautbois [mailto:[EMAIL PROTECTED] wrote:
I found the solution :
I replaced this line :
configvalue = (char *) sqlite3_column_text(stmt, 0);
by
configvalue = g_strdup((gchar *) sqlite3_column_text(stmt, 0));
and the configvalue type : gchar
Now it works !!
A newbie error...
-Original Message-
From: Nicolas Williams [mailto:[EMAIL PROTECTED]
Sent: Monday, January 28, 2008 10:35 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to specify regular expression in a query?
On Mon, Jan 28, 2008 at 06:22:08PM +0100, Ralf Junker wrote:
I believe that
DRH wrote:
Experiments using bash indicate that either ^ or ! is accepted
as the negation of a character set. Hence,
ls -d [^tu]*
ls -d [!tu]*
both return the same thing - a list of all files and directories
in the current directory whose names do not begin with t or u.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 2:22 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Query problem
[EMAIL PROTECTED] wrote:
You
can escape characters using [..]. To match a * anywhere in a string,
for
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 3:08 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Query problem
James Dennett wrote:
Square brackets don't escape thing that way: [[] is a character
class
containing only
-Original Message-
From: Ken [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 4:10 PM
To: sqlite
Subject: [sqlite] order by issue?
I'm not sure if this a bug or if working as intended:
the order by b,a seems to cause B to use asc.. Instead of the desc as
written in
(Top-posting and overquoting fixed.)
On Monday, January 21, 2008 1:57 PM, Mark Riehl wrote:
On Jan 21, 2008 4:48 PM, Igor Tandetnik [EMAIL PROTECTED] wrote:
Mark Riehl [EMAIL PROTECTED]
wrote:
For some reason I haven't been able to track down, SQLite is
creating
a journal file after the
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of
Philip Nick
Sent: Thursday, January 17, 2008 1:48 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite3 performace
Greetings,
Currently I am using sqlite3 in a multi-process/multi-threaded
-Original Message-
From: Rich Shepard [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 10, 2008 4:10 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Syntax for Multi-table Join
I cannot find the specific syntax on the web site's SELECT page nor
in
Owens' book. It should not
A tired James wrote:
select foo as bah from baz, not select foo from baz as bar, I think.
-- James
Evidently I don't think too well this afternoon; please disregard
this...
-- James
-
To unsubscribe, send email to
-Original Message-
From: Zbigniew Baniewski [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 09, 2008 10:57 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] always-trim - feature suggestion
On Wed, Jan 09, 2008 at 07:15:52PM +0100, Kees Nuyt wrote:
It's a culture thing.
-Original Message-
From: Jason Tudor [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 4:06 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Encryption?
Is there any encryption functionality built into SQLite?
Not in the public domain version.
Also, can I use
[EMAIL PROTECTED] wrote:
I don't know if the following might be a problem with the new release,
or just something odd on my system.
In sqlite 3.3.12, I try to create an empty table copying the schema of
an existing table by using a command such as the following:
CREATE TABLE
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19, 2007 7:36 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Memory Usage
Not only applicable to real time systems. If you want a program to
run
with stability over a long time the first
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19, 2007 12:14 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Memory Usage
Dynamic allocation is not the problem, it is malloc and free. there
is
a difference between being certain and
Dennis Cote wrote:
Dr Gerard Hammond wrote:
The first few words sound incorrect to me.
Shouldn't it be.
SQLite is an in-process
and even then I don't know what 'in-process' actually means.
I agree with this completely.
I can't say I have ever heard the term in-process
Joe Wilson wrote:
No need to say it's stable or recommended - it's assumed. Otherwise it
wouldn't appear on the home page.
I disagree. 3.5.0 appeared, even though discussion was that it was
relatively experimental. It's *good* to be explicit about this.
-- James
drh wrote:
There is a new look up on the demo site at
http://sqlite.hwaci.com/
It does look much prettier than the current live site.
I note the common affect/effect typo in the sentence
There are no known issues effecting database integrity
or correctness., where this should be
Joe Wilson wrote:
--- James Dennett [EMAIL PROTECTED] wrote:
Joe Wilson wrote:
No need to say it's stable or recommended - it's assumed.
Otherwise it
wouldn't appear on the home page.
I disagree. 3.5.0 appeared, even though discussion was that it was
relatively experimental
Joe Wilson wrote:
--- Samuel R. Neff [EMAIL PROTECTED] wrote:
I hope this doesn't offend, but perhaps the best solution is to
outsource
the website to someone or a company that specializes in websites and
design
(with your stated simplicity goals in mind of course). We certainly
-Original Message-
From: Bernie Cosell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 31, 2007 12:20 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] DB managers that do searches?
On 31 Oct 2007 at 11:37, James Dennett wrote:
Bernie Cosell wrote:
I guess you've
Bernie Cosell wrote:
On 30 Oct 2007 at 14:05, James Dennett wrote:
-Original Message-
From: Bernie Cosell [mailto:[EMAIL PROTECTED]
I'm trying to correct several little problems in a DB I have and
I've
now tried three [maybe four] freeware DB managers and not one
Roger Binns wrote:
[EMAIL PROTECTED] wrote:
It is also an error to
invoke sqlite3_initialize() more than once.
That is a pretty nasty restriction to have. If you link multiple
other
libraries into your program, each of which also uses SQLite then you'd
somehow have to arrange that only
[EMAIL PROTECTED] wrote:
Hello Joe,
Tuesday, October 30, 2007, 2:08:55 PM, you wrote:
JW --- Teg [EMAIL PROTECTED] wrote:
You'll just end up exchanging an are you initialized flag for a
have
you called the initialization routine flag. I don't see it
changing
the size or complexity.
-Original Message-
From: Bernie Cosell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 1:58 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] DB managers that do searches?
I'm trying to correct several little problems in a DB I have and I've
now tried three [maybe four]
-Original Message-
From: Ken [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 24, 2007 1:22 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Re: Some Questions Regarding Access To a SQLite
Database By More Than One Process
If you are using seperate processes then a mutex
-Original Message-
From: Zavier Sheran [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 26, 2007 8:52 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] 3.4.2 compile error
../sqlite/src/tclsqlite.c: At top level:
../sqlite/src/tclsqlite.c:2430: error: syntax error before int
-Original Message-
From: Yuriy Martsynovskyy [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 13, 2007 11:45 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] passing C variable in query
Hi Nishit,
can anyone tell me the syntax of passing a C variable in a query.
i have
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 30, 2007 6:11 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] _sqlite3StrCmp not found
Bharath Booshan L [EMAIL PROTECTED] wrote:
Hello All,
I am using sqlite 3.1.3 version which
-Original Message-
From: Chase [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 12:39 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] how do i declare and use variables in sqlite?
select 542 as x;
that part works, but then when i try to access it, i get no column
-Original Message-
From: Rahul Banerjee [mailto:[EMAIL PROTECTED]
Sent: Friday, July 27, 2007 1:34 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Extremely new to SQLite
Hi,
I'm trying to integrate SQLite into a library management system coded
in
C++. I'm extremely new to
-Original Message-
From: Meftah Tayeb [mailto:[EMAIL PROTECTED]
Sent: Monday, July 23, 2007 3:33 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Begining SQLite
Hello
Thank you for this SQLite ADO .Net Data provider
is working very correctly
but ho to Create my SQLite
-Original Message-
From: Scott Derrick [mailto:[EMAIL PROTECTED]
Sent: Friday, July 20, 2007 8:54 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] quickest way to duplicate table data?
I am using sqlite in an embedded application. The data store table
will be in its own file.
-Original Message-
From: Ahmed Sulaiman [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 19, 2007 8:46 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] SQLite on Mac
Hi all,
Does SQLite work on Mac, and if yes, is there any Mac enabled version
that I could download?
There's no
-Original Message-
From: Ryan M. Lederman [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 3:34 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] CREATE TABLE
I'm using sqlite3, built with Microsoft's CL compiler, 8.0 on a
Windows Mobile platform.
I have a problem wherein I
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 01, 2007 11:11 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite testing with Boundschecker
Damian Slee [EMAIL PROTECTED] wrote:
I have done some testing with 3.2 and now 3.4,
-Original Message-
From: Jiri Hajek [mailto:[EMAIL PROTECTED]
Sent: Monday, June 25, 2007 8:14 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unicode collation
So the choices seem to be:
(1) Databases that corrupt if you move across platforms.
(2) A 10MB database
-Original Message-
From: Andrew Finkenstadt [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 21, 2007 2:56 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] transaction best practices, post-committal headaches
In my sqlite framework I have the concept of a transaction, which uses
a
-Original Message-
From: Smith1, Robert E [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 1:12 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] --prefix
Hi,
I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I
cannot install to /usr/local. I start
Message-
From: Smith1, Robert E [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 1:48 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] --prefix
Why isn't it trying to install to /ptmp/usr/local since that is the
value I gave --prefix??
-Original Message-
From: James
Hello,
I have a couple of questions about the specification of
sqlite3_get_table/sqlite3_free_table. I'm looking at the online docs at
http://www.sqlite.org/capi3ref.html#sqlite3_get_table
The questions are about when sqlite3_free_table() should be freed.
Specifically:
1) Is it
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 15, 2007 3:35 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] runtime errors in DEBUG with byte overflow in
RC4-
based random (3.3.15)
Andrew Finkenstadt [EMAIL PROTECTED] wrote:
Any
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 12, 2007 9:41 PM
To: SQLite
Subject: [sqlite] Re: Table with 2 primary keys... what's the problem?
Darren Duncan [EMAIL PROTECTED] wrote:
At 11:37 PM +0100 5/12/07, Paulo J. Matos wrote:
nshaw writes:
Help!
I've done everything I can think of to pass arguments to SQLite and
nothing
is working. If anyone has information on how to do it, I'd appreciate
it.
Here's a code segment:
[edited to remove SQL3-related material]
int main (int argc, char **argv)
{
char
It's worth briefly, for the record, mentioning that the code using += is
what often causes SQL injection security issues, and that prepared
statements using parameters are the way to avoid that.
-- James
-Original Message-
From: nshaw [mailto:[EMAIL PROTECTED]
Sent: Monday, April 09,
From: Joel Cochran [mailto:[EMAIL PROTECTED]
Hi Puneet,
I probably shouldn't have said that they 'ignore' the blanks, but they
are
capable of treating them as white space for text matching purposes. I
can't
speak for Oracle, but I'm pretty sure MySQL and SqlServer (and I know
for
sure
From what I know, it seems plausible that a filesystem snapshot should
provide a robust backup for an SQLite3 database; most modern OS's have
some way to atomically grab an image of a filesystem (LVM on Linux, VSS
on Windows, fssnap on Solaris, etc.). I'm no SQLite expert though, so
I'd suggest
-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 5:04 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Fix for sqlite3.h in version 3.3.10
--- James Dennett [EMAIL PROTECTED] wrote:
Joe Wilson wrote:
The proposed expression
-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: Monday, January 22, 2007 5:20 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Fix for sqlite3.h in version 3.3.10
--- James Dennett [EMAIL PROTECTED] wrote:
-Original Message-
From: Joe Wilson
53 matches
Mail list logo