xsl count of matching attributes returns number plus " or NaN....

I can't get this count to return a number without an empty quote at the end ( " ) or getting NaN. Does anyone know why? I've searched and don't see any other postings on this issue. I'm using VS 2008. Thanks for any and all pointers!!!

XML file:

Expand|Select|Wrap|Line Numbers

 
<?xml version="1.0" encoding="utf-8"?>

<CFF xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" FormCount="1" TotalFormCount="501" FileSubmitDate="2009-03-26">

    <Form UFI="100082841" Address1="111 PENN AVENUE" City="PITTSBURGH" State="PA" Zip="15209">

    <Individual UCI="900236487" FirstName="RACHEL">

      <Income IncomeType="8" />

    </Individual>

    <Individual UCI="900236488" FirstName="RUSSELL">

      <Income IncomeType="8" />

    </Individual>

    <Individual UCI="900236489" FirstName="REBECCA">

      <Income IncomeType="8" />

    </Individual>

    <Individual UCI="900236490" FirstName="MARY">

      <Income IncomeType="8" />

    </Individual>

  </Form>

</CFF>

I've tried this several different ways in this sample XSL stylesheet:

Expand|Select|Wrap|Line Numbers

 
<?xml version="1.0"?>

<!-- key.xsl -->

<xsl:stylesheet version="1.0"

  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
    <xsl:output method="html"/>
 
    <xsl:variable name="Test_Count1">

        <xsl:number value="count(/CFF/Form/Individual/Income[@IncomeType='1' or @IncomeType='8'])" level="any" format="01"/>"

    </xsl:variable>
 
    <xsl:variable name="Test_Count2">

        <xsl:number value="count(//CFF//Form//Individual/Income[@IncomeType=1 or @IncomeType=8]) "/>"

    </xsl:variable>
 
    <xsl:variable name="Test_Count3">

        <xsl:value-of select="count(//CFF//Form//Individual/Income[@IncomeType=1 or @IncomeType=8]) "/>"

    </xsl:variable>   
 
    <xsl:template match="/">

        <html>

            <head>

                <title>

                    <xsl:text>Count TEST </xsl:text>

                </title>

            </head>

            <body style="font-family: sans-serif;">

                <xsl:call-template name ="TEST_VARIABLES"/>

            </body>

        </html>

    </xsl:template>
 
    <xsl:template name="TEST_VARIABLES">

        <!-- TEST printing values to debug -->

        <p align="left">

            Test_Count1:  <xsl:value-of select="number($Test_Count1)"/>

            <br/>

            Test_Count2:  <xsl:value-of select="$Test_Count2"/>

            <br/>

            Test_Count3:  <xsl:number value="$Test_Count3"/>

        </p>

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

Results:

Test_Count1: NaN
Test_Count2: 4"
Test_Count3: NaN

Apr 8 '09 #1

Subscribe Post Reply

5554

jkmyoung

2,057

Expert 2GB

$Test_Count1: Due to the extra " on the end, it is a number than a string -> finally a string. You get:

Expand|Select|Wrap|Line Numbers

The processor doesn't know how to interpret 04" as a number, so throws that value.

$Test_Count3: By using <xsl:value-of> when creating your variable, you've created a result tree fragment, a set of result nodes. Again, the processor doesn't know how to convert the nodes into a number, so throws an error. Also, you have an extra quote " at the end of the value.
I would suggest using instead:

Expand|Select|Wrap|Line Numbers

 
    <xsl:variable name="Test_Count3" select="count(//CFF//Form//Individual/Income[@IncomeType=1 or @IncomeType=8]) "/>
 

Apr 8 '09 #2

ems9tech

I had an extra '' added to the end of the line without realizing it! Much thanks!!!

Apr 8 '09 #3

by: Victor | last post by:

Hi, I have some sample XML and an XSD below I have written. The XSD almost does what I want. What I need is some way of enforcing that AT LEAST TWO of the attributes "TestAttribute" are "X". ...

.NET Framework

afficher 2 count de de tables

by: vacataire testeur de site web | last post by:

Bonjour je cherche à afficher de count de tables identiques dans la forme exemple num_cli | nombre de poste | nombre de voiture 1 1 3 2 2 ...

DB2 Database

Security/Distribution Group Member.Count limit of 1000

by: Terry E Dow | last post by:

Howdy, I am having trouble with the objectCategory=group member.Count attribute. I get one of three counts, a number between 1-999, no member (does not contain member property), or 0. Using...

C# / C Sharp

Can DataTable's Select or Compute do Count(Distinct())

by: Michael Howes | last post by:

I have a single DataTable in a DataSet. It has 4 columns and i'd like to get a handful of counts of unique items in 3 of the 4 columns. Can a DataTables Select or Compute methods to COUNT DISTINCT?...

C# / C Sharp

Wrong Count(*) on an objCommand.ExecuteScalar but it is correct on "SQL Entreprise Manager" or "SQL Query Analyser"

by: Julio Allegue | last post by:

I am getting the wrong Count(*) on vb.net using the ExecuteScalar . It returns all the rows. It doesn't seem to look at the WHERE clause. At the same time, I am getting the correct count on "SQL...

Visual Basic .NET

dotlucene question: determine count of matched tokens?

by: Peter Rilling | last post by:

I am working on trying to compare "titles" from two different lists and trying to determine the most likely match. When a similar entry appears in both, the result works well, but what I need to...

C# / C Sharp

Matching nonempty sequence of '^' scanf with the "%[" specifier

by: regis | last post by:

Greetings, about scanf matching nonempty sequences using the "%" matches a nonempty sequence of anything except '-' "%" matches a nonempty sequence of anything except ']" matches a nonempty...

C / C++

SQL count not matching the results of perl script count

by: jonathan184 | last post by:

Hi I am having a problme where the results of the sql count is not matching the results of the perl script sql count. The script was working fine up till Wed last week and after that the results...

Perl

How to count huge amount of files in folder

by: MichiMichi | last post by:

My asp.net application has a directory which is filled up with over 17 files (email) a second. After a while this sums up into a huge amount of files. I usually count files with the GETFILES...

ASP.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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

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

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

xsl count of matching attributes returns number plus " or NaN....

Similar topics