Feel free to take a quick look at ticket 1476 (
http://www.sqlite.org/cvstrac/tktview?tn=1476 ). The attached patch
provides nextval() and curval() functions to manipulate named sequences
in a manner similar to those found in other databases. It was developed
to meet a requirement similar to
On Monday 10 October 2005 2:32 pm, Cyril Scetbon wrote:
> Scott Leighton wrote:
> >On Monday 10 October 2005 6:03 am, Cyril Scetbon wrote:
> >>No error code is returned cause the script is blocked by the instruction
> >>$dbh->do($req);
> >
> > Change that line to
> >
> > $dbh->do($req) or die
Scott Leighton wrote:
On Monday 10 October 2005 6:03 am, Cyril Scetbon wrote:
No error code is returned cause the script is blocked by the instruction
$dbh->do($req);
Change that line to
$dbh->do($req) or die $dbh->errstr;
to get an error displayed.
Scott
I used it
... internationalise. Sorry, couldn't resist.
|-+>
| | [EMAIL PROTECTED]|
| ||
| | 11/10/2005 07:48 |
| | Please respond to|
| | sqlite-users
<[EMAIL PROTECTED]> wrote:
> I am looking to be able to return a string from the function strftimeFunc()
> where the month can be returned as "MMM" (like "AUG"). Is this a feature
> that could be implemented in SQLITE in the near future?
> Thanks,
> Nicole Hinderman
That is easy enough to do for
Hey, why not use the SQLite based spellchecker at
http://www.pivotal-solutions.co.uk/spellcheck/
I know it says it's for sale but we're going to start giving it away in
the next few weeks.
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of
I am looking to be able to return a string from the function strftimeFunc()
where the month can be returned as "MMM" (like "AUG"). Is this a feature
that could be implemented in SQLITE in the near future?
Thanks,
Nicole Hinderman
On Monday 10 October 2005 6:03 am, Cyril Scetbon wrote:
>
> No error code is returned cause the script is blocked by the instruction
> $dbh->do($req);
>
Change that line to
$dbh->do($req) or die $dbh->errstr;
to get an error displayed.
Scott
--
POPFile, the OpenSource EMail
[EMAIL PROTECTED] wrote:
Dan Kennedy <[EMAIL PROTECTED]> wrote:
Yes. I appologize for the misspelling. And, No, I was not
aware of the second Frankfurt. Frankfurt am Main is the only
one I had ever heard of.
How about "Sidney" then? We're offended too! :)
If you haven't
While running some performance tests i ran into a condition where
sqlite3_close got caught in an infinite loop.
The loop it gets caught in is on line main.c 194:
while( pPrev && pPrev->pNext!=db ){
pPrev = pPrev->pNext;
}
This did not happen until i upgraded to 3.2.7, not the only
>
>
> --- [EMAIL PROTECTED] wrote:
>
>> "Gerald Dachs" <[EMAIL PROTECTED]> wrote:
>> > > 2005-11-08 Frankfort, Germany
>> >
>> > I guess you mean Frankfurt ;). Be aware that the are two cities in
>> Germany
>> > that are named Frankfurt. I expect that the Conference will be in
>> Frankfurt
>> > am
Dan Kennedy <[EMAIL PROTECTED]> wrote:
> >
> > Yes. I appologize for the misspelling. And, No, I was not
> > aware of the second Frankfurt. Frankfurt am Main is the only
> > one I had ever heard of.
>
> How about "Sidney" then? We're offended too! :)
>
If you haven't noticed already,
--- [EMAIL PROTECTED] wrote:
> "Gerald Dachs" <[EMAIL PROTECTED]> wrote:
> > > 2005-11-08 Frankfort, Germany
> >
> > I guess you mean Frankfurt ;). Be aware that the are two cities in Germany
> > that are named Frankfurt. I expect that the Conference will be in Frankfurt
> > am Main and not in
"Gerald Dachs" <[EMAIL PROTECTED]> wrote:
> > 2005-11-08 Frankfort, Germany
>
> I guess you mean Frankfurt ;). Be aware that the are two cities in Germany
> that are named Frankfurt. I expect that the Conference will be in Frankfurt
> am Main and not in Frankfurt an der Oder.
>
Yes. I
> 2005-11-08 Frankfort, Germany
I guess you mean Frankfurt ;). Be aware that the are two cities in Germany
that are named Frankfurt. I expect that the Conference will be in Frankfurt
am Main and not in Frankfurt an der Oder.
Gerald
On Oct 10, 2005, at 8:03 AM, Cyril Scetbon wrote:
Puneet Kishor wrote:
On Oct 10, 2005, at 7:35 AM, [EMAIL PROTECTED] wrote:
Sorry the precedent message was in french :-(
I encountered a weird error using DBD::SQLite.
This code works good :
use DBI;
$dbh=
Puneet Kishor wrote:
On Oct 10, 2005, at 7:35 AM, [EMAIL PROTECTED] wrote:
Sorry the precedent message was in french :-(
I encountered a weird error using DBD::SQLite.
This code works good :
use DBI;
$dbh= DBI->connect("dbi:SQLite:dbname=./backup.db")|| warn $!;
$dbh->{TraceLevel} =
On Oct 10, 2005, at 7:35 AM, [EMAIL PROTECTED] wrote:
Sorry the precedent message was in french :-(
I encountered a weird error using DBD::SQLite.
This code works good :
use DBI;
$dbh= DBI->connect("dbi:SQLite:dbname=./backup.db")|| warn $!;
$dbh->{TraceLevel} = "3|SQL";
$req='delete from
Sorry the precedent message was in french :-(
I encountered a weird error using DBD::SQLite.
This code works good :
use DBI;
$dbh= DBI->connect("dbi:SQLite:dbname=./backup.db")|| warn $!;
$dbh->{TraceLevel} = "3|SQL";
$req='delete from logs where date not in (select date from logs order
by date
2005-10-17 Sidney Australia
Dan Kennedy presents two half-day tutorials on SQLite. The first
tutorial is an introduction to SQLite and the second is a detailed
look at the internal organization of the SQLite code base.
See http://www.auug.org.au/events/2005/auug2005/tutorials.html
Hi,
it seems, that ver 2.3.7 does not report the column names properly if one
use joined select. Documntation says:
... Normally, such result columns are named
. if the SELECT statement joins two or more
tables together, or simply if the SELECT statement queries a
single table. ...
21 matches
Mail list logo