Hi Adrian, this is an excerpt from the generating code:
<cfoutput>
<cfloop from="1" to="#NumUsers#" index="I" >
<Cfset found = 0>
<cfquery datasource="#application.dsn#" name="exists">
select * from list_emails where sitedomain like 'fasttrackonline.co.uk'
</cfquery>
<cfloop query="exists">
<cfif exists.username is
MyXML.UserInfoListResult.Users.UserInfo[I].Username>
<cfset found = 1>
</cfif>
</cfloop>
<cfif found is 0>
<cfquery datasource="#application.dsn#">
insert into tbl_emails (UserName, Password, FirstName, LastName,
IsSystemAdmin, IsDomainAdmin)
Values (
'#MyXML.UserInfoListResult.Users.UserInfo[I].Username#',
'#ToString(MyXML.UserInfoListResult.Users.UserInfo[I].Password)#',
'#MyXML.UserInfoListResult.Users.UserInfo[I].Firstname#',
'#MyXML.UserInfoListResult.Users.UserInfo[I].LastName#',
<cfif MyXML.UserInfoListResult.Users.UserInfo[I].IsSystemAdmin is
"true">1<cfelse>0</cfif>,
<cfif MyXML.UserInfoListResult.Users.UserInfo[I].IsDomainAdmin is
"true">1<cfelse>0</cfif>
)
</cfquery>
</cfif>
</cfloop>
</cfoutput>
-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 16 March 2008 18:04
To: CF-Talk
Subject: RE: XML Question
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:301393
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
