Data Parse error

Try outputting your results, past it into a sql window and execute it <cfoutput> INSERT INTO SRAStaff (First, Last, MI, EmpID, CurrentSchool, CurrentSubjectOrGr, PhoneHome, PhoneCell, PhoneWork, Voicemail, Address, City, State, Zip, Email, ApplyPosition, ApplySchool, SchoolApplyOther, OnlineSubjectGr, OnlineSubjectGrPreferred, YrsPartic, TshirtSize) VALUES ('#Form.First#', '#Form.Last#', '#Form.MI#', '#Form.EmpID#', '#Form.CurrentSchool#', '#Form.CurrentSubjectorGr#', '#Form.PhoneHome#', '#Form.PhoneCell#', '#Form.PhoneWork#', '#Form.Voicemail#', '#Form.Address#', '#Form.City#', '#Form.State#', '#Form.Zip#', '#Form.Email#', '#Form.ApplyPosition#', '#Form.SchoolApply#', '#Form.SchoolApplyOther#', '#Form.SubjectGradePreferred#', '#Form.SubjectGradeOther#', '#Form.YrsPartic#', '#Form.TshirtSize#') </cfoutput> On Thu, Mar 18, 2010 at 12:07 PM, Carl V > > Steven, > > Try simplifying your insert query to troubleshoot the problem.  Remove > all but the first field from the query and test.  Add one more field and > test, rinse and repeat.  Also, enable debugging in CF Administrator, and > make sure that you add your computers IP address to the debug list.