This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

using SelectNodes to get select data


Hi I'm stuck, wondering if anyone can help....  I'm trying to select only
Cal_Dept = to 19 data... With the way it is written below I get all data.
I'm stuck.....

Thanks in advance

PORTION OF THE ASP FILE


<% objXML.Load(Server.MapPath("Cal.xml"))  %>



<% Set objLst = objXML.documentElement.selectNodes("CalEevents")  %>

<%noOfEvents = objLst.length  %>

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<% Response.Write(noOfEvents)  %>
<P>DEPARTMENT 1 EVENTS ON FILE</P>
<% For Each Node In objLst%>
<% Response.write(Node.text & "<BR>")%>
<% Next %>


PORTION OF THE XML FILE

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata"
xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="Cal.xsd">
<CalEevents>
<Cal_Rec_Num>1</Cal_Rec_Num>
<Cal_Date>2002-02-12T00:00:00</Cal_Date>
<Cal_Desc>Sewer Commission Meeting</Cal_Desc>
<Cal_Location>Town Hall</Cal_Location>
<Cal_Start_Time>8:00 pm</Cal_Start_Time>
<Cal_End_Time>10:00 pm</Cal_End_Time>
<Cal_Notes>testing 1 2 3</Cal_Notes>
<Cal_Agenda_Page>seweragenda.htm#http://seweragenda.htm#</Cal_Agenda_Page>
<Cal_Meeting_Minutes>sewernotes.htm#http://sewernotes.htm#</Cal_Meeting_Minu
tes>
<Cal_Contact>Mr. Sewer</Cal_Contact>
<Cal_Phone>865-1211</Cal_Phone>
<Cal_Dept>19</Cal_Dept>
</CalEevents>
<CalEevents>
<Cal_Rec_Num>2</Cal_Rec_Num>
<Cal_Date>2002-02-12T00:00:00</Cal_Date>
<Cal_Desc>Sewer Commission Meeting</Cal_Desc>
<Cal_Location>Town Hall</Cal_Location>
<Cal_Start_Time>7:30 pm</Cal_Start_Time>
<Cal_End_Time>11:00 pm</Cal_End_Time>
<Cal_Notes>testing 2 3 4</Cal_Notes>
<Cal_Agenda_Page>sewersge.htm#http://sewersge.htm#</Cal_Agenda_Page>
<Cal_Meeting_Minutes>sewerhjhjh.htm#http://sewerhjhjh.htm#</Cal_Meeting_Minu
tes>
<Cal_Contact>Mr.Sewer2</Cal_Contact>
<Cal_Phone>865-1213</Cal_Phone>
<Cal_Dept>19</Cal_Dept>
</CalEevents>
<CalEevents>
<Cal_Rec_Num>3</Cal_Rec_Num>
<Cal_Date>2002-02-25T00:00:00</Cal_Date>
<Cal_Desc>Recreation Meeting</Cal_Desc>
<Cal_Location>Town Hall</Cal_Location>
<Cal_Start_Time>6:00 pm</Cal_Start_Time>
<Cal_End_Time>10:30 pm</Cal_End_Time>
<Cal_Notes>testing 5 6 7</Cal_Notes>
<Cal_Agenda_Page>recrejhjh.htm#http://recrejhjh.htm#</Cal_Agenda_Page>
<Cal_Meeting_Minutes>recgdfdfd.htm#http://recgdfdfd.htm#</Cal_Meeting_Minute
s>
<Cal_Contact>Mr.Rec</Cal_Contact>
<Cal_Phone>865-2314</Cal_Phone>
<Cal_Dept>7</Cal_Dept>
</CalEevents>
<CalEevents>
<Cal_Rec_Num>4</Cal_Rec_Num>
<Cal_Date>2002-03-04T00:00:00</Cal_Date>
<Cal_Desc>Selectmen Meeting</Cal_Desc>
<Cal_Location>Town Hall</Cal_Location>
<Cal_Start_Time>10:00 am</Cal_Start_Time>
<Cal_End_Time>12:00 pm</Cal_End_Time>
<Cal_Notes>testing 8 9 0</Cal_Notes>
<Cal_Agenda_Page>selectiuiui.htm#http://selectiuiui.htm#</Cal_Agenda_Page>
<Cal_Meeting_Minutes>selecgjhgj.htm#http://selecgjhgj.htm#</Cal_Meeting_Minu
tes>
<Cal_Contact>Select</Cal_Contact>
<Cal_Phone>865-1111</Cal_Phone>
<Cal_Dept>1</Cal_Dept>
</CalEevents>



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]