Re: [sqlite] Erreur avec DBD::SQLite

2005-10-11 Thread Cyril Scetbon
it seems there are not errors cause I can dump it, use it without warning. Maybe a select request in the limit clause is not supported ? Scott Leighton wrote: On Monday 10 October 2005 2:32 pm, Cyril Scetbon wrote: Scott Leighton wrote: On Monday 10 October 2005 6:03 am, Cyril

Re: [sqlite] Erreur avec DBD::SQLite

2005-10-10 Thread Scott Leighton
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

Re: [sqlite] Erreur avec DBD::SQLite

2005-10-10 Thread Cyril Scetbon
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

Re: [sqlite] Erreur avec DBD::SQLite

2005-10-10 Thread Scott Leighton
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

Re: [sqlite] Erreur avec DBD::SQLite

2005-10-10 Thread Puneet Kishor
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=

Re: [sqlite] Erreur avec DBD::SQLite

2005-10-10 Thread Cyril Scetbon
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} =

Re: [sqlite] Erreur avec DBD::SQLite

2005-10-10 Thread Puneet Kishor
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

Re: [sqlite] Erreur avec DBD::SQLite

2005-10-10 Thread cyril . scetbon
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