Hello, i have a 60MB xml and it has up to 5000++ xmlChildren. should i cfhttp it to fetch the xml data then, cfloop it 5000 times to insert/update into DB? Besides, it is an Access DB and i will only import some specific data instead of all data.
any suggestion of how to do it smoothly? >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
