Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:18659 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 94627 invoked by uid 1010); 2 Sep 2005 19:11:49 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 94612 invoked from network); 2 Sep 2005 19:11:49 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 2 Sep 2005 19:11:49 -0000 X-Host-Fingerprint: 70.85.46.36 unknown Received: from ([70.85.46.36:45102] helo=prohost.org) by pb1.pair.com (ecelerity 2.0 beta r(6323M)) with SMTP id 12/4E-15098-4F3A8134 for ; Fri, 02 Sep 2005 15:11:49 -0400 Received: (qmail 5858 invoked from network); 2 Sep 2005 19:11:46 -0000 Received: from cpe000fb56099fd-cm000f9f7d6664.cpe.net.cable.rogers.com (HELO ?192.168.1.101?) (69.196.28.148) by prohost.org with SMTP; 2 Sep 2005 19:11:46 -0000 Message-ID: <4318A3F1.8080407@prohost.org> Date: Fri, 02 Sep 2005 15:11:45 -0400 User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Nuno Lopes CC: PHPdev References: <010101c5afea$4227cd80$0100a8c0@pc07653> <43189886.4010500@prohost.org> <010901c5afed$0db28380$0100a8c0@pc07653> In-Reply-To: <010901c5afed$0db28380$0100a8c0@pc07653> X-Enigmail-Version: 0.92.0.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] [PATCH] sqlite: retrieve SQL syntax errors From: ilia@prohost.org (Ilia Alshanetsky) > the "feature request": > > $db = sqlite_open(":memory:"); > sqlite_exec($db, "SELECT column"); > var_dump(sqlite_error_string(sqlite_last_error($db))); > ?> > > prints "SQL logic error or missing database", but you don't have a clue > of what error is. > with my patch, you can retrieve the error (in the additional variable) > you get in the Warning message ("no such column: column"). Aha, I see... that is indeed useful. +1 Ilia