I try to run a query onto my MS Access database through an ODBC link .
The following code is working fine :
$ConnectionString = odbc_connect("DATABASE", "", "");
$query = "SELECT DISTINCT PARTS.IPROD, PARTS.IDESC FROM PARTS";
$queryexe = odbc_exec($ConnectionString, $query);
odbc_close($ConnectionString);
Now if I modify the query line with the following code :
$query = "SELECT DISTINCT PARTS.IPROD, PARTS.IDESC FROM PARTS WHERE PARTS.IDESC LIKE \"M*\"";
I get the following error message :
SQL error [Microsoft][ODBC Microsoft Access Driver] Too few parameters Expected 1 SQL state 07001 in SQLExecDirect ....
Is there anyone who have a solution for this ?
Thanks,
Gilles.