I am having an issue updating a record that has a text field (MSSQLServer2005). I'm using <cfqueryparam and the docs are silent about what is the correct type for a MSSQL Text field. It's rejecting the update, saying "The data types text and varchar are incompatible in the equal to operator"
I've tried setting the sqltype to varchar, and longvarchar but it still gives the error. I've never had this problem updating records with text fields before. What's the correct sqltype to use for a MSSQLServer Text field type? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/mon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
