On 12/8/06, Archie Campbell <[EMAIL PROTECTED]> wrote: > I have a new CF7 web system that stores fields from a PDF form in an MS > SQL 2005 table field of type XML. > > I know I can do a query that extracts the XML field that I can then get > into using XMLParse. > > What I am wondering is how to do a SQL query that will directly extract > certain XML elements from the XML data field making them available as > fields to the subsequent query processing.
Unfortunately, I haven't done any practical work with this, but I'm pretty sure I remember reading that you can exercise XPath queries against the XML datatype in SQL Server 2k5. Check the books online for XPath and you should get some examples. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4