This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]

Complicated count() query - thanks


Thanks to all who responded to my question!

Jarno's solution was the one I'm going with, thanks Jarno.

Which I'll echo here, in case this helps anyone else too...

  <xsl:value-of select="count(/list/student[contains(translate(name,
'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'), 'john')])"
/>

woudl give a count of all the students whose name has "john" in it
somewhere.

My mistake had been to put the path inside the translate, which now
seems obviously stupid, ie:

  <xsl:value-of select="count([contains(translate(/list/student/name,
'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'), 'john')])"
/>

I think I had ommitted the square brackets as well :(

Thanks again all

Cheers

Zak

--
====================================================================
Zak McGregor
http://www.carfolio.com - Specifications of cars online. Over 7000!
--------------------------------------------------------------------
Of course my password is the same as my pet's name.  
My macaw's name was Q47pY!3, but I change it every 90 days.
====================================================================

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]