PHP 4.0 Bug #9015: LIKE X* as Operator in SELECT statement using ODBC to MS-ACCESS does not work
| From: | Wolfgang dot Herden at t-online dot de | Date: | Tue, 30 Jan 2001 23:05:49 +0000 |
| Subject: | PHP 4.0 Bug #9015: LIKE X* as Operator in SELECT statement using ODBC to MS-ACCESS does not work | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-45375@lists.php.net to get a copy of this message | ||
From: Wolfgang.Herden@t-online.de
Operating system: NT 4.0
PHP version: 4.0.3pl1
PHP Bug Type: ODBC related
Bug description: LIKE X* as Operator in SELECT statement using ODBC to MS-ACCESS does not work
The following SQL statements do not lead to any selection.
But direct tests via MS-ACCESS showed the correctness of the SQL statements.
Example code:
..
$PARAMETER = "XYZ*";
$QUERY = "SELECT ... WHERE ((Table.Row) LIKE '$PARAMETER') .....";
...
$RESULT = odbc_exec ($DB, $QUERY);
does not work (no results from odbc_exec).
If I use "XYZ" instead of "XYZ*", I get at least one result for the string
"XYZ".
Who swallows or changes the *-sign?
--
Edit Bug report at: http://bugs.php.net/?id=9015&edit=1