Gary, You're best bet may be to setup a structure of the data you are inserting with default values for each key. Then go through each XML element and match it up with the corresponding key. That way if certain elements are omitted, you still have default values. It's not the most efficient solution, but it should prove to be the most reliable.
-Adam On Mon, 21 Mar 2005 13:42:23 -0500, Houk, Gary <[EMAIL PROTECTED]> wrote: > Hello, > > I have a user with an access database that they want to export an xml > file out of, and through cf, upload the file and have the contents > inserted into the sql server db table. No problem, I know how to do > this. The problem is that the xml elements are not consistent. For > example, if the contact field is null in one of the records, then the > xml file doesn't generate <Contact></Contact>. It drops it altogether. > So, how can this be cared for in CF? > > TIA, > > - Gary > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199602 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
