HELP: Like operator in Microsoft Access ODBC

[alexre1]

Help! I am using a Microsoft Access database, and whenever I try to execute a "SELECT ... WHERE" query with the LIKE operator, I get the following error:

Warning: Wrong parameter count for odbc_exec() in <script_location> on line <linenumber>

Example code is as follows:

<?PHP
$cnx = odbc_connect('CIDMS2' , '', '' );
if (!$cnx) {
echo "Error in odbc_connect" . $cnx;
exit();
}
$sql = "SELECT * FROM [UPDATED MAPS] WHERE UPPER(Title) Like \"%KEYWORD%\";";
$cur = odbc_exec($sql);
?>

This will always give an error on the last line. (odbc_exec).

I have tried this code in a Microsoft Acess query myself, and it works FINE in access, just not in PHP. This is driving me crazy! Any suggestions would be really appreciated! Any other kinds of SQL queries work fine. If you know anything about this please let me know.

Thanks in Advance

[Lars_Berg]

odbc_exec takes 2 parameters according to the manual

http://www.php.net/manual/en/function.odbc-exec.php

Is keyword meant to be a variable or just an exampe? Anyhow, you should not use " as string delimiter in SQL.

$sql = "SELECT * FROM [UPDATED MAPS] WHERE Title Like '%" . $KEYWORD . "%'";

[alexre1]

Sorry, the odbc_exec line was a typo, I did include the connection ID (there were two parameters) BUT the single quote did it! thanks a MILLION!