Sam
Thu, 18 Mar 2010 09:12:05 -0700
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 Von Stetten <vonner.li...@vonner.net> wrote: > > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm