note 21329 added to ref.odbc
| From: | NOSPAM-bkeyes at minnetronix dot com | Date: | Wed, 08 May 2002 19:17:44 +0000 |
| Subject: | note 21329 added to ref.odbc | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-30340@lists.php.net to get a copy of this message | ||
If you are accessing a Microsoft Access based query that contains a where clause with LIKE
'*XYZ' you may find that you don't get any results returned.
If this is the case you should change the asterisk in the clause to a percent sign:
LIKE '%XYZ'
The query should now return results to PHP.
However, the query will NOT return results if run from within Access. If you need to use the query
both from within Access and from PHP you will need to create 2 queries.
--
http://www.php.net/manual/en/ref.odbc.php
http://master.php.net/manage/user-notes.php?action=edit+21329
http://master.php.net/manage/user-notes.php?action=delete+21329
http://master.php.net/manage/user-notes.php?action=reject+21329