Simple Insert Query
Hi everyone. I know this is going to sound elementary, but I've tried for almost a day to get this simple query to work, but I've had no luck. I've gone through it piece by piece, and recoded it from scratch, but haven't been able to figure it out. When I submit my form, I receive the "Syntax error in INSERT INTO statement" error. The datasource is defined, the table exists and the fields match up. The only thing to note is that there are two fields in my table, between ACT and PersonalU, that I am inserting data into.
I appreciate anyone's help. Thanks!
<cfquery name="scheduleApp" datasource="mainds">
INSERT INTO GUID:Appointments
(FirstName,LastName,EmailAddress,Counselor,ACT,PersonalU,PersonalNU,Schedule,Drop,Add,Transcript,School,OtherCheck,Other,Submitted)
VALUES ('#Trim(Form.FirstName)#','#Trim(Form.LastName)#','#Trim(Form.EmailAddress)#','#Form.Counselor#','#Form.ACT#','#Form.PersonalU#','#Form.PersonalNU#','#Form.Schedule#','#Trim(Form.Drop)#','#Trim(Form.Add)#','#Form.Transcript#','#Trim(Form.School)#','#Form.OtherCheck#','#Trim(Form.Other)#','#Today#')
</cfquery>
Table field properties
FirstName: Text
LastName: Text
EmailAddress: Text
Counselor: Text
ACT: Yes/No
PersonalU: Yes/No
PersonalNU: Yes/No
Schedule: Yes/No
Drop: Text
Add: Text
Transcript: Yes/No
School: Text
OtherCheck: Yes/No
Other: Memo
Submitted: Date/Time
