The error "There is an error in your SQL syntax" displays
I have recordset which returns all values in one column so that I can validate the submitted item against it for duplicate entries.
However, as I have placed the filtered recordset above the insert behaviour, the $_POST['TAC'] value has no value since the form hasn't been completed, I'm assuming that this maybe causing the error?
But then how do I check for duplicates if the filtered recordset is placed after the insert server behaviour?
.