names of some of your db columns - like EmpID - suggest that those are
integer (or similar) datatype. however, you have ALL the values being
inserted into db enclosed in ' (single quotes) - like '#Form.EmpID#' -
which is incorrect for integer-based columns. only string-based data
should be enclosed in single quotes.
on a related subject, using <cfqueryparam> tag will be a good idea...
Azadi
On 18/03/2010 03:42, Steven Sprouse wrote:
> 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:331840
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
