You all have been able to help me so much this week with a form I've been
working on, and it's nearly complete. The final step is to get the data entered
into the database without throwing an error.
The error is: Error Executing Database Query. [Macromedia][SequeLink JDBC
Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][ODBC
Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL <br>The
error occurred on line 487.
The SQL code in my document is:
<cfquery datasource="filemaker_srmastaff" name="newRegistration">
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#')
</cfquery>
Could it be that setting within the actual database for data type, etc. could
be causing the issue? If so, how do I get around this?
Thanks again for any help you can offer!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:331830
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
