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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: Wolfgang dot Herden at t-online dot de
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 23:01:28 2025 UTC