RE: [PHP-WIN] Select statement not working
| From: | Gregory_Griffiths at cargill dot com | Date: | Thu, 19 Apr 2001 12:14:24 +0000 |
| Subject: | RE: [PHP-WIN] Select statement not working | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-6865@lists.php.net to get a copy of this message | ||
Please cna you post the rest of your PHP code so we can have a look at
it.
> -----Original Message-----
> From: nick.allen@tbwa-europe.com [mailto:nick.allen@tbwa-europe.com]
> Sent: 19 April 2001 13:13
> To: php-windows@lists.php.net
> Cc: nick.allen@tbwa-europe.com
> Subject: [PHP-WIN] Select statement not working
>
>
> 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.
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>
>