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:331848
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
