SQL ODBC to Access97
| From: | Derek Paterson | Date: | Fri, 01 Sep 2000 11:50:31 +0000 |
| Subject: | SQL ODBC to Access97 | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2554@lists.php.net to get a copy of this message | ||
Everything seems to work fine on most SQL Selects but for some reason this
one hangs (no error on either client or server).
$sql = "SELECT Untitled.* FROM Untitled GROUP BY Untitled.WGCode ORDER BY
Untitled.$SortOrder DESC";
It works without the GROUP BY but when it is added, the connection starts,
but the client reports finished although the query hasn't been prepared (no
error reported). It appears to be the same with all aggregate functions
such as SUM & COUNT.
Is it my ODBC driver (NTW4 SP5) components version 3.520.4403.2?
Any ideas?
Derek