Lose the single quotes around the CFQUERYPARAM ... it already handles that
for you:
UPDATE dbo.Courses
SET CourseName = '#Trim(form.coursename)#',
CourseDesc = <cfqueryPARAM value="#form.coursedesc#"
CFSQLType="CF_SQL_longvarchar" />,
Cost = #form.cost#,
MaxStudents = #form.maxstudents#
WHERE CourseID = #url.courseid#
(and go ahead and use CFQUERYPARAM on all the variables :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:324489
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
