Getting XML data depending on day

Hi,

Im having trouble displaying only the info I want from my xml file depending on the day or of the week.

Would be v.gratefull for any code snippets!

xml

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="ISO-8859-1"?>

<WRAP>

<DOW>

<DAY>1</DAY>

<TASK>Doctors</TASK>

<DAY>TWO</DAY>

<TASK>Walk the Dog</TASK>

</DOW>

<DOW>

<DAY>2</DAY>

<TASK>Doctors</TASK>

<DAY>TWO</DAY>

<TASK>Walk the Dog</TASK>

</DOW>

</WRAP>

xsl

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
<xsl:template match="/">

  <html>
 
  <body>

    <table>

      <xsl:for-each select="WRAP/DOW">

    <xsl:choose>

          <xsl:when test="DAY = '1'">

          <xsl:value-of select='TASK'/>

          </xsl:when>

        </xsl:choose>

      </xsl:for-each>

    </table>

  </body>

  </html>

</xsl:template>
 
</xsl:stylesheet>

but where

Expand|Select|Wrap|Line Numbers

<xsl:when test="DAY = '1'">

im trying(only way i know) is to do something like this

Expand|Select|Wrap|Line Numbers

 <script>

var current_date = new Date();

var today = current_date.getDay();

</script>

...

<xsl:when test="DAY = today">

thanks

steve

Apr 14 '08 #1

Subscribe Post Reply

1576

pronerd

392

Expert 256MB

If I follow this I think what you want for the first part is this:

Expand|Select|Wrap|Line Numbers

 
      <xsl:for-each select="//WRAP/DOW[@DAY = '1']" >

            <xsl:value-of select="@TASK" />

      </xsl:for-each>

For the second part the syntax for the compare should be like this :

Expand|Select|Wrap|Line Numbers

  
<xsl:variable name="dayOfWeek">2</xsl:variable>

...

<xsl:when test="@DAY = $dayOfWeek">

...

You will need to look up the xPath functions to see which ones will return the numeral day of the week.
http://www.w3schools.com/xpath/xpath...s.asp#datetime

Apr 15 '08 #2

stevanicus

heya,

thanks for your info...

i managed to get the following. but stuck with makeing the today variable global inorder to use it in my <when test>

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="iso-8859-1"?>
 
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

  <html>

  <body>

  <link media="all" rel="stylesheet" type="text/css" href="thecss.css" />

    <script language="JavaScript">

      var cDate = new Date();

      var today = cDate.getDay();

      <xsl:variable name="tday">today</xsl:variable>

      alert(<xsl:value-of select='$tday' />);

    </script>

  <div class="stitle">Schedule</div>

  <xsl:for-each select="SCHEDULE/DOW">

    <xsl:choose>

    <xsl:when test="DAY = $tday"> <!-- tday out of scope -->

      <div class="date">

        <xsl:value-of select="DATE" />

      </div>

      <div class="schedule">

      <xsl:for-each select="SHOW">

      <div>

        <div class="stime">

          <xsl:value-of select="STIME" /> -

        </div>

        <div class="etime">

          <xsl:value-of select="ETIME" />

        </div>

        <div class="title">

          <xsl:value-of select="TITLE" />

        </div>

        <div class="description">

          <xsl:value-of select="DESCRIPTION" />

        </div>

      <br />

      </div>

      </xsl:for-each>

      </div>

    </xsl:when>

    </xsl:choose>

    </xsl:for-each>

  </body>

  </html>

</xsl:template>

</xsl:stylesheet>

any ideas?

thanks

steve

Apr 17 '08 #3

jkmyoung

2,057

Expert 2GB

Another problem here: <xsl:variable name="tday">today</xsl:variable>
You'll just have a variable with the string "today"

Apr 18 '08 #4

jkmyoung

2,057

Expert 2GB

What are you using to process the xsl? IE? javascript of some sort? PHP?

It's easier if you can pass in a parameter to the xsl with PHP or javascript etc...

Apr 19 '08 #5

Similar topics

Some help getting started

by: PHPkemon | last post by:

Hi there, A few weeks ago I made a post and got an answer which seemed very logical. Here's part of the post: PHPkemon wrote: > I think I've figured out how to do the main things like...

PHP

XML, DTDs and getting the newspaper on the web

by: Brandons of mass destruction | last post by:

Ok, I work for a small newspaper thats looking to translate our content to the web. XML sounds like a good way to do this, but i'm a little confused. Is it possible to have <b> and <i> tags in...

.NET Framework

Getting data from memory block / pointer issues.

by: FaXiA | last post by:

Hi all, I'm working on a program that reads a structure from a file (1000 records). The file read part works great, but I'm hitting a roadblock on howto read the data from the pointer. I'm...

C / C++

Getting duplicate column error when the table is disposed in the d

by: Alpha | last post by:

I have a dataset containing a table as a data source for a list box in the windows application depending on which radio button the user selects. The table is disposed when the user clicks on other...

C# / C Sharp

Getting parent page classname?

by: darrel | last post by:

I have this structure: mypage.aspx (class = mypage) myusercontro.ascx On the mypage.aspx I can declare a variable: animal = "monkey" I can read this from the UC by simply doing this:...

ASP.NET

DataGrid control events like Sort, page, Item not getting fired...

by: Gunjan Garg | last post by:

Hello All, I am working to create a generic datagrid which accepts a datasource(ListData - This is our own datatype) and depending on the calling program customizes itself for sorting,...

ASP.NET

Getting the database specification revisited..

by: Paul H | last post by:

I am trying to get the spec for a database. The trouble is the client frequently blurts out industry jargon, speaks insanely quickly and is easily sidetracked. They are currently using around 30...

Microsoft Access / VBA

asp.net, vs2k5, getting started connecting to databases... I'm confused

by: itfetish | last post by:

I've been programming a bit in PHP and then recently learnt classic ASP for projects at work, now I'm working on another project that they want done in .net. I've got my head around web parts, that...

ASP.NET

Re: Getting info from SQL DB

by: Armin Zingler | last post by:

"Bill Schanks" <wschanks@gmail.comschrieb Try to execute lvMembers.beginupdate before filling and lvMembers.endupdate

Visual Basic .NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

Microsoft Access / VBA