<cfif isDefined("xmlDocument.roottag.Contact")>
        some processing code here.
</cfif>

-----Original Message-----
From: Houk, Gary [mailto:[EMAIL PROTECTED]
Sent: Monday, March 21, 2005 1:42 PM
To: CF-Talk
Subject: MS Access xml file and CF...


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:199584
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to