Subject: RE: [xsl] Question on storing Dates for Calendar Items From: "Tim Watts" <timw@xxxxxxx> Date: Fri, 23 Mar 2001 16:23:31 +1100 |
I like your idea of breaking the date into Day/Month/Year and xsl:sort on Year, then Month, then Day? To sort the months, a way to make this easier would be to assign each a numeric attribute <month name="Jan" value="1" /> <month name="Feb" value="2" /> <month name="Mar" value="3" /> <month name="Apr" value="4" /> <month name="May" value="5" /> <month name="Jun" value="6" /> <month name="Jul" value="7" /> <month name="Aug" value="8" /> <month name="Sep" value="9" /> <month name="Oct" value="10" /> <month name="Nov" value="11" /> <month name="Dec" value="12" /> I would be interested to see other ways of doing this, and hope you get a few posts with other methods Tim Watts -----Original Message----- From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Gollwitzer Brian Contr ESC/JS Sent: Wednesday, 21 March 2001 11:42 AM To: 'XSL-List@xxxxxxxxxxxxxxxxxxxxxx' Subject: [xsl] Question on storing Dates for Calendar Items I'm currently using ODBC and ASP to serve up calendar information in a table/list format. The table consists of two columns, Event Description and Event Date and is sorted by Event Date. The Event Date is stored in the DB as a Date Data Type. Using ASP I create the XML file and it looks like below. <?xml version='1.0'?> <calendar_items> <item> <description>Event 1</description> <date>12-Feb-01</date> </item> <item> <description>Event 2</description> <date>14-Mar-01</date> </item> </calendar_items> ----->However<--------- If I perform an xsl:sort it has no idea the information is a date and incorrectly sorts the information. --------->So<---------- What I'm wondering is 1. What is a good way to store this date information so it can be easily sorted. Would it be worth it to break the date into Day/Month/Year and xsl:sort on Year, then Month, then Day? I know I could just sort the data server-side before writing it to the XML file and xsl:for-each running through them in order knowing they are already sorted but I'd like ot know if there is another way. > Brian Gollwitzer > Joint STARS Program Office > DSN: 478-6769 / Comm (781) 377-3952 > FAX: 478-1547 / Comm (781) 377-1547 > Email: Gollwitzerb@xxxxxxxxxxxxxx > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Question on storing Dates for, Gollwitzer Brian Con | Thread | Re: [xsl] Question on storing Dates, David_Marston |
Re: [xsl] XSLT-hosting, Bill Humphries | Date | RE: [xsl] Selection Criteria in XSL, Michael Kay |
Month |