OH wait. I've done it again <slams forehead on the desk> the problem was i was updating the record using the text field in the WHERE clause.
Bad bad bad me. Sorry about that, everyone. We return you to normal programming. 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/month On Wed, Sep 7, 2011 at 5:46 PM, Mike Kear <afpwebwo...@gmail.com> wrote: > 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/month > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:347267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm