PDA

Click to See Complete Forum and Search --> : Please help me.How to sort data in xml with asp ?

thuthuy
09-25-2007, 08:19 PM
Hi all. I have a small website site news with asp use database xml.
How to sort the news by ID ?
----------------------------------------------------------------
here is the news.asp file
----------------------------------------------------------------
<%
dim xmlpath
xmlpath = server.MapPath("xml.xml")

dim objXML
set objXML = server.CreateObject("Microsoft.FreeThreadedXMLDOM")

objXML.Load(xmlpath)
set xmlcontents = objXML.DocumentElement.selectSingleNode("contents")
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Hỗ trợ ra quyết định xử phạt </title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="1" bordercolor="#F4F7F7">
<tr>
<td colspan="2"><div align="left"></div></td>
</tr>
<%
for i = 0 to xmlcontents.ChildNodes.length - 1
set xmlcontent = xmlcontents.ChildNodes.item(i)
'ascending = True
%>
<tr valign="top">
<td colspan="2"> <img src="images/arrow.gif" width="15" height="10"> <a href="detail.asp?id=<%= i+1%>">
<%= xmlcontent.ChildNodes.item(1).text%>
</a> </td>
</tr>
<% if xmlcontent.ChildNodes.item(4).text ="" then %>
<tr>
<td colspan="2" valign="top"> <font size="2">
<%= xmlcontent.ChildNodes.item(2).text%>
</font> </td>
</tr>
<% else %>
<tr>
<td width="16%" valign="top"> <IMG style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" height=88 src="<%= xmlcontent.ChildNodes.item(4).text%>" width=115>
</td>
<td width="84%" valign="top"> <font size="2">
<%= xmlcontent.ChildNodes.item(2).text%>
</font> </td>
</tr>
<% end if %>
<% next %>
<tr valign="top">
<td colspan="2"><div align="right">
<hr align="right" width="50%">
</div></td>
</tr>
</table>
</body>
</html>
----------------------------------------------------------------
here is xml.xml file:
----------------------------------------------------------------
- <aspxml>
- <contents>
- <Content>
<ID>5</ID>
<title>Tạm giam nguyên Phó Chủ nhiệm VP ChÃ*nh phủ</title>
<trichdan>Trich dan 1</trichdan>
<details>Detail the news 1</details>
<hinhminhhoa>images/hanhchinh.jpg</hinhminhhoa>
</Content>

- <Content>
<ID>5</ID>
<title>Tạm giam nguyên Phó Chủ nhiệm VP ChÃ*nh phủ</title>
<trichdan>Trich dan 1</trichdan>
<details>Detail the news 1</details>
<hinhminhhoa>images/hanhchinh.jpg</hinhminhhoa>
</Content>
- </contents>
- </aspxml>
----------------------------------------------------------------
I am waiting for your help. Thank you very much