[BTS]XPath (001)

varCheckResult = xpath(msgPickListIdoc, "count(/*[local-name()='YMM_MWH_PICKLIST' and namespace-uri()='http://YMM_MWH_PICKLIST.V3']/*[local-name()='YMM_MWH_PICKLIST01' and namespace-uri()='']/*[local-name()='WERKS' and namespace-uri()='' and (.=1201 or .=1202 or .=2006 or .=2001 or .=2002)])");

 

Select count(*) from All_WERKS where WERKS in (1201,1202,2006,2001,2002)

posted on 2010-12-01 16:16  徐中  阅读(208)  评论(0编辑  收藏  举报

导航