php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #7592 LIKE operator fails
Submitted: 2000-11-02 10:09 UTC Modified: 2000-11-02 13:27 UTC
From: frederic dot choquet at caramail dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.3pl1 OS: WinNT 4.0 WS
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: frederic dot choquet at caramail dot com
New email:
PHP Version: OS:

 

 [2000-11-02 10:09 UTC] frederic dot choquet at caramail dot com
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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-11-02 13:27 UTC] waldschrott@php.net
it?s SQL problems, not PHP problems, here - please only post
PHP bugs here

anyway, try this "... LIKE 'A%'"
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri May 17 23:01:32 2024 UTC