I’m confused what is wrong with my WHERE clause
any ideas ?
here is the Error I get:
Error while accessing the database:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘and DiseaseID = 1’ at line 1
Arthur
Quotes around [field] ?? To be sure what’s wrong set the sql debug on and it will show you the generated sql statement before executing. You can cut/past this in the sql builder to check it out. (application -> debug)
Solved
Yes, thank you for reminding me about the DEBUG mode - it hewlped to fix it easily.
Arthur