On 13 April 2011 15:33, Simon Slavin wrote:
>
> On 13 Apr 2011, at 12:14pm, James Green wrote:
>
>> sync=full does not work well for our app (no transactions). Far too slow.
>
> If you're not syncing, then section 3.2 of the page Richard probably
> indicates w
ansactions). Far too slow.
James
On 13 April 2011 11:47, Richard Hipp wrote:
> On Tue, Apr 12, 2011 at 5:15 AM, James Green wrote:
>
>> My question is does anyone have pointers
>> to help us isolate the problems we are seeing.
>>
>
> http://www.sqlite.org/howtocorru
department reports that the frequency of sites becoming
corrupt is in the region of 1-2 per week and it's been happening for
several weeks (since we picked up on the pattern). We're looking at
roughly 30 instances so far.
Thoughts and recommendat
never used
Page 92499 is never used
Page 92508 is never used
Page 92511 is never used
Page 92512 is never used
Page 92513 is never used
Error: database disk image is malformed
James
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
On 12 April 2011 11:27, Simon Slavin wrote:
>
> On 12 Apr 2011, at 10:15am, James Green wrote:
[ ... ]
> Was it built threadsafe ? See
>
> http://www.sqlite.org/threadsafe.html
Apparently so - the odbc drivers use -DTHREADSAFE=1 when building sqlite.
[ ... ]
> You don't
y question is does anyone have pointers
to help us isolate the problems we are seeing. We can obviously
provide further detail to your questions.
Many thanks,
James
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailma
Richard,
On Jan 21, 2011, at 5:41 PM, Richard Hipp wrote:
> On Fri, Jan 21, 2011 at 8:27 PM, James Berry wrote:
>
>> (1) Is there any API I can/should use to predictably get the name of
>> the journal file so that I can delete it, without "knowing" what is sho
bogus journal in this scenario and discard it?
(3) Should there be a flag to open_v2, or something, that tells it to
discard any extant journal?
Thanks,
James
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cg
On Jan 19, 2011, at 10:03 AM, Richard Hipp wrote:
> On Wed, Jan 19, 2011 at 12:35 PM, James Berry wrote:
>
>> I'm trying to understand whether there's any problem with committing a
>> transaction while in the process of stepping over results.
>
> The ability
On Jan 19, 2011, at 9:43 AM, Igor Tandetnik wrote:
> On 1/19/2011 12:35 PM, James Berry wrote:
>> I'm trying to understand whether there's any problem with committing a
>> transaction while in the process of stepping over results.
>
> I believe COMMIT would fai
formed on every iteration).
The codes seems to be working for me, but I want to make sure it's not working
in the realm of undefined operation.
James
BEGIN DEFERRED TRANSACTION
SELECT * FROM a
sqlite3_step over select results
{
COMMIT
BEGIN DEFERRED TRANSACTION
INS
ed image when there is no featured
image found.
James
On Wed, Nov 10, 2010 at 4:24 PM, James wrote:
> Thanks Jim,
>
> The position is what I wanted to use to control the display order of
> the images. So yes, which should be first, second, third. Items can
> have more than one imag
Thanks Igor, that seems to work. It's extremely slow with my real
data though. I'll have to look into that. Also, to actually filter
the products, I would have to add additional joins outside that
sub-select correct?
On Wed, Nov 10, 2010 at 4:26 PM, Igor Tandetnik wrote:
>
ould make it work where I just specify an image as
"featured".
James
On Wed, Nov 10, 2010 at 4:03 PM, Jim Morris wrote:
> If you would explain why/how the position value is significant that
> might help.
>
> I fixed your pseudo SQL to run in SQLite Manager and I don't u
This will only display products which have items with images. I think
I'm going to sit back and see if there's a simpler way to achieve what
I'm trying to do. Maybe I'm going about this the wrong way, or I need
to make some compromises.
Thanks
On Wed, Nov 10, 2010 at 3:01 PM, Igor Tandetnik wr
Sorry, I probably should've been clearer. I do have the data in place
to filter by color. The problem is I can't get the image.filenames
returned in the desired order. Even if I wanted to use group_concat,
I still would want them in a particular order (based on
images.position).
On Wed, Nov 10,
Shirt | sqlt-white.jpg
SQLite Long Sleeved Shirt | sqll-white.jpg
The reason why I'm doing this is, it allows me to show only photos for
the items that match the filter. So if you searched for "SQLT-WHT",
it would show the "sqlt-white.jpg" image. I'm not really workin
I've been fighting with this for a couple days now. I've been
searching like mad, and thought I found solutions, but nothing seems
to work. I think I may have reached the limit of my understanding :)
This is just a simplified example of what I'm going after:
SELECT products.id, products.name,
eople were discussing writing just
such a layer, thought there might be something reusable :-)
I will work on bringing the customer into the 20th century instead.
Thanks!
- James
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org]
could be reasonably easy to turn
one db file into, say, a series of four each with a maximum size of 2GB, and
decide which fd to use based on the offset requested. Plus enough logic to
keep pages in the same partition.
Thanks,
- James
> -Original Message-
> From: sqlite-user
Hi Michael,
I'm trying to support a user running on an NFSv2 file server, which is
limited to a maximum file size of 2GB.
Thanks,
- James
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Black, Micha
ing a DISKIO
feature that I'm frankly not familiar with.
Has anyone come up with a solution that they would be willing to share? I am
in a time crunch here and anything that would save me some time reaching a
solution would be *much* appreciated.
Thanks!
:2:in `require': no such file to load -- mkmf (LoadError)
from extconf.rb:2:in `'
Any thoughts?
@james
--
@@@@
@ james sheldon
@ http://www.jamessheldon.com
@ voyager...@gmail.com
___
sqlite-use
orter2 algorithm for
fts4; I'm not sure how the two compare in terms of performance.
Thanks again,
James
On Feb 24, 2010, at 7:05 AM, D. Richard Hipp wrote:
> We got the Porter stemmer code directly from Martin Porter.
>
> I'm sorry it does not work like you want it t
bug report will just be
forgotten others, as well as by me.
How does this bug move from a message on a list to a ticket (and ultimately a
patch, we hope) in the system?
James
On Feb 22, 2010, at 2:51 PM, James Berry wrote:
> I'm writing to report a bug in the porter-stemmer algorith
I'm writing to report a bug in the porter-stemmer algorithm supplied as part of
the FTS3 implementation.
The stemmer has an inverted logic error that prevents it from properly stemming
words of the following form:
dry -> dri
cry -> cri
This means, for instance, that the followi
rning: assignment makes pointer from integer without
a cast
make: *** [shell.o] Error 1
I know next to nothing about installations like this. What should I do?
James C.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cg
I am writing an open source program.
I am having trouble getting any results using this query. This returns none
select * from signs where lon>-121 and lon<-119;
onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID
+ " INTEGER PRIMARY KEY AUTOI
c).
In our use so far, these small changes have meant that we now normalize away
all of the important utf-8 characters in our input text, which gives us 100%
searchability of significant input tokens.
The patch (to the 3.6.22 amalgamation) is attached.
James
_
d expect all the
DB pages to be in memory ... but perhaps I'm wrong about that)
- in the slow phase, I'm inside a single transaction; the sequence of
operations is the problematic select, followed by an insert; repeated
several thousand times.
Hopefully that'
SQL error: column c is not unique
However, if I run this same insert via a prepared stmt in C code,
sqlite3_errmsg() returns only "constraint failed".
Why am I not getting the same error message that is being returned in
the console client?
I looked at the source code to sql
On Jul 6, 2009, at 3:14 PM, Nicolas Williams wrote:
> On Mon, Jul 06, 2009 at 02:49:07PM -0700, James Gregurich wrote:
>> 1) Why on earth would you want to scroll all the way to the bottom of
>> a long email to get the response simply for the sake of "We read
>> Engli
based on the test I just ran, it reports the first one encountered only.
On Jul 6, 2009, at 2:53 PM, Nicolas Williams wrote:
> On Sat, Jul 04, 2009 at 10:24:50AM +0200, Kees Nuyt wrote:
>> On Fri, 03 Jul 2009 14:38:43 -0700, James Gregurich
>> wrote:
>>
>>>
e of duplcate key is used):
> - before insert
> - before delete
> - after delete
> - after insert
On Jul 6, 2009, at 1:15 PM, Simon Slavin wrote:
> Please quote previous text above your response to it. We read English
> top to bottom.
>
> On 6 Jul 2009, at 8:22pm, Jame
On Jul 6, 2009, at 3:53 AM, Simon Slavin wrote:
> (Sorry, hit 'Send' before I meant to.)
>
> On 6 Jul 2009, at 6:34am, James Gregurich wrote:
>
>> a question for the sqlite developers.
>>
>> The inability of "INSERT OR REPLACE" to maintain
EPLACE" to call delete triggers so that
referential integrity can be maintained?
thanks,
James
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I have the following:
CREATE TABLE [Sections] (
[Department] varchar NOT NULL COLLATE NOCASE,
[Course] varchar NOT NULL COLLATE NOCASE,
[Section] varchar NOT NULL COLLATE NOCASE,
[Class_Time] timestamp,
[I_Id] varchar COLLATE NOCASE,
[Room] varchar COLLATE NOCASE,
CONSTRAINT [sqlite_
nuts. that makes INSERT OR REPLACE worthless if you have tables
dependent on one another.
Is there any way to manually get a list of records for which there
would be a conflict if a given record was inserted?
> On Fri, 03 Jul 2009 11:29:14 -0700, James Gregurich
> wrote:
>
>
I read on another posting in the archives that it does not. However, I
haven't tried it myself.
-James
> Simon Slavin
> Fri, 03 Jul 2009 09:44:22 -0700
>
> On 3 Jul 2009, at 3:28am, James Gregurich wrote:
>
> > How do I maintain referential integrity on a INSERT OR
based on my reading of the docs for INSERT OR REPLACE, it will delete
rows for ANY constraint violation, not just one involving the primary
key. Is that reading wrong?
-James
> On Thu, 02 Jul 2009 19:28:17 -0700, James Gregurich
> wrote:
>
> >
> >question:
>
question:
How do I maintain referential integrity on a INSERT OR REPLACE given
it does not call the delete trigger on the offending rows?
thanks,
james
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
d INTEGER);
CREATE TRIGGER trig BEFORE INSERT ON test1b
BEGIN
SELECT CASE
WHEN (1)
THEN RAISE(ABORT, 'no parent element')
END;
END;
COMMIT;
sqlite> INSERT INTO "test1b" VALUES(1,10,20);
SQL error: no parent element
sqlite>
On Jul 1, 2009, at 6:40 PM, Simon Slavin w
thanks.
I tried that, but I still got back "constraint failed" rather than my
RAISE message. Since you say it should work, I probably did something
wrong. I'll look at it again.
On Jul 1, 2009, at 3:59 PM, Simon Slavin wrote:
>
> On 1 Jul 2009, at 8:19pm, James Gregur
ah. I have no knowledge of how mailing list programs work. no "poor
etiquette" was intended.
On Jul 1, 2009, at 1:41 PM, P Kishor wrote:
> On Wed, Jul 1, 2009 at 3:39 PM, James Gregurich
> wrote:
>>
>> How would I have "hijacked" a thread? I
How would I have "hijacked" a thread? I changed the subject and
removed the original text.
On Jul 1, 2009, at 12:32 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> James Gregurich wrote:
>>
>> howdy!
>
> You hijacke
howdy!
Would there be a way to identify the offending constraint if
"SQLITE_CONSTRAINT" is returned?
sqlite3_errmsg is just telling me "constraint failed"...which is of
limited usefulness.
-James
___
sqlite-users maili
thanks!
On Jun 18, 2009, at 6:01 PM, Dennis Cote wrote:
> James Gregurich wrote:
>> on that update statement, is the SQL optimizer smart enough to not
>> rerun that select statement for each column in the update's set
>> clause? Is it going to run a single select s
oops. sorry for errant message, folks. I had the wrong email selected
when I hit the button and didn't pay attention to what I was doing.
On Jun 17, 2009, at 3:19 PM, James Gregurich wrote:
>
> So what are you going to do? we need to get your plans pinned down.
>
> On Jun 1
So what are you going to do? we need to get your plans pinned down.
On Jun 17, 2009, at 11:46 AM, James Gregurich wrote:
>
> Dennis,
>
> question on an old post of yours below...
>
>
> on that update statement, is the SQL optimizer smart enough to not
> rerun that s
each column in the
update statement?
-James
> Petite Abeille wrote:
> >
> > How does one emulate a DML MERGE statement in SQLite [1]?
> >
> > INSERT OR REPLACE sounds promising but the REPLACE documentation
> under
> > the ON CONFLICT clause seems to i
and issue a "INSERT INTO t1 SELECT
* FROM d2.t2;" query.
Is that correct? Is there a better way?
Is this operation inefficient or pitfalls any pitfalls to watch out for?
-James
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
ithesis of politics. There are no facts in
> science,
> only observations and any hypothesis is only valid until a better one
> replaces it.
>
> You describe bad, politicized science.
>
> James Gregurich wrote:
>> With all due respect, science itself is a set of
>>
in an
uncontrollable environment (i.e. a consumer desktop computer) when I
can just use NSOperation, boost::thread, and boost::mutex to build a
single-process solution that shares data in a normal way between tasks?
James Gregurich
Engineering Manager
Markzware
On Apr 29, 2009, at 11:23 PM
VM space was indeed a challenge. I had to
come up with a scheme to throttle the task queue once memory
consumption reached a certain level.
As for the quality of staff members, that is always a challenge. All I
can do about that is recruit and retain people who are talented and
can write so
in an
uncontrollable environment (i.e. a consumer desktop computer) when I
can just use NSOperation, boost::thread, and boost::mutex to build a
single-process solution that shares data in a normal way between tasks?
James Gregurich
Engineering Manager
Markzware
On Apr 29, 2009, at 11:23 PM
onceived programs doesn't mean
threaded programs are inherently doomed to be ill-conceived. The
development tools and techniques for building concurrent systems are
advancing and making concurrency quite feasible.
James Gregurich
Engineering Manager
Markzware
On Apr 30, 2009, at 5:01 AM,
is a major part of that effort. As I
understand it, MS is developing their copy of NSOperation for VS2010.
The development landscape is only going to get more threaded as time
goes on.
-James
> On Apr 29, 2009, at 10:03 PM, James Gregurich wrote:
>
> > howdy!
> >
> &g
howdy!
question:
for an in-memory db with the threading mode set to serialized, is the
internal mutex held for an entire transaction so that one thread won't
access the db while another one is in the middle of a transaction with
multiple insert statements?
thanks for any info.
James Sheridan wrote:
> CREATE TABLE [Query] (
> [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
> [creatorID] INTEGER NOT NULL,
> [ownerID] INTEGER NOT NULL,
> [type] VARCHAR NOT NULL
> );
> CREATE TABLE [UserQuery] (
> [u
rows.
Yes, changing to a LEFT JOIN gets around this, but the original question still
stands :)
Thanks.
--
James Sheridan
Tenable Network Security
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
/OC5/WOA05/pr_woa05.html , and should be
acknowledged in the event you use it for any oceanographic research.
Cheers,
Jamie
On Thu, Oct 9, 2008 at 12:16 PM, James Pringle <[EMAIL PROTECTED]> wrote:
> Hi all-
>
>Thanks for your many suggestions. I have tried many of your
>
ll subset of the data (450Mb) which exhibits the same
behaviour. The data is public (it is from the National Ocean Database), and
so if anyone wants to see it I would be happy to put it on my web server.
Cheers,
and thanks to everyone who helped me!
Jamie Pringle
On Wed, Oct 8, 2008 at 6:50
Hi-
I am new to sqlite, and am having a puzzling problem. I have read
that adding an INDEX to a sqlite table can never make a SELECT
statement slower. However, in my case, it seems to be making the
select statement an order of magnitude slower, which is not what I
wanted! What could be going
vance to anyone that may
be willing to help.
Thanks and
cheers
James
--
--
-- "Problems are solved by method"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
re getting.
This is incorrect. The only wild cards affecting operation of the LIKE
operator are '%' and '_'.
Regards,
Simon
2008/6/25 James <[EMAIL PROTECTED]>:
> Hi, Simon:
>Thanks for help me solve this problem.
>I have study the link you give me
Hi, Simon:
Thanks for help me solve this problem.
I have study the link you give me. But I still don't understand why
my original SQL statement can't work. Could you explain in detail?
Thank you.
James
-Original Message-
From: [EMAIL PROTECTED]
[mai
: [sqlite] NOT LIKE statement
Hi James,
I think the problem lies with your expectations.
Read the section on the LIKE operator in
http://www.sqlite.org/lang_expr.html
Rgds,
Simon
2008/6/25 James <[EMAIL PROTECTED]>:
> Hi,
>
> I execute the SQL statement [SELECT Name FROM tr06
Could someone tell me ?
Thank you.
James Liang
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I would remove the leading/trailing quotes external to the import of the file,
using something like sed or gawk.
I couldn't work out how to do this purely using sqlite, however.
_
It's simple! Sell your car for just $30 at CarPoint.
interesting. thanks for the tip.
I"ll give it some consideration.
-James
On Apr 21, 2008, at 1:07 :50PM, Scott Hess wrote:
> If you create a file on disk and set PRAGMA synchronous = OFF, you
> should get pretty close to the performance of a shared in-memory
> database on most
nd it? Or is it there and
I've missed it?
TIA,
James
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.2/1387 - Release Date: 19/4/2008
11:31
___
sqlite-users mailing list
sqlite-users@sqlite.o
yself.
Actually, CoreData is what I intended to use at first. However, I have
explored the possibility of directly using SQLite instead to keep my
document readers and their data management cross-platform.
On Apr 20, 2008, at 8:31 AM, Dennis Cote wrote:
> James Gregurich wrote:
>> I t
ERROR
oh well.
I think I will go with CoreData on MacOSX and figure out something
else to do on Windows later.
my thanks to all who attempted to provide a solution.
-James
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
a new file in vfs, a new handler is created and
> assigned to
> that filename and registered in this map.
>
>
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of James Gregurich
> Sent: sábado, 19 de abril de 2008 17:02
&
he overall system.
-James
On Apr 19, 2008, at 12:03 PM, Virgilio Fornazin wrote:
> what about creating a VFS for such task ? Can be accomplished in
> many ways,
> using heap memory, shared memory... not so easy to do, but not much
> complicated too... locking can be provided by mul
s going on simultaneously
on the same connection but each insert operation going into a
different attached in-memory db.
On Apr 19, 2008, at 9:20 AM, Dan wrote:
>
> On Apr 19, 2008, at 6:06 AM, James Gregurich wrote:
>
>>
>> I'll ask this question. The answer is proba
hread 2. Can I share the connection
across the 2 threads if each thread works exclusively in its own db?
I am aware that the connection is generally not threadsafe, but will
it work if the two threads don't operate on the same db at the sam
On Apr 18, 2008, at 2:33 :32PM, Dennis Cote wrote:
>
> To share an attached database the threads must be able to name it, and
> this is only possible with a file database.
you could change the open() function to be able to assign a name to an
in-memory db and then keep a mapping of all the name
On Apr 18, 2008, at 1:25 :36PM, Dennis Cote wrote:
> James Gregurich wrote:
>>
>> suppose I create a temporary db file on disk. Each task ( a thread)
>> opens a connection to the temp file and attaches an in-memory db to
>> it.
>
> You will have to open the memor
design give me full concurrency on my writer tasks until
they are ready to flush their results to the disk file? As I
understand it, the attached db won't be locked by reading done on the
disk file.
thanks,
James
On Apr 18, 2008, at 10:33 :39AM, Dennis Cote wrote:
> James Gre
-memory data stores to another one via the C
API belong on the sqlite-dev list?
thanks,
James
On Apr 18, 2008, at 9:43 :22AM, John Stanton wrote:
> Just use a thread as a DB handler. Queue transactions to it using
> some
> IPC mechanism like a message queue or named pipe. Another
there a
way to attach an existing in-memory store to another in-memory store?
If not, how hard would it be to modify the sqlite source to allow such
an attachment to be made given the two connection pointers to two
independent stores?
thanks,
James Greg
Sorry, I have already solved!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of James
Sent: Tuesday, March 11, 2008 4:34 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite3_get_table only get 16 rows
Hi,
I use command-line to query the
Hi,
I use command-line to query the table:
# sqlite3 listtable
sqlite> select Name,Value from TblDeviceInfo;
AdditionalHardwareVersion
AdditionalSoftwareVersion
Description
DeviceLog
DeviceStatus
EnabledOptions
FirstUseDate
HardwareVersion
On the command line:
/ > sqlite3 test.db `select name from PerfTest1 where name = "key5000"'
does work. I know this because if I query for "key500" I get back that
row. It's not blanks either because if I
do:
where name link "key1%"
I only get rows prior to "key199". Very weird. I did t
>
>
>That's sounds like good advice. I'll do that.
>>
>> Working with flash in this way is going to be a challenge. With limited
>> number of writes in a lifetime (this device needs to last approx 20
>> years...) I will have to make some major design decisions around how
>> I handle the writes.
>
> One thing I can highly recommend on embedded systems, especially flash
> based ones, is turn pragma synchronous to off. Having sqlite write every
> record modification to the flash, is a stunningly expensive process,
> even when it's all encapsulated in a large transaction. Let linux handle
> th
>
>
>I'm in the process of architecting the software for an embedded Linux system
>> that functions as a remote and local user interface to a control system.
>> There
>> will be a lot of analog (fast) data arriving via SPI bus and I'm thinking of
>> using SQLite to store this data in a well organiz
>I'm in the process of architecting the software for an embedded Linux system
>> that functions as a remote and local user interface to a control system.
>> There
>> will be a lot of analog (fast) data arriving via SPI bus and I'm thinking of
>> using SQLite to store this data in a well organized
; do
> > this?
> >
>
> WHERE col LIKE '123%'
>
> or WHERE substr(col,1, 3) = '123'
One note:
The optimizer has a decent chance of using an index for LIKE '123%' but
I'd be surprised (and impressed) if it looks inside function calls such
as substr for opportunities to use indexes.
-- James
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
async3-1.0... Ok
> async3-1.1...make: *** [test] Bus Error (core dumped)
>
> Any ideas?
Getting a stack trace out of that core file with a debugger would seem
to be the next step, and seeing the full text output if there is any
more.
-- James
-
ritten to
> .libs/testfixture
> > collect2: ld returned 1 exit status
> > make: *** [testfixture] Error 1
> >
>
> So how does a thread yield its timeslice on solaris?
sched_yield is there, it just needs -lrt
;
> Now it works !!
>
> A newbie error...
Now you just need to watch out for memory leaks.
-- James
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
rappers can return std::string objects and avoid this issue (though
even in C++ it's important to consider validity/lifetime issues for both
pointers and iterators).
-- James
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
user-defined functions interface
> does not allow for this sort of optimization.
Right, which is why this conversation is about extending that interface
:)
> Or did I miss something?
No, I think you're in "violent agreement".
-- James
rder primarily by b (with the default, ascending, order) and
secondarily by a (with inverted/descending order).
select * from tst order by b desc, a desc;
might be what you were wanting?
-- James
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
> -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 "escap
hat way: [[] is a character class
containing only the character '['. [][], however, is a character class
containing two characters. The special rule is that the first character
after the opening '[' is part of the class even if it's a ']' or a '-'.
-- James
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
authentic C-shell?
> What do they do?
C shell on Solaris 9 gives an error on
echo [!c]*
as it considers the !c to be an event specification. Tcsh the same.
Ksh treats
echo [^c]*
the same as
echo c*
but does "the right thing" with
echo [!c]*
bash treats the two the same
is full
>
>
> Thanks in advance!
> James
>
801 - 900 of 1106 matches
Mail list logo