How are you referencing the XML node? Is the query below the generated query?
Adrian -----Original Message----- From: Jenny Gavin-Wear Sent: 16 March 2008 17:20 To: CF-Talk Subject: XML Question Banging head on desk, sure I'm doing something daft ... When I reference the xml item it looks fine, then I try and insert it into a table and this happenes: insert into tbl_emails (UserName, Password, FirstName, LastName, IsSystemAdmin, IsDomainAdmin) Values ( '<?xml version="1.0" encoding="UTF-8"?> <UserName xmlns="http://tempuri.org/">[EMAIL PROTECTED]</UserName>', How come the XML info is being shown and not just the item, please? TIA, Jenny ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4