Re: Data Parse error

[Jason Fisher]

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" <sspro...@ccboe.com>
Sent: Thursday, March 18, 2010 10:18 AM
To: "cf-talk" <cf-talk@houseoffusion.com>
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