How do I parse through this XML tree in VBScript? -


i'm trying parse through xml tree in vb script, i'm unable pull out values want. i'm pull name value (eg. chng_reqt_nb , chng_reqt_dtl_co), code have below, i'm able print out "column" , value associated each, example, below code , xml, print out below:

 column 13389 column /* notes */ 1) cr#145: new code table

i print as

 chng_reqt_nb 13389 chng_reqt_dtl_co /* notes */ 1) cr#145: new code table

could please point out i'm going wrong? below code , xml samples.

set objxmldoc = createobject("microsoft.xmldom")  objxmldoc.async = false  objxmldoc.load("result.xml")  set root = objxmldoc.documentelement  set rowlist = root.getelementsbytagname("row")  each row in rowlist      handlenode(row) next  sub handlenode(row)     each elem in row.childnodes         wscript.echo elem.tagname         wscript.echo elem.text     next end sub 
<?xml version="1.0" encoding="utf-8"?> <resultsets> <resultset xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"> <row> <column name="chng_reqt_nb">13389</column> <column name="chng_reqt_dtl_co">/* notes */ 1) cr#145: new code table</column> </row> </resultset> </resultsets>

you need value of name attribute of nodes rather node names.

change

for each elem in row.childnodes     wscript.echo elem.tagname     wscript.echo elem.text next

into

for each elem in row.childnodes     wscript.echo elem.getattribute("name")     wscript.echo elem.text next

and code want.


Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more