This one took me a few minutes to figure out. “Incorrect syntax near ‘@P2’. “. At first I thought my Colfusion server was having an issue with an email address I was inserting but the “P2” was not in the data at all. I finally discovered that my insert statement was missing the comma for the 2nd Parameter.
Insert into mytable