I'm using another person's library (feedToQuery) to work with my xml document
and make it into a query. I'm having trouble referencing some of the data.
Most of it is done through xmlText. But this data is in the entries scheme.
Here's the entry and the code that I use to work with it. I'm trying to get
the category information out of the "category" scheme. Oh, I'd also like to
know if there's a way of finding out the data in however many category entries
there are.
DATA:
<entry>
<id>
tag:blogger.com,1999:blog-1550840680584738668.post-851696689458182282
</id>
<published>
2008-10-29T09:49:00.002-04:00
</published>
<updated>
2008-10-29T09:56:21.122-04:00
</updated>
<category scheme='http://www.blogger.com/atom/ns#' term='What
are you doing?'/>
<category scheme='http://www.blogger.com/atom/ns#' term='Health
in the News'/>
<title type='text'>
Family Election Guide with Dr. Elaine Anderson
</title>
</entry>
Here's the part of the code that I'm using to currently reference xml text (and
put it into a created db) which isn't working to grab the data out of category
scheme:
if (structKeyExists(parsed["feed"].XMLChildren[index], "category"))
querySetCell(retQuery, "category",
parsed["feed"].XMLChildren[index].category.XMLText, rows);
If there's multiple categories, I'd like it to combine them with a delimiter
and put them into one db cell.
thanks in advance about whatever learning I get.
daniel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314669
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
