Unless you can email those concerns
-----Original Message----- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 3:33 PM To: CF-Talk Subject: Re: MS Access xml file and CF... 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199603 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
