ID: 9015
Updated by: phanto
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: ODBC related
Assigned To: 
Comments:

the wildcard for sql is % not * .

reopen if i misunderstood you.

harald.

Previous Comments:
---------------------------------------------------------------------------

[2001-01-30 18:05:49] [EMAIL PROTECTED]
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?

---------------------------------------------------------------------------


Full Bug description available at: http://bugs.php.net/?id=9015


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to