House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / XML

Inserting XML Object data by looping over it with Coldfusion

Author:
Charles Shafer
02/09/2007 10:39 AM

I am trying to insert xml data into a SQL db with Coldfusion by looping through the file. Some child elements do not exists in all records producing an error on the insert statement. Is there a way to check for the existence of a column name and if there isn't, set a default value for that column and proceed with the loop for inserting the data.?


Search xml

February 12, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29