I'm doing (still!) an app for parents to sign up for
information from their child's school, and giving them the option
to choose more than one grade using checkboxes. I'm passing the
grades as a string, then parsing them into individual searchable
grades, and then querying the db to see if that email/school/grade
subscription already exists. If it doesn't exist, I want to add it
to the db. Using CFDUMP, I've verfied that I'm extracting the
correct records to add.
I've attached the query that selects the records to be added,
and then my current INSERT query (which chokes on "INSERT") -- I've
tried putting brackets around INSERT per the CFWACK, but that
didn't work either. The error is "Query of Queries syntax error;
Encountered INSERT".