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.?