xml - How to count the number of records/nodes in the xslt only whose value is greater than zero -

-

my xml below :

<report_entry>     <filedatetime>2016-01-05t22:45:55.692-08:00</ filedatetime>     < currentyear>2016</ currentyear>     < memnum>133034</ memnum>     < ssn>000000</ ssn>     < first_name>br</ first_name>     < last_name>g</ last_name>     < employee_status_date>2013-10-04-07:00</ employee_status_date>     < payrollresults>         < depodt>2016-01-08-08:00</ depodt>         < fsa_dep_contributions>48.08</ fsa_dep_contributions>         < fsa_limitd_contributions>0</ fsa_limitd_contributions>         < fsa_med_contributions>0</ fsa_med_contributions>     </ payrollresults> </ report_entry> < report_entry>     < filedatetime>2016-01-05t22:45:55.692-08:00</ filedatetime>     < currentyear>2016</ currentyear>     < memnum>205767</ memnum>     < ssn>777777</ ssn>     < first_name>r</ first_name>     < last_name>ks</ last_name>     < payrollresults>         < depodt>2016-01-08-08:00</ depodt>         < fsa_dep_contributions>0</ fsa_dep_contributions>         < fsa_limitd_contributions>0</ fsa_limitd_contributions>         < fsa_med_contributions>28.85</ fsa_med_contributions>     </ payrollresults> </ report_entry>

xslt producing text file , counting number of rows in output file. file in output rows produced if of contribution greater 0 above xml. have used below code outputting 3 whereas should output 2. please let me know doing worng in code.

i using :

<xsl:variable name="recordcount">   <xsl:value-of select="      count( report_data/ report_entry/ payrollresults[last()]/ fsa_dep_contributions != 0) +     count( report_data/ report_entry/ payrollresults[last()]/ fsa_limitd_contributions != 0) +     count( report_data/ report_entry/ payrollresults[last()]/ fsa_med_contributions != 0)"/>  </xsl:variable> <xsl:value-of select="substring(concat($recordcount)"/>

the reason original expressions didn't work because each expression returned boolean. count() of boolean 1.

you could've changed fsa_med_contributions != 0 fsa_med_contributions[. != 0]

you could've used starts-with(local-name(),'fsa') condense of count() calls 1.

also, instead of xsl:value-of, use select attribute when possible. eliminates need processor create new tree.

example:

<xsl:variable name="recordcount"    select="count(report_data/report_entry/payrollresults[last()]/*[starts-with(local-name(),'fsa') , . > 0])"/>

note: there's no need escape > &gt; in xslt.


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more