Hi,
I've created a data access page using Access 2003 which connects to a Mysql 5.0.24 database via ODBC connector 3.51.12. I can't get the Resynccommand to work - leaving it blank or setting it to
SELECT * from file WHERE idfield = ?
results in
Error: Too few parameters. Expected 1.
I know the SQL syntax apart from the ? is correct as if I anticipate the next Auto_Increment id and change the statement to
SELECT * from file WHERE idfield = n
then it works. I've tried all sorts of variations on delimiting the file, field and parameter and even different characters instead of the ? but nothing works.
Thanks in advance.
I've created a data access page using Access 2003 which connects to a Mysql 5.0.24 database via ODBC connector 3.51.12. I can't get the Resynccommand to work - leaving it blank or setting it to
SELECT * from file WHERE idfield = ?
results in
Error: Too few parameters. Expected 1.
I know the SQL syntax apart from the ? is correct as if I anticipate the next Auto_Increment id and change the statement to
SELECT * from file WHERE idfield = n
then it works. I've tried all sorts of variations on delimiting the file, field and parameter and even different characters instead of the ? but nothing works.
Thanks in advance.