This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
how do i write the asp file to run the xsl/xml files?
- To: XSL-List at mulberrytech dot com
- Subject: how do i write the asp file to run the xsl/xml files?
- From: YonitL at shopy dot co dot il
- Date: Wed, 24 May 2000 09:03:26 +0200
- Reply-To: xsl-list at mulberrytech dot com
Hello!
i'm a new xsl/xml user and i need some very argent help:
1. i'm trying to issue an asp file that will display the xsl/xml on browser
here is the code,
however this code doesn't let me change the XSLDoc why? and how can i change
it so it will allow me so?
<%@ Language=VBScript %>
<% dim sortKey sortKey = Request.QueryString ("sortBy")
Set XMLDoc = Server.CreateObject("Microsoft.XMLDOM")
Set XSLDoc = Server.CreateObject("Microsoft.XMLDOM")
dim temp XMLDoc.async = false
XMLDoc.load(server.MapPath("Data/SearchResults.xml"))
XSLDoc.async = false
if sortKey="descendingPrice" then
XSLDoc.load(server.MapPath("Styles/searchResult1.xsl"))
elseif sortKey="ascendingPrice" then
XSLDoc.load(server.MapPath("Styles/searchResult2.xsl"))
elseif sortKey="shop" then
XSLDoc.load(server.MapPath("Styles/searchResult3.xsl"))
else XSLDoc.load(server.MapPath("Styles/searchResult.xsl"))
end if
temp=XMLDoc.transformNode(XSLDoc.documentElement)
Response.Write temp %>
2. i'm trying to add a <xsl:variable ...> and it doesn't allow it why? how
can i procces it?
(i need to add a sequential number to the xsl file where i wrote HERE
line 129)
1. <?xml version="1.0" encoding="ISO-8859-8"?>
2. <HTML xmlns:xsl="http://www.w3.org/TR/WD-xsl">
3. <HEAD>
4. </HEAD>
5. <BODY>
6. <TABLE WIDTH="760" BORDER="0" CELLSPACING="0"
CELLPADDING="0" ALIGN="center">
7. <TR BGCOLOR="#6699CC">
8. <TD COLSPAN="4">
i. <DIV ALIGN="center">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#FFFFFF">
a. <B>תוצאות <xsl:apply-templates
select="search/type" />
i. <xsl:value-of select="search/type"
/>
b. </B>
2. </FONT>
ii. </DIV>
9. </TD>
10. </TR>
11. </TABLE>
12. <BR/>
13. <TABLE WIDTH="760" BORDER="0" ALIGN="center">
14. <TR>
15. <TD WIDTH="406">
i. <FONT FACE="Arial, Helvetica,
sans-serif ">
1. <B>נמצאו
a. <xsl:value-of
select="search/auctions" /> מכירות פומביות - לפרטים
2. </B>
ii. </FONT>
16. </TD>
17. <TD COLSPAN="3">
18. <DIV ALIGN="right">
i. <FONT SIZE="-1" FACE="Arial,
Helvetica, sans-serif">
1. <xsl:value-of
select="search/searchText" />
ii. </FONT>
19. </DIV>
20. </TD>
21. <TD>
i. <DIV ALIGN="right">
1. <FONT SIZE="-1" FACE="Arial,
Helvetica, sans-serif" COLOR="#336699">
a. <B>:חפשת</B>
2. </FONT>
ii. </DIV>
22. </TD>
23. </TR>
24. <TR>
25. </TR>
26. <TR>
27. <TD></TD>
28. <TD></TD>
29. <TD>
30. <DIV ALIGN="right" >
i. <FONT SIZE="-1" FACE="Arial,
Helvetica, sans-serif">מוצרים ב -
1. <xsl:value-of
select="search/inShops" />
2. חנויות
ii. </FONT>
31. </DIV>
32. </TD>
33. <TD WIDTH="5" >
i. <DIV ALIGN="right" >
1. <FONT SIZE="-1" FACE="Arial,
Helvetica, sans-serif">
a. <xsl:value-of
select="search/founded" />
2. </FONT>
ii. </DIV>
34. </TD>
35. <TD>
i. <DIV ALIGN="right">
1. <FONT SIZE="-1" FACE="Arial,
Helvetica, sans-serif" COLOR="#336699">
a. <B>: נמצאו</B>
2. </FONT>
ii. </DIV>
36. </TD>
37. </TR>
38. </TABLE>
39. <TABLE WIDTH="760" BORDER="0" CELLPADDING="0"
CELLSPACING="0" ALIGN="center">
40. <TR>
41. <TD WIDTH="406">
42. <DIV ALIGN="right">
43. </DIV>
44. </TD>
45. <TD WIDTH="66">
i. <DIV ALIGN="center">
1. <A HREF="#">
a. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
b. 76-100
c. </FONT>
2. </A>
ii. </DIV>
46. </TD>
47. <TD WIDTH="2">
i. <DIV ALIGN="center">
1. <A HREF="#">
a. <FONT COLOR="#336699">
b. </FONT>
2. </A>
3. <IMG
SRC="d:\dpz\dpzNew\images/blue.gif" WIDTH="1" height="20"/>
ii. </DIV>
48. </TD>
49. <TD WIDTH="55">
50. <DIV ALIGN="center">
i. <A HREF="#">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
2. 51-75
3. </FONT>
4. </A>
51. </DIV>
52. </TD>
53. <TD WIDTH="2">
54. <DIV ALIGN="center">
i. <A HREF="#">
1. <FONT COLOR="#336699">
2. </FONT>
ii. </A>
iii. <IMG
SRC="d:\dpz\dpzNew\images/blue.gif" WIDTH="1" height="20"/>
55. </DIV>
56. </TD>
57. <TD WIDTH="58">
58. <DIV ALIGN="center">
i. <A HREF="#">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
2. 26-50
3. </FONT>
ii. </A>
59. </DIV>
60. </TD>
61. <TD WIDTH="1">
62. <DIV ALIGN="center">
i. <IMG
SRC="d:\dpz\dpzNew\images/blue.gif" WIDTH="1" height="20"/>
63. </DIV>
64. </TD>
65. <TD WIDTH="36">
66. <DIV ALIGN="center">
i. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#FF9900">
ii. 1-25
iii. </FONT>
67. </DIV>
68. </TD>
69. <TD WIDTH="96">
i. <DIV ALIGN="right">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
a. <B>בדוק מוצרים</B>
2. </FONT>
ii. </DIV>
70. </TD>
71. </TR>
72. <TR>
73. <TD WIDTH="406">
74. <DIV ALIGN="right"></DIV>
75. </TD>
76. <TD WIDTH="66">
77. <DIV ALIGN="center">
i. <A
HREF="searchResult.asp?sortBy=saleType">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
2. :סוג מכירה
3. </FONT>
ii. </A>
78. </DIV>
79. </TD>
80. <TD WIDTH="2">
81. <DIV ALIGN="center">
i. <A HREF="#">
1. <FONT COLOR="#336699">
2. </FONT>
ii. </A>
iii. <IMG
SRC="d:\dpz\dpzNew\images/blue.gif" WIDTH="1" height="20" />
82. </DIV>
83. </TD>
84. <TD WIDTH="55">
85. <DIV ALIGN="center">
i. <A
HREF="searchResult.asp?sortBy=descendingPrice">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
a. מחיר יורד
2. </FONT>
ii. </A>
86. </DIV>
87. </TD>
88. <TD WIDTH="2">
89. <DIV ALIGN="center">
i. <IMG
SRC="d:\dpz\dpzNew\images/blue.gif" WIDTH="1" HEIGHT="20" />
90. </DIV>
91. </TD>
92. <TD WIDTH="58">
93. <DIV ALIGN="center">
i. <A
HREF="searchResult.asp?sortBy=ascendingPrice">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
a. מחיר עולה
2. </FONT>
ii. </A>
94. </DIV>
95. </TD>
96. <TD WIDTH="1">
97. <DIV ALIGN="center">
i. <IMG
SRC="d:\dpz\dpzNew\images/blue.gif" WIDTH="1" height="20" />
98. </DIV>
99. </TD>
100. <TD WIDTH="36">
101. <DIV ALIGN="center">
i. <A
HREF="searchResult.asp?sortBy=shop">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
2. חנות
3. </FONT>
ii. </A>
102. </DIV>
103. </TD>
104. <TD WIDTH="96">
i. <DIV ALIGN="right">
1. <FONT FACE="Arial, Helvetica,
sans-serif" SIZE="-1" COLOR="#336699">
a. <B>מיין תוצאות לפי</B>
2. </FONT>
ii. </DIV>
105. </TD>
106. </TR>
107. </TABLE>
108. <TABLE WIDTH="760" border="0" cellpadding="0"
cellspacing="0" align="center">
109. <xsl:for-each select="search/products/product" order-by =
"@SupplierName">
110. <TR>
111. <TD colspan="2">
112. <DIV ALIGN="right">
113. <FONT SIZE="-1">
114. <A>
115. <xsl:attribute name="HREF">
116. product.asp?pc=<xsl:value-of select="@id" />
117. </xsl:attribute>
118. <FONT FACE="Arial, Helvetica, sans-serif">
119. <xsl:value-of select="@ProductName" />
120. </FONT>
121. </A>
122. </FONT>
123. </DIV>
124. </TD>
125. <TD WIDTH="70" rowspan="4">
126. <DIV ALIGN="right"><img src="d:\dpz\dpzNew\images\frig.jpg"
/></DIV>
127. </TD>
128. <TD WIDTH="17" rowspan="4">
129. <DIV ALIGN="right"><FONT SIZE="+2"><B><FONT
COLOR="#999966">HERE</FONT></B></FONT></DIV>
130. </TD>
131. </TR><TR><TD >
132. <DIV ALIGN="right"><FONT SIZE="-1"><B><A> <xsl:attribute
name="HREF">shop.asp?sc=<xsl:value-of select="@SupplierCode"
/></xsl:attribute><FONT FACE="Arial, Helvetica, sans-serif"><xsl:value-of
select="@SupplierName" /></FONT></A></B></FONT></DIV>
133. </TD>
134. <TD >
135. <DIV ALIGN="right"><FONT SIZE="-1"><B><FONT FACE="Arial,
Helvetica, sans-serif">שם החנות</FONT></B></FONT></DIV>
136. </TD>
137. </TR>
138. <TR>
139. <TD colspan="2" height="39">
140. <DIV ALIGN="right"><FONT SIZE="-1" FACE="Arial, Helvetica,
sans-serif">
141. <xsl:value-of select="@ProductDescription" />
142. </FONT></DIV>
143. </TD>
144. </TR>
145. <TR>
146. <TD>
147. <DIV ALIGN="right"><FONT SIZE="-1" FACE="Arial, Helvetica,
sans-serif" COLOR="#FF9900"><B> ש"ח <xsl:value-of select="@Price" />
148. </B></FONT><FONT SIZE="-1" FACE="Arial, Helvetica,
sans-serif"><br/>
149. <xsl:value-of select="@GeneralDiscount" /> הנחה<br/>
150. <xsl:value-of select="@MembersDiscount" /> הנחה</FONT></DIV>
151. </TD>
152. <TD WIDTH="159" height="43">
153. <DIV ALIGN="right"><B><FONT SIZE="-1" FACE="Arial,
Helvetica, sans-serif">המחיר <BR/> מחיר מבצע <BR/> בלעדי לחברי המועדון
154. </FONT></B></DIV>
155. </TD>
156. </TR>
157. <TR><TD COLSPAN="5">
158. <HR/>
159. </TD></TR>
160. </xsl:for-each>
161. </TABLE>
162. <BR/><BR/><BR/><BR/>
163. <TABLE BORDER="0" ALIGN="RIGHT" WIDTH="750">
164. <TR>
i. <TD ALIGN="LEFT"
WIDTH="300"><B>נמצאו
1. <xsl:value-of
select="search/auctions" /> מכירות פומביות - לפרטים </B>
ii. </TD>
iii. <TD COLSPAN="3">
iv. </TD>
b. <TD ALIGN="RIGHT">
i. חפשת:
1. <xsl:value-of
select="search/searchText" />
ii. </TD>
165. </TR>
166. <TR>
a. <TD COLSPAN="4">
i. </TD>
ii. <TD ALIGN="RIGHT">
1. נמצאו
2. <xsl:value-of
select="search/founded" /> מוצרים ב -
3. <xsl:value-of
select="search/inShops" /> חנויות
iii. </TD>
167. </TR>
168. <TR>
a. <TD COLSPAN="4">
b. </TD>
i. <TD ALIGN="RIGHT">בדוק מוצרים
ii. </TD>
169. </TR>
170. <TR><TD COLSPAN="3"></TD>
i. <TD ALIGN="RIGHT">
1. <A
href="searchResult.asp?sortBy=saleType">:סוג מכירה</A>
2. <A
href="searchResult.asp?sortBy=descendingPrice">מחיר יורד</A>
3. <A
href="searchResult.asp?sortBy=ascendingPrice">מחיר עולה</A>
ii. </TD>
iii. <TD ALIGN="RIGHT">:מיין תוצאות לפי
iv. </TD>
171. </TR>
172. </TABLE>
173. <BR/><BR/><BR/><BR/><BR/><BR/><BR/>
174. <TABLE BORDER="1" ALIGN="RIGHT">
175. <xsl:for-each select="search/products/product" order-by =
"@SupplierName">
176. <TR>
a. <TD COLSPAN="3">
i. </TD>
ii. <TD ALIGN="RIGHT">
1. <B><A> <xsl:attribute
name="HREF">product.asp?pc=<xsl:value-of select="@id"
/></xsl:attribute><xsl:value-of select="@ProductName" /></A></B>
iii. </TD>
iv. <TD ROWSPAN="6">
1. <IMAGE
SRC="D:\yp\images\images\frig.jpg"/>
v. </TD>
177. </TR>
178. <TR>
a. <TD COLSPAN="2">
i. </TD>
ii. <TD ALIGN="RIGHT">
1. <A> <xsl:attribute
name="HREF">shop.asp?sc=<xsl:value-of select="@SupplierCode"
/></xsl:attribute><xsl:value-of select="@SupplierName" /></A>
iii. </TD>
iv. <TD ALIGN="RIGHT">
1. <B>שם החנות </B>
v. </TD>
179. </TR>
180. <TR>
i. <TD COLSPAN="2">
ii. </TD>
iii. <TD COLSPAN="2" ALIGN="RIGHT">
1. <xsl:value-of
select="@ProductDescription" />
iv. </TD>
181. </TR>
182. <TR>
i. <TD COLSPAN="2">
ii. </TD>
iii. <TD ALIGN="RIGHT">
1. <B><xsl:value-of select="@Price"
/></B>
iv. </TD>
v. <TD ALIGN="RIGHT">
1. <B>המחיר</B>
vi. </TD>
183. </TR>
184. <TR>
i. <TD COLSPAN="2">
ii. </TD>
iii. <TD ALIGN="RIGHT">
1. <xsl:value-of
select="@GeneralDiscount" />
iv. </TD>
v. <TD ALIGN="RIGHT">
1. <B>מחיר מבצע</B>
vi. </TD>
185. </TR>
186. <TR>
i. <TD COLSPAN="2">
ii. </TD>
iii. <TD ALIGN="RIGHT">
1. <xsl:value-of
select="@MembersDiscount" />
iv. </TD>
v. <TD ALIGN="RIGHT">
1. <B>בלעדי לחברי המועדון</B>
vi. </TD>
187. </TR>
188. <TR>
i. <TD COLSPAN="5">
1. <HR/>
ii. </TD>
189. </TR>
190. </xsl:for-each>
191. </TABLE>
192. </BODY>
193. </HTML>
3. i would like to change the sort-by in line 109 by a script (the
querystring contains a sortBy ang i'd like to change the sortBy to the
queryString)
if you need this is the xml file:
<?xml version="1.0" encoding="ISO-8859-8"?>
<search xmlns:dt="urn:schemas-microsoft-com:datatypes">
<type>חיפוש מוצר</type>
<searchText>מקררים , מקפיאים</searchText>
<founded>72</founded>
<inShops>21</inShops>
<auctions>45</auctions>
<products>
<product id="44" ProductName="מקרר אמנה"
ProductDescription="מקרר אמנה 2000 בעל מערכת הקירור 2000"
SupplierCode="12345" SupplierName="אבי אלקטרוניקה" Price="2100"
GeneralDiscount="29%" MembersDiscount="25%"/>
<product id="444" ProductName="מקרר תדיראן"
ProductDescription="מקרר תדיראן דגם 3000" SupplierCode="1234"
SupplierName="סנסור" Price="2000" GeneralDiscount="29%"
MembersDiscount="25%"/>
<product id="144" ProductName="מקרר ג'נרל אלקטריק"
ProductDescription="מקרר דגם 30000" SupplierCode="12355" SupplierName="שקם
אלקטריק" Price="2102" GeneralDiscount="29%" MembersDiscount="25%"/>
</products>
</search>
thank's,
yonit
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list