> -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
> -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: ***
> -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)
>
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
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
> -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
> -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
>
> -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&quo
> -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
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"
(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
> -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
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
> -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
> -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
> -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
> -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
> -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
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
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
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.
> >
> >
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
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
> -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:
>
> > B
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
> -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
[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
> >>
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
> -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
> -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
> -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
> -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
Stephen Sutherland [mailto:[EMAIL PROTECTED] wrote:
>
> Thanks this is great information on sqlite's prepared statements.
>
> I think I have just one more question on this subject.
>
> I need to execute a SQL statement like this:
> "SELECT * FROM tbl WHERE BookID IN ( :arrayNumbers) ;"
> -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
> -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
> -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
> -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
> -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?
> -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
> -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
> -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
> -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
> -Original Message-
> From: James Dennett [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 1:44 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] --prefix
>
> > -Original Message-
> > From: Smith1, Robert E [mailto:[EMAIL PROT
> -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
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]>
> -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
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
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)
> {
>
> 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
>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]>
> -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:
> > > -
54 matches
Mail list logo