note 21329 added to ref.odbc

From: 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

« previous php.notes (#30340) next »