the function of many days in a month - XSLT

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Bambe 45 posts 66 karma points

Mar 29, 2011 @ 10:36

0

the function of many days in a month

XSLT

Here have a function to calculate the months days?

e.g 2011/2 = 28 days, 2012/2 = 29 days or 2010/4 = 30 days etc...

thx alot :)

Regards,

Bambe

Copy Link
Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib

Mar 29, 2011 @ 12:00

0

Hi Bambe

I'm not sure this can be done in XSLT. I guess you would need to create an extension to return the number of days in a given month. Probably not something that is hard to do if you have the proper .NET/C# skills.

Don't know if this kind of extension exists in uComponents though.

/Jan

Copy Link

Pasang Tamang 258 posts 458 karma points

Mar 29, 2011 @ 12:17

Hi Bambe,

May be this will help you

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]>
<xsl:stylesheet 
  version="1.0" 
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
 xmlns:msxml="urn:schemas-microsoft-com:xslt"
   xmlns:GetDays="urn:GetDays"
    xmlns:umbraco.library="urn:umbraco.library" xmlns:Exslt.ExsltCommon="urn:Exslt.ExsltCommon" xmlns:Exslt.ExsltDatesAndTimes="urn:Exslt.ExsltDatesAndTimes" xmlns:Exslt.ExsltMath="urn:Exslt.ExsltMath" xmlns:Exslt.ExsltRegularExpressions="urn:Exslt.ExsltRegularExpressions" xmlns:Exslt.ExsltStrings="urn:Exslt.ExsltStrings" xmlns:Exslt.ExsltSets="urn:Exslt.ExsltSets" 
  exclude-result-prefixes="msxml umbraco.library Exslt.ExsltCommon Exslt.ExsltDatesAndTimes Exslt.ExsltMath Exslt.ExsltRegularExpressions Exslt.ExsltStrings Exslt.ExsltSets ">

<xsl:output method="xml" omit-xml-declaration="yes"/>
<xsl:param name="currentPage"/>
<xsl:template match="/">
<!-- start writing XSLT -->
<xsl:value-of select="GetDays:GetDaysCount(2010,2)"/>
</xsl:template>
<msxml:script language="C#" implements-prefix="GetDays">
    <msxml:using namespace="system" />
    public static string GetDaysCount(int year, int month)
    {
    var dayCount=DateTime.DaysInMonth(year, month);
     return dayCount.ToString();
    }
  </msxml:script>
</xsl:stylesheet>

Pnima

Copy Link

Bambe 45 posts 66 karma points

Mar 29, 2011 @ 15:28

0

Hi, Pasang

Thanks for your solution :)

Copy Link
Bambe 45 posts 66 karma points

Mar 29, 2011 @ 16:17
0
Hi, Pasang

Sorry have a problem

I use the GetDays:GetDaysCount() function and insert two variable to it like this: GetDays:GetDaysCount($year,$month)

and save then but tell something: System.OverflowException: Value was either too large or too small for an Int32

here is my code...
```
<xsl:variable name="monthend">
  <xsl:variable name="qryyear" select="umbraco.library:RequestQueryString('y')"/>
  <xsl:variable name="qrymonth" select="umbraco.library:RequestQueryString('m')"/>
  <xsl:value-of select="GetDays:GetDaysCount($qryyear,$qrymonth)"/>
</xsl:variable>
```
how can I solve it ? thx :)
Copy Link
Michael Latouche 504 posts 819 karma points MVP 3x c-trib

Mar 29, 2011 @ 16:29

0

Hi Bambe,

Did you check that your two variables are actually filled in with a value that is not empty and castable to an int? This error can happen if you pass e.g. an empty string to the method.

Cheers,

Michael.

Copy Link
Bambe 45 posts 66 karma points

Mar 29, 2011 @ 17:12

0

Hi Michael,

I'm sure here have a value

but when I press save button in xslt editor then says the error message

so how can I do :(

thx alot :)

Copy Link
Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib

Mar 29, 2011 @ 22:27

0

Hi Bambe

What happens if you simply just check "Skip error testing"? Does it fail in the frontend then or is it working?

/Jan

Copy Link
Bambe 45 posts 66 karma points

Mar 30, 2011 @ 03:34

0

Hi Jan,

it's saying 'Error parsing XSLT file: \xslt\EventList.xslt'

:(

Copy Link
Pasang Tamang 258 posts 458 karma points

Mar 30, 2011 @ 03:55
0
Hi Bambe,

Sorry I am late for your answer, just wake up and check your post. In your xslt you forgot to check either qryyear and qrymonth contains value of not. Here is solution
```
<xsl:if test="$qryyear!='' or $qrymonth!=''">
  <xsl:value-of select="GetDays:GetDaysCount($qryyear,$qrymonth)"/>
</xsl:if>
```
I've tested this in mine also and error is gone

Hope this helps you

Pnima
Copy Link
Bambe 45 posts 66 karma points

Mar 30, 2011 @ 04:17

0

Hi Pasang,

that's amazing! :P

the solution are fully solved my problem

Thank you very much :)

Regards,

Bambe :)

Copy Link
Pasang Tamang 258 posts 458 karma points

Mar 30, 2011 @ 05:28

0

You are most welocme Bambe. Glad to hear you did solved you problem.

Pnima

Copy Link
Michael Latouche 504 posts 819 karma points MVP 3x c-trib

Mar 30, 2011 @ 09:53

0

Hi Bambe,

Can you maybe mark Pasang's previous post as answer to your question? This can help other people who might have similar issues in finding a solution. Thanks!

Cheers,

Michael.

Copy Link
Bambe 45 posts 66 karma points

Mar 30, 2011 @ 10:07

0

Hi Michael,

hmm..

I had already marked the answer yesterday :P

have you seen it??

Regards,

Bambe :)

Copy Link
Michael Latouche 504 posts 819 karma points MVP 3x c-trib

Mar 30, 2011 @ 10:20

0

Woops...

Did not pay enough attention this morning apparently. I guess I need some more coffee :-)

Cheers,

Michael.

Copy Link
Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib

Mar 30, 2011 @ 14:36

0

Hi guys

I'm glad to see this issue has been resolved.

However it's not always a good idea or a best practice to use inline C# inside XSLT files. Prefferably one should make an extension, which could take the needed parameters.

Just saying this so people don't get wrong habbits. Sometimes it's at a lower scale where it does not matter that much and you really just need to be pragmatic. But once you work on a larger project something like this could hurt performance :-)

/Jan

Copy Link
is working on a reply...

Please Sign in or register to post replies