Tried and still getting the same error. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'.
<cfquery name="upcourse" datasource="cft"> UPDATE dbo.Courses SET CourseName=<cfqueryPARAM value = "#form.coursename#" CFSQLType = "CF_SQL_varchar">,CourseDesc=<cfqueryPARAM value = "#form.coursedesc1#" CFSQLType = "CF_SQL_varchar">,Cost=<cfqueryPARAM value = "#form.cost#" CFSQLType = "CF_SQL_money">,MaxStudents=<cfqueryPARAM value = "#form.maxstudents#" CFSQLType = "CF_SQL_integer"> WHERE (CourseID=#url.courseid#) </cfquery> I'm stumped! -----Original Message----- From: Matthew [mailto:[email protected]] Sent: July-14-09 4:13 PM To: cf-talk Subject: Re: Weird error Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam all the variables. Matt. On 14 Jul 2009, at 20:06, "Rick Sanders" <[email protected]> wrote: When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. The only html tags in the content are <p> and <br />. -----Original Message----- From: Jason Fisher [mailto:[email protected]] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error 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:324493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
