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

Reply via email to