Your best bet would be to use CF, since you are familiar with it..
There is a whole lot of info on xmlSearch in the CFDOCS, if you have them
installed..
Basically it works like this:
<!--- Read XML mapping file --->
<cffile
action="read"
file="#expandPath(
"_configuration\#application.setting.version#\mapping\object-friendlyName.xm
l" )#"
variable="xmlMapping" />
<!--- Parse the XML to get an XML object --->
<cfset variables.objXMLMapping = xmlParse(
variables.xmlMapping ) />
Now you have an XML object you can query with xmlSearch or access like a
structure and arrays depending on how you created your XML file...
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com
-----Original Message-----
From: Dustin Snell [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 November 2004 9:56 AM
To: CF-Talk
Subject: RE: XML via OLEDB
Thank you for your reply. Where can I get more information on: xmlSearch,
and OPENXML?
What is the simplest way to read and modify values in XML files? Do I have
to do the parsing in Cold Fusion all myself or is there a way I can access
each item as a "property" somehow where I can just change a value?
Sorry if my questions are lame... I am new to working with XML files in CF.
-Dustin
CF MX 6.1
-----Original Message-----
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 18, 2004 3:04 PM
To: CF-Talk
Subject: RE: XML via OLEDB
Not sure what your reason are for specifically wanting an OLEDB Driver
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/ht
m/xmloledbprovider_1ar6.asp), but there are many ways (easier) to query an
XML file:
1. read it with cffile, parse it and search it with xmlSearch 2. read it
with cffile, pass it to an SP and use OPENXML to search it 3. you can store
the files in a XML database http://exist.sourceforge.net/ 4. plus many more
ways
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com
-----Original Message-----
From: Dustin Snell [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 November 2004 8:31 AM
To: CF-Talk
Subject: OT: XML via OLEDB
Sorry for the OT post. Does anyone know if it there is an OLEDB driver that
allows you to access an XML file as a database and query it?
-Dustin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184836
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
