note 21329 deleted from ref.odbc by sniper
| From: | sniper@php.net | Date: | Tue, 04 Nov 2003 00:37:59 +0000 |
| Subject: | note 21329 deleted from ref.odbc by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-59760@lists.php.net to get a copy of this message | ||
Note Submitter: NOSPAM-bkeyes@minnetronix.com
----
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.