以下是xml文件:<job> <jobitem>
<name>发行助理</name><en_name>dispatch assistant</en_name><jobid>4809</jobid><type>0</type>
</jobitem>
<jobitem>
<name>其它相关职位</name><en_name>other</en_name><jobid>4840</jobid><type>0</type>
</jobitem>
</job>如果我现在得到了<jobid>的值,怎样通过它得到<name>的值呢,请各位高手指点!
<name>发行助理</name><en_name>dispatch assistant</en_name><jobid>4809</jobid><type>0</type>
</jobitem>
<jobitem>
<name>其它相关职位</name><en_name>other</en_name><jobid>4840</jobid><type>0</type>
</jobitem>
</job>如果我现在得到了<jobid>的值,怎样通过它得到<name>的值呢,请各位高手指点!
<name>发行助理</name><en_name>dispatch assistant</en_name><jobid>4809</jobid><type>0</type>
</jobitem>
<jobitem>
<name>其它相关职位</name><en_name>other</en_name><jobid>4840</jobid><type>0</type>
</jobitem>
</job>set conn = server.CreateObject("adodb.connection")
conn.Open "provider=sqloledb.1;data source=.;initial catalog=job20071008;user id=sa;pwd=;"
sql="select top 10 selectedjob1,selectedjob2,selectedjob3,jingyan,zhuanye from [Person]"
Set myrecord=server.createobject("adodb.recordset")
myrecord.Open sql,conn,1,1
set oXMLDOM=server.CreateObject ("Microsoft.XMLDOM")
oXMLDOM.load(Server.MapPath("jobs.xml"))我现在得到了myrecord("selectedjob1")与<jobid>的值相对应,怎样通过它得到<name>的值呢,请各位高手指点!我是个xml新手,遍历这块不会写,麻烦高手写一下代码
oXMLDOM.async = False
oXMLDOM.load(Server.MapPath("jobs.xml"))
set oName = oXMLDOM.selectSingleNode("//job/jobitem[jobid='" & rs("selectedjob1") & "']/name")
set text = oName.text