[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

How do I parse the value of Insurer from this xml and insert into table.

Using Cold Fusion 8 how would i loop through the xml and insert the value of <insurer>.
Use
<cfloop>
xml
<cfset carier= xml.insurer.text>  

<cfquery datasource ="dsn">
Insert into table
(carrier)
Values('#carrier#')
</cfquery>

</cfloop>
- <Insurers>
- <Insurer diffgr:id="Insurer1" msdata:rowOrder="0">
  <insurer>(Not Listed)</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer2" msdata:rowOrder="1">
  <insurer>AAA</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer3" msdata:rowOrder="2">
  <insurer>AETNA</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer4" msdata:rowOrder="3">
  <insurer>AFLAC</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer5" msdata:rowOrder="4">
  <insurer>AIG / American General</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer6" msdata:rowOrder="5">
  <insurer>AIU Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer7" msdata:rowOrder="6">
  <insurer>Alfa Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer8" msdata:rowOrder="7">
  <insurer>All Risk</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer9" msdata:rowOrder="8">
  <insurer>Allianz</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer10" msdata:rowOrder="9">
  <insurer>Allied</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer11" msdata:rowOrder="10">
  <insurer>Allstate</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer12" msdata:rowOrder="11">
  <insurer>American Alliance Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer13" msdata:rowOrder="12">
  <insurer>American Automobile Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer14" msdata:rowOrder="13">
  <insurer>American Casualty</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer15" msdata:rowOrder="14">
  <insurer>American Deposit Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer16" msdata:rowOrder="15">
  <insurer>American Direct Business Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer17" msdata:rowOrder="16">
  <insurer>American Empire Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer18" msdata:rowOrder="17">
  <insurer>American Family</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer19" msdata:rowOrder="18">
  <insurer>American Financial</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer20" msdata:rowOrder="19">
  <insurer>American Home Assurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer21" msdata:rowOrder="20">
  <insurer>American Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer22" msdata:rowOrder="21">
  <insurer>American International Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer23" msdata:rowOrder="22">
  <insurer>American Manufacturers</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer24" msdata:rowOrder="23">
  <insurer>American Mayflower Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer25" msdata:rowOrder="24">
  <insurer>American Motorists Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer26" msdata:rowOrder="25">
  <insurer>American National</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer27" msdata:rowOrder="26">
  <insurer>American Premier Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer28" msdata:rowOrder="27">
  <insurer>American Protection Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer29" msdata:rowOrder="28">
  <insurer>American Republic</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer30" msdata:rowOrder="29">
  <insurer>American Savers Plan</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer31" msdata:rowOrder="30">
  <insurer>American Service Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer32" msdata:rowOrder="31">
  <insurer>American Skyline Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer33" msdata:rowOrder="32">
  <insurer>American Spirit Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer34" msdata:rowOrder="33">
  <insurer>American Standard Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer35" msdata:rowOrder="34">
  <insurer>Amica</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer36" msdata:rowOrder="35">
  <insurer>Anthem</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer37" msdata:rowOrder="36">
  <insurer>Arbella</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer38" msdata:rowOrder="37">
  <insurer>Associated Indemnity</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer39" msdata:rowOrder="38">
  <insurer>Assurant</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer40" msdata:rowOrder="39">
  <insurer>Atlanta Casualty</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer41" msdata:rowOrder="40">
  <insurer>Atlantic Indemnity</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer42" msdata:rowOrder="41">
  <insurer>Auto Club Insurance Company</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer43" msdata:rowOrder="42">
  <insurer>Banner Life</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer44" msdata:rowOrder="43">
  <insurer>Blue Cross / Blue Shield</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer45" msdata:rowOrder="44">
  <insurer>Cal Farm Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer46" msdata:rowOrder="45">
  <insurer>California State Automobile Association</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer47" msdata:rowOrder="46">
  <insurer>Chubb</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer48" msdata:rowOrder="47">
  <insurer>Clarendon American Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer49" msdata:rowOrder="48">
  <insurer>Clarendon National Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer50" msdata:rowOrder="49">
  <insurer>CNA</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer51" msdata:rowOrder="50">
  <insurer>Colonial Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer52" msdata:rowOrder="51">
  <insurer>Continental Casualty</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer53" msdata:rowOrder="52">
  <insurer>Continental Divide Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer54" msdata:rowOrder="53">
  <insurer>Continental Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer55" msdata:rowOrder="54">
  <insurer>Cotton States</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer56" msdata:rowOrder="55">
  <insurer>Country Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer57" msdata:rowOrder="56">
  <insurer>Dairyland Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer58" msdata:rowOrder="57">
  <insurer>Electric</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer59" msdata:rowOrder="58">
  <insurer>Erie</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer60" msdata:rowOrder="59">
  <insurer>Esurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer61" msdata:rowOrder="60">
  <insurer>Farm Bureau/Farm Family/Rural</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer62" msdata:rowOrder="61">
  <insurer>Farmers</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer63" msdata:rowOrder="62">
  <insurer>Farmers Union</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer64" msdata:rowOrder="63">
  <insurer>Firemans Fund</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer65" msdata:rowOrder="64">
  <insurer>Foremost</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer66" msdata:rowOrder="65">
  <insurer>GEICO</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer67" msdata:rowOrder="66">
  <insurer>GMAC</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer68" msdata:rowOrder="67">
  <insurer>Golden Rule</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer69" msdata:rowOrder="68">
  <insurer>Government Employees Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer70" msdata:rowOrder="69">
  <insurer>Great American</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer71" msdata:rowOrder="70">
  <insurer>Guaranty National Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer72" msdata:rowOrder="71">
  <insurer>Guardian</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer73" msdata:rowOrder="72">
  <insurer>Guideone</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer74" msdata:rowOrder="73">
  <insurer>Hanover</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer75" msdata:rowOrder="74">
  <insurer>Hartford AARP</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer76" msdata:rowOrder="75">
  <insurer>Health Net</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer77" msdata:rowOrder="76">
  <insurer>Health Plus of America</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer78" msdata:rowOrder="77">
  <insurer>HealthMarkets</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer79" msdata:rowOrder="78">
  <insurer>HealthShare America</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer80" msdata:rowOrder="79">
  <insurer>Humana</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer81" msdata:rowOrder="80">
  <insurer>IFA Auto Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer82" msdata:rowOrder="81">
  <insurer>IGF Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer83" msdata:rowOrder="82">
  <insurer>Infinity Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer84" msdata:rowOrder="83">
  <insurer>Infinity National Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer85" msdata:rowOrder="84">
  <insurer>Infinity Select Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer86" msdata:rowOrder="85">
  <insurer>Integon</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer87" msdata:rowOrder="86">
  <insurer>John Hancock</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer88" msdata:rowOrder="87">
  <insurer>Kaiser Permanente</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer89" msdata:rowOrder="88">
  <insurer>Kemper</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer90" msdata:rowOrder="89">
  <insurer>Landmark American Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer91" msdata:rowOrder="90">
  <insurer>Leader National Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer92" msdata:rowOrder="91">
  <insurer>Leader Preferred Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer93" msdata:rowOrder="92">
  <insurer>Leader Specialty Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer94" msdata:rowOrder="93">
  <insurer>Liberty Insurance Corp</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer95" msdata:rowOrder="94">
  <insurer>Liberty Mutual</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer96" msdata:rowOrder="95">
  <insurer>Liberty National</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer97" msdata:rowOrder="96">
  <insurer>Liberty Northwest Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer98" msdata:rowOrder="97">
  <insurer>Lumbermens Mutual</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer99" msdata:rowOrder="98">
  <insurer>Maryland Casualty</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer100" msdata:rowOrder="99">
  <insurer>Mass Mutual</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer101" msdata:rowOrder="100">
  <insurer>Mega / Midwest</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer102" msdata:rowOrder="101">
  <insurer>Mercury</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer103" msdata:rowOrder="102">
  <insurer>Metropolitan</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer104" msdata:rowOrder="103">
  <insurer>Mid Century Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer105" msdata:rowOrder="104">
  <insurer>Mid-Continent Casualty</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer106" msdata:rowOrder="105">
  <insurer>Middlesex Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer107" msdata:rowOrder="106">
  <insurer>Midland National Life</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer108" msdata:rowOrder="107">
  <insurer>Mutual of New York</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer109" msdata:rowOrder="108">
  <insurer>Mutual Of Omaha</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer110" msdata:rowOrder="109">
  <insurer>National Ben Franklin Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer111" msdata:rowOrder="110">
  <insurer>National Casualty</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer112" msdata:rowOrder="111">
  <insurer>National Continental Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer113" msdata:rowOrder="112">
  <insurer>National Fire Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer114" msdata:rowOrder="113">
  <insurer>National Health Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer115" msdata:rowOrder="114">
  <insurer>National Indemnity</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer116" msdata:rowOrder="115">
  <insurer>National Union Fire Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer117" msdata:rowOrder="116">
  <insurer>Nationwide</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer118" msdata:rowOrder="117">
  <insurer>New York Life</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer119" msdata:rowOrder="118">
  <insurer>Northwestern Mutual Life</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer120" msdata:rowOrder="119">
  <insurer>Northwestern Pacific Indemnity</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer121" msdata:rowOrder="120">
  <insurer>Omni Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer122" msdata:rowOrder="121">
  <insurer>Orion Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer123" msdata:rowOrder="122">
  <insurer>Pacific Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer124" msdata:rowOrder="123">
  <insurer>Pafco General Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer125" msdata:rowOrder="124">
  <insurer>Patriot General Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer126" msdata:rowOrder="125">
  <insurer>Peak Property and Casualty Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer127" msdata:rowOrder="126">
  <insurer>PEMCO</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer128" msdata:rowOrder="127">
  <insurer>Pennsylvania life</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer129" msdata:rowOrder="128">
  <insurer>Premier</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer130" msdata:rowOrder="129">
  <insurer>Principal Financial</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer131" msdata:rowOrder="130">
  <insurer>Progressive</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer132" msdata:rowOrder="131">
  <insurer>Protective Life</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer133" msdata:rowOrder="132">
  <insurer>Prudential</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer134" msdata:rowOrder="133">
  <insurer>Reliance Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer135" msdata:rowOrder="134">
  <insurer>Republic Indemnity</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer136" msdata:rowOrder="135">
  <insurer>Response</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer137" msdata:rowOrder="136">
  <insurer>SAFECO</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer138" msdata:rowOrder="137">
  <insurer>Safeway Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer139" msdata:rowOrder="138">
  <insurer>SBLI</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer140" msdata:rowOrder="139">
  <insurer>Security Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer141" msdata:rowOrder="140">
  <insurer>Sentinel Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer142" msdata:rowOrder="141">
  <insurer>Sentry</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer143" msdata:rowOrder="142">
  <insurer>Shelter</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer144" msdata:rowOrder="143">
  <insurer>St. Paul</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer145" msdata:rowOrder="144">
  <insurer>Standard Fire Insurance Company</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer146" msdata:rowOrder="145">
  <insurer>State and County Mutual Fire Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer147" msdata:rowOrder="146">
  <insurer>State Farm</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer148" msdata:rowOrder="147">
  <insurer>State National Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer149" msdata:rowOrder="148">
  <insurer>Superior American Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer150" msdata:rowOrder="149">
  <insurer>Superior Guaranty Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer151" msdata:rowOrder="150">
  <insurer>Superior Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer152" msdata:rowOrder="151">
  <insurer>The Ahbe Group</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer153" msdata:rowOrder="152">
  <insurer>The Hartford</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer154" msdata:rowOrder="153">
  <insurer>TICO Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer155" msdata:rowOrder="154">
  <insurer>TIG Countrywide Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer156" msdata:rowOrder="155">
  <insurer>Travelers</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer157" msdata:rowOrder="156">
  <insurer>Tri-State Consumer Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer158" msdata:rowOrder="157">
  <insurer>Twin City Fire Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer159" msdata:rowOrder="158">
  <insurer>UniCare</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer160" msdata:rowOrder="159">
  <insurer>United American/Farm and Ranch</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer161" msdata:rowOrder="160">
  <insurer>United Pacific Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer162" msdata:rowOrder="161">
  <insurer>United Security</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer163" msdata:rowOrder="162">
  <insurer>United Services Automobile Association</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer164" msdata:rowOrder="163">
  <insurer>Unitrin Direct</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer165" msdata:rowOrder="164">
  <insurer>Universal Underwriters Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer166" msdata:rowOrder="165">
  <insurer>US Financial</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer167" msdata:rowOrder="166">
  <insurer>US Health Group</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer168" msdata:rowOrder="167">
  <insurer>USAA</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer169" msdata:rowOrder="168">
  <insurer>USF and G</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer170" msdata:rowOrder="169">
  <insurer>Viking Insurance</insurer> 
  </Insurer>
+ <Insurer diffgr:id="Insurer171" msdata:rowOrder="170">
  <insurer>Windsor Insurance</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer172" msdata:rowOrder="171">
  <insurer>Woodlands Financial Group</insurer> 
  </Insurer>
- <Insurer diffgr:id="Insurer173" msdata:rowOrder="172">
  <insurer>Zurich North America</insurer> 
  </Insurer>

Open in new window

0
LeadCo
Asked:
LeadCo
  • 4
  • 3
1 Solution
 
ZvonkoSystems architectCommented:
Sorry but upper list of xml nodes is NOT a XML tree.
Therefore will no solution that we provide work for you.
We need the branch of nodes beginning from the root to the upper list of nodes, if you know what I mean.
0
 
ZvonkoSystems architectCommented:
Sorry, I scrolled down the list of nodes and did not catch the <Insurers> node.
Is Insurers your root node?
0
 
ZvonkoSystems architectCommented:
Check this:
<cfsavecontent  variable="theInsurers" ><?xml version="1.0" encoding="utf-8"?>
 <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
 <Insurers>
  <Insurer diffgr:id="Insurer1" msdata:rowOrder="0">
    <insurer>(Not Listed)</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer2" msdata:rowOrder="1">
    <insurer>AAA</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer3" msdata:rowOrder="2">
    <insurer>AETNA</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer4" msdata:rowOrder="3">
    <insurer>AFLAC</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer5" msdata:rowOrder="4">
    <insurer>AIG / American General</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer6" msdata:rowOrder="5">
    <insurer>AIU Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer7" msdata:rowOrder="6">
    <insurer>Alfa Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer8" msdata:rowOrder="7">
    <insurer>All Risk</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer9" msdata:rowOrder="8">
    <insurer>Allianz</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer10" msdata:rowOrder="9">
    <insurer>Allied</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer11" msdata:rowOrder="10">
    <insurer>Allstate</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer12" msdata:rowOrder="11">
    <insurer>American Alliance Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer13" msdata:rowOrder="12">
    <insurer>American Automobile Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer14" msdata:rowOrder="13">
    <insurer>American Casualty</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer15" msdata:rowOrder="14">
    <insurer>American Deposit Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer16" msdata:rowOrder="15">
    <insurer>American Direct Business Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer17" msdata:rowOrder="16">
    <insurer>American Empire Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer18" msdata:rowOrder="17">
    <insurer>American Family</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer19" msdata:rowOrder="18">
    <insurer>American Financial</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer20" msdata:rowOrder="19">
    <insurer>American Home Assurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer21" msdata:rowOrder="20">
    <insurer>American Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer22" msdata:rowOrder="21">
    <insurer>American International Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer23" msdata:rowOrder="22">
    <insurer>American Manufacturers</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer24" msdata:rowOrder="23">
    <insurer>American Mayflower Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer25" msdata:rowOrder="24">
    <insurer>American Motorists Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer26" msdata:rowOrder="25">
    <insurer>American National</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer27" msdata:rowOrder="26">
    <insurer>American Premier Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer28" msdata:rowOrder="27">
    <insurer>American Protection Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer29" msdata:rowOrder="28">
    <insurer>American Republic</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer30" msdata:rowOrder="29">
    <insurer>American Savers Plan</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer31" msdata:rowOrder="30">
    <insurer>American Service Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer32" msdata:rowOrder="31">
    <insurer>American Skyline Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer33" msdata:rowOrder="32">
    <insurer>American Spirit Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer34" msdata:rowOrder="33">
    <insurer>American Standard Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer35" msdata:rowOrder="34">
    <insurer>Amica</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer36" msdata:rowOrder="35">
    <insurer>Anthem</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer37" msdata:rowOrder="36">
    <insurer>Arbella</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer38" msdata:rowOrder="37">
    <insurer>Associated Indemnity</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer39" msdata:rowOrder="38">
    <insurer>Assurant</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer40" msdata:rowOrder="39">
    <insurer>Atlanta Casualty</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer41" msdata:rowOrder="40">
    <insurer>Atlantic Indemnity</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer42" msdata:rowOrder="41">
    <insurer>Auto Club Insurance Company</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer43" msdata:rowOrder="42">
    <insurer>Banner Life</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer44" msdata:rowOrder="43">
    <insurer>Blue Cross / Blue Shield</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer45" msdata:rowOrder="44">
    <insurer>Cal Farm Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer46" msdata:rowOrder="45">
    <insurer>California State Automobile Association</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer47" msdata:rowOrder="46">
    <insurer>Chubb</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer48" msdata:rowOrder="47">
    <insurer>Clarendon American Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer49" msdata:rowOrder="48">
    <insurer>Clarendon National Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer50" msdata:rowOrder="49">
    <insurer>CNA</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer51" msdata:rowOrder="50">
    <insurer>Colonial Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer52" msdata:rowOrder="51">
    <insurer>Continental Casualty</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer53" msdata:rowOrder="52">
    <insurer>Continental Divide Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer54" msdata:rowOrder="53">
    <insurer>Continental Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer55" msdata:rowOrder="54">
    <insurer>Cotton States</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer56" msdata:rowOrder="55">
    <insurer>Country Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer57" msdata:rowOrder="56">
    <insurer>Dairyland Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer58" msdata:rowOrder="57">
    <insurer>Electric</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer59" msdata:rowOrder="58">
    <insurer>Erie</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer60" msdata:rowOrder="59">
    <insurer>Esurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer61" msdata:rowOrder="60">
    <insurer>Farm Bureau/Farm Family/Rural</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer62" msdata:rowOrder="61">
    <insurer>Farmers</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer63" msdata:rowOrder="62">
    <insurer>Farmers Union</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer64" msdata:rowOrder="63">
    <insurer>Firemans Fund</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer65" msdata:rowOrder="64">
    <insurer>Foremost</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer66" msdata:rowOrder="65">
    <insurer>GEICO</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer67" msdata:rowOrder="66">
    <insurer>GMAC</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer68" msdata:rowOrder="67">
    <insurer>Golden Rule</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer69" msdata:rowOrder="68">
    <insurer>Government Employees Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer70" msdata:rowOrder="69">
    <insurer>Great American</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer71" msdata:rowOrder="70">
    <insurer>Guaranty National Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer72" msdata:rowOrder="71">
    <insurer>Guardian</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer73" msdata:rowOrder="72">
    <insurer>Guideone</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer74" msdata:rowOrder="73">
    <insurer>Hanover</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer75" msdata:rowOrder="74">
    <insurer>Hartford AARP</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer76" msdata:rowOrder="75">
    <insurer>Health Net</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer77" msdata:rowOrder="76">
    <insurer>Health Plus of America</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer78" msdata:rowOrder="77">
    <insurer>HealthMarkets</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer79" msdata:rowOrder="78">
    <insurer>HealthShare America</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer80" msdata:rowOrder="79">
    <insurer>Humana</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer81" msdata:rowOrder="80">
    <insurer>IFA Auto Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer82" msdata:rowOrder="81">
    <insurer>IGF Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer83" msdata:rowOrder="82">
    <insurer>Infinity Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer84" msdata:rowOrder="83">
    <insurer>Infinity National Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer85" msdata:rowOrder="84">
    <insurer>Infinity Select Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer86" msdata:rowOrder="85">
    <insurer>Integon</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer87" msdata:rowOrder="86">
    <insurer>John Hancock</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer88" msdata:rowOrder="87">
    <insurer>Kaiser Permanente</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer89" msdata:rowOrder="88">
    <insurer>Kemper</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer90" msdata:rowOrder="89">
    <insurer>Landmark American Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer91" msdata:rowOrder="90">
    <insurer>Leader National Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer92" msdata:rowOrder="91">
    <insurer>Leader Preferred Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer93" msdata:rowOrder="92">
    <insurer>Leader Specialty Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer94" msdata:rowOrder="93">
    <insurer>Liberty Insurance Corp</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer95" msdata:rowOrder="94">
    <insurer>Liberty Mutual</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer96" msdata:rowOrder="95">
    <insurer>Liberty National</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer97" msdata:rowOrder="96">
    <insurer>Liberty Northwest Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer98" msdata:rowOrder="97">
    <insurer>Lumbermens Mutual</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer99" msdata:rowOrder="98">
    <insurer>Maryland Casualty</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer100" msdata:rowOrder="99">
    <insurer>Mass Mutual</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer101" msdata:rowOrder="100">
    <insurer>Mega / Midwest</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer102" msdata:rowOrder="101">
    <insurer>Mercury</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer103" msdata:rowOrder="102">
    <insurer>Metropolitan</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer104" msdata:rowOrder="103">
    <insurer>Mid Century Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer105" msdata:rowOrder="104">
    <insurer>Mid-Continent Casualty</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer106" msdata:rowOrder="105">
    <insurer>Middlesex Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer107" msdata:rowOrder="106">
    <insurer>Midland National Life</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer108" msdata:rowOrder="107">
    <insurer>Mutual of New York</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer109" msdata:rowOrder="108">
    <insurer>Mutual Of Omaha</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer110" msdata:rowOrder="109">
    <insurer>National Ben Franklin Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer111" msdata:rowOrder="110">
    <insurer>National Casualty</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer112" msdata:rowOrder="111">
    <insurer>National Continental Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer113" msdata:rowOrder="112">
    <insurer>National Fire Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer114" msdata:rowOrder="113">
    <insurer>National Health Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer115" msdata:rowOrder="114">
    <insurer>National Indemnity</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer116" msdata:rowOrder="115">
    <insurer>National Union Fire Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer117" msdata:rowOrder="116">
    <insurer>Nationwide</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer118" msdata:rowOrder="117">
    <insurer>New York Life</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer119" msdata:rowOrder="118">
    <insurer>Northwestern Mutual Life</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer120" msdata:rowOrder="119">
    <insurer>Northwestern Pacific Indemnity</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer121" msdata:rowOrder="120">
    <insurer>Omni Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer122" msdata:rowOrder="121">
    <insurer>Orion Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer123" msdata:rowOrder="122">
    <insurer>Pacific Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer124" msdata:rowOrder="123">
    <insurer>Pafco General Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer125" msdata:rowOrder="124">
    <insurer>Patriot General Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer126" msdata:rowOrder="125">
    <insurer>Peak Property and Casualty Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer127" msdata:rowOrder="126">
    <insurer>PEMCO</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer128" msdata:rowOrder="127">
    <insurer>Pennsylvania life</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer129" msdata:rowOrder="128">
    <insurer>Premier</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer130" msdata:rowOrder="129">
    <insurer>Principal Financial</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer131" msdata:rowOrder="130">
    <insurer>Progressive</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer132" msdata:rowOrder="131">
    <insurer>Protective Life</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer133" msdata:rowOrder="132">
    <insurer>Prudential</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer134" msdata:rowOrder="133">
    <insurer>Reliance Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer135" msdata:rowOrder="134">
    <insurer>Republic Indemnity</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer136" msdata:rowOrder="135">
    <insurer>Response</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer137" msdata:rowOrder="136">
    <insurer>SAFECO</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer138" msdata:rowOrder="137">
    <insurer>Safeway Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer139" msdata:rowOrder="138">
    <insurer>SBLI</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer140" msdata:rowOrder="139">
    <insurer>Security Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer141" msdata:rowOrder="140">
    <insurer>Sentinel Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer142" msdata:rowOrder="141">
    <insurer>Sentry</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer143" msdata:rowOrder="142">
    <insurer>Shelter</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer144" msdata:rowOrder="143">
    <insurer>St. Paul</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer145" msdata:rowOrder="144">
    <insurer>Standard Fire Insurance Company</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer146" msdata:rowOrder="145">
    <insurer>State and County Mutual Fire Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer147" msdata:rowOrder="146">
    <insurer>State Farm</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer148" msdata:rowOrder="147">
    <insurer>State National Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer149" msdata:rowOrder="148">
    <insurer>Superior American Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer150" msdata:rowOrder="149">
    <insurer>Superior Guaranty Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer151" msdata:rowOrder="150">
    <insurer>Superior Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer152" msdata:rowOrder="151">
    <insurer>The Ahbe Group</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer153" msdata:rowOrder="152">
    <insurer>The Hartford</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer154" msdata:rowOrder="153">
    <insurer>TICO Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer155" msdata:rowOrder="154">
    <insurer>TIG Countrywide Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer156" msdata:rowOrder="155">
    <insurer>Travelers</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer157" msdata:rowOrder="156">
    <insurer>Tri-State Consumer Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer158" msdata:rowOrder="157">
    <insurer>Twin City Fire Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer159" msdata:rowOrder="158">
    <insurer>UniCare</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer160" msdata:rowOrder="159">
    <insurer>United American/Farm and Ranch</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer161" msdata:rowOrder="160">
    <insurer>United Pacific Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer162" msdata:rowOrder="161">
    <insurer>United Security</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer163" msdata:rowOrder="162">
    <insurer>United Services Automobile Association</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer164" msdata:rowOrder="163">
    <insurer>Unitrin Direct</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer165" msdata:rowOrder="164">
    <insurer>Universal Underwriters Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer166" msdata:rowOrder="165">
    <insurer>US Financial</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer167" msdata:rowOrder="166">
    <insurer>US Health Group</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer168" msdata:rowOrder="167">
    <insurer>USAA</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer169" msdata:rowOrder="168">
    <insurer>USF and G</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer170" msdata:rowOrder="169">
    <insurer>Viking Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer171" msdata:rowOrder="170">
    <insurer>Windsor Insurance</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer172" msdata:rowOrder="171">
    <insurer>Woodlands Financial Group</insurer> 
  </Insurer>
  <Insurer diffgr:id="Insurer173" msdata:rowOrder="172">
    <insurer>Zurich North America</insurer> 
  </Insurer>
 </Insurers>
</diffgr:diffgram>
</cfsavecontent>
 
<cfset rootInsurers = xmlParse(theInsurers) >
<cfset nodeInsurers = xmlSearch(rootInsurers, "//Insurers/Insurer/insurer") >
 
<cfloop index="node" array="#nodeInsurers#">
  <cfset carier=node.xmlText >
  <cfoutput>
    INSERT INTO mytable (carrier)
           VALUES('#carier#')
    <br>
  </cfoutput>
</cfloop>

Open in new window

0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LeadCoAuthor Commented:
Thanks for the solution.

I am getting a cfloop error.

Context validation error for the cfloop tag.  
The start tag must have a matching end tag. An explicit end tag can be provided by adding </cfloop>. If the body of the tag is empty, you can use the shortcut <cfloop .../>.
The CFML compiler was processing:
 I have this:
<cfsavecontent  variable="theInsurers" ><?xml version="1.0" encoding="utf-8"?>
 <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
 <Insurers>
  <Insurer diffgr:id="Insurer1" msdata:rowOrder="0">
    <insurer>(Not Listed)</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer2" msdata:rowOrder="1">
    <insurer>AAA</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer3" msdata:rowOrder="2">
    <insurer>AETNA</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer4" msdata:rowOrder="3">
    <insurer>AFLAC</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer5" msdata:rowOrder="4">
    <insurer>AIG / American General</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer6" msdata:rowOrder="5">
    <insurer>AIU Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer7" msdata:rowOrder="6">
    <insurer>Alfa Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer8" msdata:rowOrder="7">
    <insurer>All Risk</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer9" msdata:rowOrder="8">
    <insurer>Allianz</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer10" msdata:rowOrder="9">
    <insurer>Allied</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer11" msdata:rowOrder="10">
    <insurer>Allstate</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer12" msdata:rowOrder="11">
    <insurer>American Alliance Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer13" msdata:rowOrder="12">
    <insurer>American Automobile Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer14" msdata:rowOrder="13">
    <insurer>American Casualty</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer15" msdata:rowOrder="14">
    <insurer>American Deposit Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer16" msdata:rowOrder="15">
    <insurer>American Direct Business Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer17" msdata:rowOrder="16">
    <insurer>American Empire Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer18" msdata:rowOrder="17">
    <insurer>American Family</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer19" msdata:rowOrder="18">
    <insurer>American Financial</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer20" msdata:rowOrder="19">
    <insurer>American Home Assurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer21" msdata:rowOrder="20">
    <insurer>American Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer22" msdata:rowOrder="21">
    <insurer>American International Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer23" msdata:rowOrder="22">
    <insurer>American Manufacturers</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer24" msdata:rowOrder="23">
    <insurer>American Mayflower Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer25" msdata:rowOrder="24">
    <insurer>American Motorists Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer26" msdata:rowOrder="25">
    <insurer>American National</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer27" msdata:rowOrder="26">
    <insurer>American Premier Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer28" msdata:rowOrder="27">
    <insurer>American Protection Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer29" msdata:rowOrder="28">
    <insurer>American Republic</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer30" msdata:rowOrder="29">
    <insurer>American Savers Plan</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer31" msdata:rowOrder="30">
    <insurer>American Service Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer32" msdata:rowOrder="31">
    <insurer>American Skyline Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer33" msdata:rowOrder="32">
    <insurer>American Spirit Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer34" msdata:rowOrder="33">
    <insurer>American Standard Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer35" msdata:rowOrder="34">
    <insurer>Amica</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer36" msdata:rowOrder="35">
    <insurer>Anthem</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer37" msdata:rowOrder="36">
    <insurer>Arbella</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer38" msdata:rowOrder="37">
    <insurer>Associated Indemnity</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer39" msdata:rowOrder="38">
    <insurer>Assurant</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer40" msdata:rowOrder="39">
    <insurer>Atlanta Casualty</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer41" msdata:rowOrder="40">
    <insurer>Atlantic Indemnity</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer42" msdata:rowOrder="41">
    <insurer>Auto Club Insurance Company</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer43" msdata:rowOrder="42">
    <insurer>Banner Life</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer44" msdata:rowOrder="43">
    <insurer>Blue Cross / Blue Shield</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer45" msdata:rowOrder="44">
    <insurer>Cal Farm Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer46" msdata:rowOrder="45">
    <insurer>California State Automobile Association</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer47" msdata:rowOrder="46">
    <insurer>Chubb</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer48" msdata:rowOrder="47">
    <insurer>Clarendon American Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer49" msdata:rowOrder="48">
    <insurer>Clarendon National Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer50" msdata:rowOrder="49">
    <insurer>CNA</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer51" msdata:rowOrder="50">
    <insurer>Colonial Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer52" msdata:rowOrder="51">
    <insurer>Continental Casualty</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer53" msdata:rowOrder="52">
    <insurer>Continental Divide Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer54" msdata:rowOrder="53">
    <insurer>Continental Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer55" msdata:rowOrder="54">
    <insurer>Cotton States</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer56" msdata:rowOrder="55">
    <insurer>Country Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer57" msdata:rowOrder="56">
    <insurer>Dairyland Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer58" msdata:rowOrder="57">
    <insurer>Electric</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer59" msdata:rowOrder="58">
    <insurer>Erie</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer60" msdata:rowOrder="59">
    <insurer>Esurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer61" msdata:rowOrder="60">
    <insurer>Farm Bureau/Farm Family/Rural</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer62" msdata:rowOrder="61">
    <insurer>Farmers</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer63" msdata:rowOrder="62">
    <insurer>Farmers Union</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer64" msdata:rowOrder="63">
    <insurer>Firemans Fund</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer65" msdata:rowOrder="64">
    <insurer>Foremost</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer66" msdata:rowOrder="65">
    <insurer>GEICO</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer67" msdata:rowOrder="66">
    <insurer>GMAC</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer68" msdata:rowOrder="67">
    <insurer>Golden Rule</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer69" msdata:rowOrder="68">
    <insurer>Government Employees Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer70" msdata:rowOrder="69">
    <insurer>Great American</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer71" msdata:rowOrder="70">
    <insurer>Guaranty National Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer72" msdata:rowOrder="71">
    <insurer>Guardian</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer73" msdata:rowOrder="72">
    <insurer>Guideone</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer74" msdata:rowOrder="73">
    <insurer>Hanover</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer75" msdata:rowOrder="74">
    <insurer>Hartford AARP</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer76" msdata:rowOrder="75">
    <insurer>Health Net</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer77" msdata:rowOrder="76">
    <insurer>Health Plus of America</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer78" msdata:rowOrder="77">
    <insurer>HealthMarkets</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer79" msdata:rowOrder="78">
    <insurer>HealthShare America</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer80" msdata:rowOrder="79">
    <insurer>Humana</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer81" msdata:rowOrder="80">
    <insurer>IFA Auto Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer82" msdata:rowOrder="81">
    <insurer>IGF Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer83" msdata:rowOrder="82">
    <insurer>Infinity Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer84" msdata:rowOrder="83">
    <insurer>Infinity National Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer85" msdata:rowOrder="84">
    <insurer>Infinity Select Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer86" msdata:rowOrder="85">
    <insurer>Integon</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer87" msdata:rowOrder="86">
    <insurer>John Hancock</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer88" msdata:rowOrder="87">
    <insurer>Kaiser Permanente</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer89" msdata:rowOrder="88">
    <insurer>Kemper</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer90" msdata:rowOrder="89">
    <insurer>Landmark American Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer91" msdata:rowOrder="90">
    <insurer>Leader National Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer92" msdata:rowOrder="91">
    <insurer>Leader Preferred Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer93" msdata:rowOrder="92">
    <insurer>Leader Specialty Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer94" msdata:rowOrder="93">
    <insurer>Liberty Insurance Corp</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer95" msdata:rowOrder="94">
    <insurer>Liberty Mutual</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer96" msdata:rowOrder="95">
    <insurer>Liberty National</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer97" msdata:rowOrder="96">
    <insurer>Liberty Northwest Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer98" msdata:rowOrder="97">
    <insurer>Lumbermens Mutual</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer99" msdata:rowOrder="98">
    <insurer>Maryland Casualty</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer100" msdata:rowOrder="99">
    <insurer>Mass Mutual</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer101" msdata:rowOrder="100">
    <insurer>Mega / Midwest</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer102" msdata:rowOrder="101">
    <insurer>Mercury</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer103" msdata:rowOrder="102">
    <insurer>Metropolitan</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer104" msdata:rowOrder="103">
    <insurer>Mid Century Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer105" msdata:rowOrder="104">
    <insurer>Mid-Continent Casualty</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer106" msdata:rowOrder="105">
    <insurer>Middlesex Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer107" msdata:rowOrder="106">
    <insurer>Midland National Life</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer108" msdata:rowOrder="107">
    <insurer>Mutual of New York</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer109" msdata:rowOrder="108">
    <insurer>Mutual Of Omaha</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer110" msdata:rowOrder="109">
    <insurer>National Ben Franklin Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer111" msdata:rowOrder="110">
    <insurer>National Casualty</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer112" msdata:rowOrder="111">
    <insurer>National Continental Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer113" msdata:rowOrder="112">
    <insurer>National Fire Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer114" msdata:rowOrder="113">
    <insurer>National Health Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer115" msdata:rowOrder="114">
    <insurer>National Indemnity</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer116" msdata:rowOrder="115">
    <insurer>National Union Fire Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer117" msdata:rowOrder="116">
    <insurer>Nationwide</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer118" msdata:rowOrder="117">
    <insurer>New York Life</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer119" msdata:rowOrder="118">
    <insurer>Northwestern Mutual Life</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer120" msdata:rowOrder="119">
    <insurer>Northwestern Pacific Indemnity</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer121" msdata:rowOrder="120">
    <insurer>Omni Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer122" msdata:rowOrder="121">
    <insurer>Orion Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer123" msdata:rowOrder="122">
    <insurer>Pacific Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer124" msdata:rowOrder="123">
    <insurer>Pafco General Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer125" msdata:rowOrder="124">
    <insurer>Patriot General Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer126" msdata:rowOrder="125">
    <insurer>Peak Property and Casualty Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer127" msdata:rowOrder="126">
    <insurer>PEMCO</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer128" msdata:rowOrder="127">
    <insurer>Pennsylvania life</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer129" msdata:rowOrder="128">
    <insurer>Premier</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer130" msdata:rowOrder="129">
    <insurer>Principal Financial</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer131" msdata:rowOrder="130">
    <insurer>Progressive</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer132" msdata:rowOrder="131">
    <insurer>Protective Life</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer133" msdata:rowOrder="132">
    <insurer>Prudential</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer134" msdata:rowOrder="133">
    <insurer>Reliance Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer135" msdata:rowOrder="134">
    <insurer>Republic Indemnity</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer136" msdata:rowOrder="135">
    <insurer>Response</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer137" msdata:rowOrder="136">
    <insurer>SAFECO</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer138" msdata:rowOrder="137">
    <insurer>Safeway Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer139" msdata:rowOrder="138">
    <insurer>SBLI</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer140" msdata:rowOrder="139">
    <insurer>Security Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer141" msdata:rowOrder="140">
    <insurer>Sentinel Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer142" msdata:rowOrder="141">
    <insurer>Sentry</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer143" msdata:rowOrder="142">
    <insurer>Shelter</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer144" msdata:rowOrder="143">
    <insurer>St. Paul</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer145" msdata:rowOrder="144">
    <insurer>Standard Fire Insurance Company</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer146" msdata:rowOrder="145">
    <insurer>State and County Mutual Fire Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer147" msdata:rowOrder="146">
    <insurer>State Farm</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer148" msdata:rowOrder="147">
    <insurer>State National Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer149" msdata:rowOrder="148">
    <insurer>Superior American Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer150" msdata:rowOrder="149">
    <insurer>Superior Guaranty Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer151" msdata:rowOrder="150">
    <insurer>Superior Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer152" msdata:rowOrder="151">
    <insurer>The Ahbe Group</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer153" msdata:rowOrder="152">
    <insurer>The Hartford</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer154" msdata:rowOrder="153">
    <insurer>TICO Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer155" msdata:rowOrder="154">
    <insurer>TIG Countrywide Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer156" msdata:rowOrder="155">
    <insurer>Travelers</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer157" msdata:rowOrder="156">
    <insurer>Tri-State Consumer Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer158" msdata:rowOrder="157">
    <insurer>Twin City Fire Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer159" msdata:rowOrder="158">
    <insurer>UniCare</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer160" msdata:rowOrder="159">
    <insurer>United American/Farm and Ranch</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer161" msdata:rowOrder="160">
    <insurer>United Pacific Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer162" msdata:rowOrder="161">
    <insurer>United Security</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer163" msdata:rowOrder="162">
    <insurer>United Services Automobile Association</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer164" msdata:rowOrder="163">
    <insurer>Unitrin Direct</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer165" msdata:rowOrder="164">
    <insurer>Universal Underwriters Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer166" msdata:rowOrder="165">
    <insurer>US Financial</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer167" msdata:rowOrder="166">
    <insurer>US Health Group</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer168" msdata:rowOrder="167">
    <insurer>USAA</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer169" msdata:rowOrder="168">
    <insurer>USF and G</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer170" msdata:rowOrder="169">
    <insurer>Viking Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer171" msdata:rowOrder="170">
    <insurer>Windsor Insurance</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer172" msdata:rowOrder="171">
    <insurer>Woodlands Financial Group</insurer>
  </Insurer>
  <Insurer diffgr:id="Insurer173" msdata:rowOrder="172">
    <insurer>Zurich North America</insurer>
  </Insurer>
 </Insurers>
</diffgr:diffgram>
</cfsavecontent>

<cfset rootInsurers = xmlParse(theInsurers) >
<cfset nodeInsurers = xmlSearch(rootInsurers, "//Insurers/Insurer/insurer") >
 
<cfloop index="node" array="#nodeInsurers#">
  <cfset carrier=node.xmlText >
  <cfoutput>
  <cfquery datasource="dsn">
    INSERT INTO  mytable(carrier)
           VALUES('#carrier#')
           </cfquery>
  </cfoutput>
</cfloop
0
 
ZvonkoSystems architectCommented:
Look for the very last character please. It has to be this:    >
0
 
LeadCoAuthor Commented:
Thats it! Wow thats why you don't code at 4:30 Am in the morning.  Thanks!!!
0
 
LeadCoAuthor Commented:
Appreciate it!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now