I am writing a create database record function in my CFC. Now one argument that is being passed in is data type of XML. So I use <cfargument> and set the type to XML.
Now when I am doing my INSERT into the database I am using <cfqueryparam> and noticed there is no cfsqltype of XML. What should I do? Now I don't HAVE to pass in a CF XML object. I could leave it the raw text from when I read the XML file with CFFile and pass that in to the CFC function. Honestly I don't know if when I do the insert if MS SQL is going to like me passing in a CF XML object. I have not tried it yet. The datatype in the MS SQL table is XML. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
