PHP 4.0 Bug #7592: LIKE operator fails
| From: | frederic dot choquet at caramail dot com | Date: | Thu, 02 Nov 2000 15:09:20 +0000 |
| Subject: | PHP 4.0 Bug #7592: LIKE operator fails | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-36790@lists.php.net to get a copy of this message | ||
From: frederic.choquet@caramail.com
Operating system: WinNT 4.0 WS
PHP version: 4.0.3pl1
PHP Bug Type: ODBC related
Bug description: LIKE operator fails
It seems impossible to use the SQL "LIKE" operator with ODBC/ACCESS 97.
ie:
$sqlstring = "SELECT Name FROM people WHERE Name LIKE \"A*\"";
$rst=odbc_exec($Conn, $sqlstring);
... may return the following err msg:
Impossible d'utiliser cette expression avec le prédicat LIKE. dans l'expression
'Name alike
A*'
(sorry, it's in french, in english it may look like: Unable to use this expression with
operator LIKE in expression 'Name alike A*')
What does this "alike" means?
If i echo $sqlstring, cut it and paste it directly to a query in Access, i got no err msg, so it is
not a syntax error.
--
Edit Bug report at: http://bugs.php.net/?id=7592&edit=1