If the pages are data stores and not just your general site, use a
database instead (the mysql plugin).
Create a database and a table with with: id INT, date TIMESTAMP,
content TEXT, title VARCHAR(40)
and then extract them with a
[(mysql name "SELECT id,title FROM table WHERE date > now() ORDER BY
date" fmt="[[{p}&id=%id%|%title%]]")]
[if set {?id}]
[(mysql name "SELECT content FROM table WHERE id=(?id)" inserts="id={?
id}")]
[if]
The result will be instantaneous.
I can give you a step by step on setting it up if you want.
On Oct 15, 11:32 am, Martin <[email protected]> wrote:
> I know that tracking down the bugs is priority one at the moment, but
> I need an advice how to solve a sorting problem.
>
> The problem:
> - hundreds of pages
> - should be sorted chronologically on the homepage
> - in addition: pages are dated in advance (ignore if page date >
> server date)
> - cannot use timestamp or date in url (imho the easiest and fastest
> solution)
> - each page has a timestamp in data field
>
> I am afraid that double checking all data fields (compare to server
> time and sort) when opening the homepage would take too long.
> Shall I keep an info list with dates and pagenames? The downside:
> Thats another list to keep an eye on.
>
> Any ideas?
>
> Greetings, Martin
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"BoltWire" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/boltwire?hl=en
-~----------~----~----~----~------~----~------~--~---
