OK, I'm updating a record in my MSSQL database table. The column that's causing the error is an ntext column.
The error I'm getting is: [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). Here's my SQL query: <cfquery name="upcourse" datasource="cft"> 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#) </cfquery> I'm sending the data from FCK editor. I've done this before and never had a problem. Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
