The double quotes are your problem. This will NOT work: "<cfqueryparam value="#Form.First#" cfsqltype="cf_sql_varchar">"
This is all you need: <cfqueryparam value="#Form.First#" cfsqltype="cf_sql_varchar"> The cfqueryparam already handles the correct quotes based on the cfsqltype for each element. ---------------------------------------- From: "Steven Sprouse" <[email protected]> Sent: Thursday, March 18, 2010 10:18 AM To: "cf-talk" <[email protected]> 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:331850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
