473,326 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How would you do this: sorting/querying an XML file...

We have a home grown web site. We store page information, including a
time-stamp as to when it was last updated in a database table.

We also store the site architecture (navigation) in an XML file.

We want to create RSS feeds that show the most recent page updates for a
particular node of our site menu. For instance, HR might want an RSS feed to
list all recent HR page updates.

To do this, we need to get the HR page, all childrend of the HR page, all
children of those children, and so on.

Obviously, doing this via the DB would require some recursive queries...not
something we likely want to do.

So...I could add the timestamp info to each page node of the XML file. My
question is how would one go about grabbing and sorting the most recently
updated items from a node in the XML file?

Would XSL work by itself?

Should I grab a node via Xpath and then import all nodes as a dataset and
query the dataset?

Any other suggestions?

-Darrel
Mar 20 '07 #1
2 1105
On Mar 20, 6:55 pm, "darrel" <notr...@nowhere.comwrote:
We have a home grown web site. We store page information, including a
time-stamp as to when it was last updated in a database table.

We also store the site architecture (navigation) in an XML file.

We want to create RSS feeds that show the most recent page updates for a
particular node of our site menu. For instance, HR might want an RSS feed to
list all recent HR page updates.

To do this, we need to get the HR page, all childrend of the HR page, all
children of those children, and so on.

Obviously, doing this via the DB would require some recursive queries...not
something we likely want to do.

So...I could add the timestamp info to each page node of the XML file. My
question is how would one go about grabbing and sorting the most recently
updated items from a node in the XML file?

Would XSL work by itself?

Should I grab a node via Xpath and then import all nodes as a dataset and
query the dataset?

Any other suggestions?

-Darrel
Either try to sort it via XSL

http://www.xml.com/pub/a/2002/07/03/transform.html

or use ASP.NET, for example:

DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("my.xml"));
DataView view = new DataView(ds.Tables["item"]);
view.Sort = "...";

Mar 20 '07 #2
Either try to sort it via XSL
>
http://www.xml.com/pub/a/2002/07/03/transform.html
Exellent! That just might work!

-Darrel
Mar 21 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Lad | last post by:
Hi, I have a file of records of 4 fields each. Each field is separated by a semicolon. That is Filed1;Ffield2;Field3;Field4 But there may be also empty records such as ;;;; (only...
4
by: shank | last post by:
Is the CASE statement allowed when querying an Access database? Assuming so, what is the correct syntax? thanks SELECT OrderNo, Description, Type, Label FROM Stock WHERE Manuf = 'M' ORDER BY...
4
by: TJS | last post by:
Any examples or tips on how to add sorting to a repeater column header ?
1
by: Job Lot | last post by:
i am querying excel file as follows Dim conn As New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source='" & "C:\Temp\SSPortfolio.xls" & " '; " & _ "Extended Properties=Excel...
25
by: Dan Stromberg | last post by:
Hi folks. Python appears to have a good sort method, but when sorting array elements that are very large, and hence have very expensive compares, is there some sort of already-available sort...
7
by: Brett Romero | last post by:
I have a dataset with one table, which has four columns. All are of type INT. I need to convert this dataset into a dataview so I can sort on the last three columns. I may sort one of the three...
7
by: Cerebrus99 | last post by:
Hi all, I am confused about how to sort an XML file. I mean how to *actually* sort the data in the physical file, not how to display sorted data. I am using a large XML file as a back-end...
0
by: brian_is_online | last post by:
Hi all, I have a DataGrid which is bound to a DataView to return search results. The DataGrid headers allow sorting so when clicked I rebind the DataView with the appropriate Sort property. To...
1
by: =?Utf-8?B?YmJkb2J1ZGR5?= | last post by:
I have a grid view that pulls data from a dbf file. I set the Allow Sorting to true and I put my code in the Sorting event. The problem is that I can't get the sorting to work so I wrote some...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.