Remove all the quotes around the cfqueryparams. ColdFusion will deal with the quotes for you when you use the cfqueryparam tag.
-----Original Message----- From: Steven Sprouse [mailto:[email protected]] Sent: Thursday, March 18, 2010 10:10 AM To: cf-talk Subject: Re: Data Parse error I'm sorry, I'm just not getting it. I've spent a week on this form and I'm just about ready to throw in the towel. I tried this change, but still got the parse error. Not even sure if this is the correct use of cfqueryparam .... <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 ("<cfqueryparam value="#Form.First#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.Last#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.MI#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.EmpID#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.CurrentSchool#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.CurrentSubjectorGr#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.PhoneHome#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.PhoneCell#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.PhoneWork#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.Voicemail#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.Address#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.City#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.State#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.Zip#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.Email#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.ApplyPosition#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.SchoolApply#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.SchoolApplyOther#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.SubjectGradePreferred#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.SubjectGradeOther#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.YrsPartic#" cfsqltype="cf_sql_varchar">", "<cfqueryparam value="#Form.TshirtSize#" cfsqltype="cf_sql_varchar">") </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
