Re: PHP 4.0 Bug #7592: LIKE operator fails

Hello, AFAIK you need to use LIKE "A%" and not "A*" Derick frederic.choquet@caramail.com wrote: > 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 > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Derick Rethans JDI Media Solutions H.v.Tussenbroekstraat 1 6952 BL Dieren The Netherlands e-mail: d.rethans@jdimedia.nl http://www.jdimedia.nl/