Ya... sorry I should have said MS SQL 2005 and the datatype is XML. I experimented and used cf_sql_varchar with both a CF XML object and plain old text and both worked fine. The CF XML object must be pretty close to plain old text.
I wonder if CF8 will have an XML type to support MS SQL 2005. -----Original Message----- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 17, 2007 4:44 PM To: CF-Talk Subject: Re: cfqueryparam and XML The CFQUERYPARAM type is supposed to match the type of column you are inserting into. Typically, dumping XML into a standard MSSQL database I would assume your column type is either text or ntext. If you are using MS SQL 2005... Which has an XML type for the columns... hmm.... I'd still use the text type. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
