PHP 4.0 Bug #9015 Updated: LIKE X* as Operator in SELECT statement using ODBC to MS-ACCESS does not work
| From: | phanto@php.net | Date: | Wed, 31 Jan 2001 00:45:42 +0000 |
| Subject: | PHP 4.0 Bug #9015 Updated: 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-45395@lists.php.net to get a copy of this message | ||
ID: 9015
Updated by: phanto
Reported By: Wolfgang.Herden@t-online.de
Old-Status: Open
Status: Closed
Bug Type: ODBC related
Assigned To:
Comments:
the wildcard for sql is % not * .
reopen if i misunderstood you.
harald.
Previous Comments:
---------------------------------------------------------------------------
[2001-01-30 18:05:49] Wolfgang.Herden@t-online.de
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?
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=9015