php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #9015 LIKE X* as Operator in SELECT statement using ODBC to MS-ACCESS does not work
Submitted: 2001-01-30 18:05 UTC Modified: 2001-01-30 19:45 UTC
From: Wolfgang dot Herden at t-online dot de Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.3pl1 OS: NT 4.0
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-01-30 18:05 UTC] Wolfgang dot Herden at t-online dot 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?

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-30 19:45 UTC] phanto@php.net 
the wildcard for sql is % not * .

reopen if i misunderstood you.

harald.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 25 09:01:29 2024 UTC