Hi all.
I have been able to output my values from the xml (YAY!!) using xmlSearch
(Thanks Guys).
Here is my code:
<cfscript>
myxmldoc =
XmlParse("E:\domains\aawit.net\wwwroot\Microsoft-Diversity-AAWIT116obs.xml");
title = XmlSearch(myxmldoc, "/jobs/job/title");
location = XmlSearch(myxmldoc, "/jobs/job/location");
department = XmlSearch(myxmldoc, "/jobs/job/department");
referencenumber = XmlSearch(myxmldoc, "/jobs/job/referencenumber");
description = XmlSearch(myxmldoc, "/jobs/job/description");
for (i = 1; i LTE ArrayLen(title); i = i + 1)
writeoutput("<tr><td>" & title[i].XmlText & "</td><td>" &
location[i].XmlText & "</td><td>" & department[i].XmlText & "</td><td>" &
referencenumber[i].XmlText & "</td><td>" & description[i].XmlText &
"</td></tr><tr><td>" & description[i].XmlText & "</td></tr>");
</cfscript>
What I'd like to do is to be able to add these values to a table in my database
but when I try to take the above code out of CFSCRIPT and do a straight output,
it doesn't work.
Any ideas on how I can do this?
TIA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344302
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
