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
<[email protected]> 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
