Prospective Students myxmldoc = XmlParse(cfhttp.filecontent); //myxmldoc = XmlParse(myxml); selectedElements = XmlSearch(myxmldoc, "/rss/channel/item"); xmlqry = QueryNew("pubDate, description"); //Sets a query for output for (i = 1; i LTE ArrayLen(selectedElements); i = i + 1) { QueryAddRow(xmlqry); datestring = left(selectedElements[i].pubDate.XmlText,REFind("[0-9]{4}",selectedElements[i].pubDate.XmlText)+3); datestring = right(datestring, len(datestring)-4); QuerySetCell(xmlqry,"pubDate",DateFormat(datestring, "dd mmm yyyy") ,i); QuerySetCell(xmlqry,"description",selectedElements[i].description.XmlText,i); } SELECT * FROM xmlqry ORDER BY pubDate desc

NYU Stern Undergraduate College

Prospective Students

Get the Flash Player to see this player.