#27497 [Opn->Bgs]: dbx does not know about COUNT
| From: | derick@php.net | Date: | Thu, 04 Mar 2004 18:45:32 +0000 |
| Subject: | #27497 [Opn->Bgs]: dbx does not know about COUNT | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-55922@lists.php.net to get a copy of this message | ||
ID: 27497
Updated by: derick@php.net
Reported By: leonard at den dot ottolander dot nl
-Status: Open
+Status: Bogus
Bug Type: DBX related
Operating System: Linux (RH 9 and FC 1)
PHP Version: 4.3.4
New Comment:
This doesn't have anything to do with DBX, but with the database
backend that you use for it. That one simply doesn't support "COUNT".
Not a bug in PHP -> bogus.
Previous Comments:
------------------------------------------------------------------------
[2004-03-04 13:32:44] leonard at den dot ottolander dot nl
Description:
------------
dbx gives a syntax error when using COUNT:
SELECT COUNT (
ID) FROM category WHERE packageID = 593
You have an error in your SQL syntax near '(ID) FROM category WHERE
packageID = 593' at line 1
First seen on Red Hat Linux 9, php-4.2.2, but reproduced on Fedora Core
1, php-4.3.4.
Reproduce code:
---------------
$q = ...COUNT...;
echo $q;
$res = dbx_query($link, $q);
if ($res == 0) {
echo dbx_error($link);
}
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=27497&edit=1