G
Guest
Hi all,
I've come accross what I consider to be a strange issue with the XSLT Data
view in FrontPage 2003 on my WSS site.
I have an events list, listing all training events coming up.
For each record in the list there are the following fields:
Event Type (values = consultancy, good practice, MER, SLF)
Event Title
Date (this is the date of the event)
daysuntil (this is a number calculated field, using the formula
=DAYS360(Today,date) which works ok, it shows the correct number of days
until the event)
consultant_name (if no consultant is assigned the value is *None Assigned)
hold (whether the event is on hold or not)
There are other fields too, but they are not relevant for this issue.
I want to filter the list to show me all future events that are not on hold,
not good practice, are in the next 28 days, and do not have a consultant
assigned to them.
I've set up the filters as follows:
date is greater than or equal to [current date] AND
daysuntil is less than or equal to 28 AND
event type is not equal good practice AND
consultant name is equal *none assigned AND
hold equals no
This works just fine, displaying all the right events as it should.
The problem appears when I convert this to a XSLT data view in Frontpage 2003.
The XSLT view within Frontpage shows all the correct data, but when i save
the page, and view it through IE it tells me there is no data to be displayed
in this view.
I've worked through it, trying the filters one by one, and it appears the
filter causing the problem is the daysuntil is less than or equal 28. If I
remove this, it shows events matching the other filter criteria.
I want to show it in XSLT view so I can write something like "There are x
events needing consultants in the next 28 days" change font styles and use
conditional formatting to mark in red events within 7 days.
Can anybody shed some light on this as to why it shows the right data in
Frontpage design mode, but not when viewed through IE?
Hope I've explained enough, and I really hope there is someone who can help
me out with this as it is driving me nuts.
Thanks in advance for any help/guidance/words of wisdom anyone can offer,
Chris
I've come accross what I consider to be a strange issue with the XSLT Data
view in FrontPage 2003 on my WSS site.
I have an events list, listing all training events coming up.
For each record in the list there are the following fields:
Event Type (values = consultancy, good practice, MER, SLF)
Event Title
Date (this is the date of the event)
daysuntil (this is a number calculated field, using the formula
=DAYS360(Today,date) which works ok, it shows the correct number of days
until the event)
consultant_name (if no consultant is assigned the value is *None Assigned)
hold (whether the event is on hold or not)
There are other fields too, but they are not relevant for this issue.
I want to filter the list to show me all future events that are not on hold,
not good practice, are in the next 28 days, and do not have a consultant
assigned to them.
I've set up the filters as follows:
date is greater than or equal to [current date] AND
daysuntil is less than or equal to 28 AND
event type is not equal good practice AND
consultant name is equal *none assigned AND
hold equals no
This works just fine, displaying all the right events as it should.
The problem appears when I convert this to a XSLT data view in Frontpage 2003.
The XSLT view within Frontpage shows all the correct data, but when i save
the page, and view it through IE it tells me there is no data to be displayed
in this view.
I've worked through it, trying the filters one by one, and it appears the
filter causing the problem is the daysuntil is less than or equal 28. If I
remove this, it shows events matching the other filter criteria.
I want to show it in XSLT view so I can write something like "There are x
events needing consultants in the next 28 days" change font styles and use
conditional formatting to mark in red events within 7 days.
Can anybody shed some light on this as to why it shows the right data in
Frontpage design mode, but not when viewed through IE?
Hope I've explained enough, and I really hope there is someone who can help
me out with this as it is driving me nuts.
Thanks in advance for any help/guidance/words of wisdom anyone can offer,
Chris