顺便问个问题.
<TR style="HEIGHT: 20pt; mso-height-source: userset">
<TD class=xl687961 style="BORDER-TOP: medium none; HEIGHT: 20pt">姓名</TD>
<TD class=xl647961 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"><LABEL id=lbl_F_582cba39_fcd0_4672_9e3a_46ebce718de2></LABEL><INPUT class=input id=F_582cba39_fcd0_4672_9e3a_46ebce718de2 onkeydown="if(event.keyCode==13) event.keyCode=9;" onblur=CheckValue(this); style="WIDTH: 150px" onfocus=boxOnFocus(this); readOnly maxLength=30 value=史佑琼 isrequired="1" biztype="1" fieldtype="1"></TD>
<TD class=xl687961 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">编号</TD>
<TD class=xl647961 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"><LABEL id=lbl_F_ef781613_af56_4e75_9211_de9db616f76a></LABEL><INPUT class=input id=F_ef781613_af56_4e75_9211_de9db616f76a onkeydown="if(event.keyCode==13) event.keyCode=9;" onblur=CheckValue(this); style="WIDTH: 150px" onfocus=boxOnFocus(this); maxLength=60 isrequired="1" biztype="1" fieldtype="1"></TD></TR>
我怎么上面这段html的语句查询出来,并结果为:
姓名 编号
史佑琼 null
<TR style="HEIGHT: 20pt; mso-height-source: userset">
<TD class=xl687961 style="BORDER-TOP: medium none; HEIGHT: 20pt">姓名</TD>
<TD class=xl647961 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"><LABEL id=lbl_F_582cba39_fcd0_4672_9e3a_46ebce718de2></LABEL><INPUT class=input id=F_582cba39_fcd0_4672_9e3a_46ebce718de2 onkeydown="if(event.keyCode==13) event.keyCode=9;" onblur=CheckValue(this); style="WIDTH: 150px" onfocus=boxOnFocus(this); readOnly maxLength=30 value=史佑琼 isrequired="1" biztype="1" fieldtype="1"></TD>
<TD class=xl687961 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">编号</TD>
<TD class=xl647961 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"><LABEL id=lbl_F_ef781613_af56_4e75_9211_de9db616f76a></LABEL><INPUT class=input id=F_ef781613_af56_4e75_9211_de9db616f76a onkeydown="if(event.keyCode==13) event.keyCode=9;" onblur=CheckValue(this); style="WIDTH: 150px" onfocus=boxOnFocus(this); maxLength=60 isrequired="1" biztype="1" fieldtype="1"></TD></TR>
我怎么上面这段html的语句查询出来,并结果为:
姓名 编号
史佑琼 null
Select * From (
Select xmlquery('
for $name in /root/name
order by $高血压分级
return $高血压分级'
passing 专案信息 Returning content).getstringval() As 分级
From 个人专案) a
Where a.分级 Is Not Null
可以用xmlquery否?