Select statement not working
| From: | Nick Allen | Date: | Thu, 19 Apr 2001 12:12:44 +0000 |
| Subject: | Select statement not working | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-6864@lists.php.net to get a copy of this message | ||
Can't seem to troubleshoot this one...
WinNT4.0
PHP4.0.3 cgi
Apache (latest)
Code queries an Access database via ODBC and returns an empty dataset
although there are definately records in there. Connection is fine - no
errors and a valid connection handle is returned.
echoing the query string to the page and then copying/pasting that directly
into the sql edit section of the query builder in MSAccess works fine.
Query is so simple it hurts:
SELECT txtIntCategory FROM tblIntCategory;
yet it returns *NOTHING*!!
Identical Access query returns 8 string values.
Any ideas or known bugs?
TIA.
Nick.