📄 xquery_flwor.asp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>XQuery FLWOR Expressions</title>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />
<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<link rel="stylesheet" type="text/css" href="../stdtheme.css" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</head>
<body>
<a name="top"></a>
<table cellpadding="0" cellspacing="0" width="100%" bgcolor="#808080">
<tr>
<td width="234" valign="top">
<a href="../default.htm"><img src="../images/w3default80.jpg" border="0" alt="W3Schools" /></a>
</td>
<th valign="middle" align="left" class="right">
<iframe style="background-color:#808080" src="../banners/bannerframe.asp@adpartner=xmlspy" height="90" width="728"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<br /></th>
</tr>
</table>
<table style="margin-left:1px" width="800px" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="137" class="content" valign="top"><br />
<a class="left" href="../default.asp" target="_top">
<img src="../images/homeicon.gif" border="0" alt="home" /></a>
<a class="left" href="../default.asp" target="_top">
<b>HOME</b></a>
<br /><br />
<b>XQuery Basic</b><br />
<a class="left" target="_top" href="default.asp" >XQuery HOME</a><br />
<a class="left" target="_top" href="xquery_intro.asp" >XQuery Intro</a><br />
<a class="left" target="_top" href="xquery_example.asp" >XQuery Example</a><br />
<a class="left" target="_top" href="xquery_flwor.asp" style='font-weight:bold;'>XQuery FLWOR</a><br />
<a class="left" target="_top" href="xquery_flwor_html.asp" >XQuery HTML</a><br />
<a class="left" target="_top" href="xquery_terms.asp" >XQuery Terms</a><br />
<a class="left" target="_top" href="xquery_syntax.asp" >XQuery Syntax</a><br />
<br />
<b>XQuery Advanced</b><br />
<a class="left" target="_top" href="xquery_add.asp" >XQuery Add</a><br />
<a class="left" target="_top" href="xquery_select.asp" >XQuery Select</a><br />
<a class="left" target="_top" href="xquery_functions.asp" >XQuery Functions</a><br />
<a class="left" target="_top" href="xquery_summary.asp" >XQuery Summary</a><br />
<br />
<b>XQuery Reference</b><br />
<a class="left" target="_top" href="xquery_reference.asp" >XQuery Reference</a><br />
<br />
<b>Selected Reading</b><br />
<a class="left" target="_top" href="../browsers/browsers_stats.asp">Web Statistics</a><br />
<a class="left" target="_top" href="../site/site_glossary.asp">Web Glossary</a><br />
<a class="left" target="_top" href="../hosting/default.asp">Web Hosting</a><br />
<a class="left" target="_top" href="../quality/default.asp">Web Quality</a><br /><br />
<a class="left" target="_top" href="../forum/default.asp">W3Schools Forum</a><br /><br />
<a class="left" target="_top" href="../about/about_helping.asp">Helping W3Schools</a><br /><br />
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*LeftLinkUnit*/
google_ad_slot = "4854527104";
google_ad_width = 120;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td>
<td valign="top">
<table style="border: 1px solid gray" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="5" cellspacing="0">
<tr>
<td>
<h1>XQuery FLWOR Expressions</h1>
<a href="xquery_example.asp"><img alt="previous" border="0" src="../images/btn_previous.gif" /></a>
<a href="xquery_flwor_html.asp"><img alt="next" border="0" src="../images/btn_next.gif" width="100" height="20" /></a>
<hr />
<h2>The XML Example Document</h2>
<p>We will use the "books.xml" document in the examples below (same
XML file as in the previous chapter).</p>
<p><a target="_blank" href="books.xml">View the "books.xml" file in your browser</a>.</p>
<hr />
<h2>How to Select Nodes From "books.xml" With FLWOR</h2>
<p>Look at the following path expression:</p>
<table width="100%" border="1" class="ex" cellspacing="0" id="table1">
<tr>
<td>
<pre>doc("books.xml")/bookstore/book[price>30]/title</pre>
</td>
</tr>
</table>
<p>The expression above will select all the title elements under the book
elements that are under the bookstore element that have a price element with a
value that is higher than 30.</p>
<p>The following FLWOR expression will select exactly the same as the path
expression above:</p>
<table width="100%" border="1" class="ex" cellspacing="0" id="table2">
<tr>
<td>
<pre>for $x in doc("books.xml")/bookstore/book
where $x/price>30
return $x/title</pre>
</td>
</tr>
</table>
<p>The result will be:</p>
<table width="100%" border="1" class="ex" cellspacing="0" id="table3">
<tr>
<td>
<pre><title lang="en">XQuery Kick Start</title>
<title lang="en">Learning XML</title></pre>
</td>
</tr>
</table>
<p>With FLWOR you can sort the result:</p>
<table width="100%" border="1" class="ex" cellspacing="0" id="table4">
<tr>
<td>
<pre>for $x in doc("books.xml")/bookstore/book
where $x/price>30
order by $x/title
return $x/title</pre>
</td>
</tr>
</table>
<p>FLWOR is an acronym for "For, Let, Where, Order by, Return".</p>
<p>The <b>for</b> clause selects all book elements under the bookstore
element into a variable called $x.</p>
<p>The <b>where</b> clause selects only book elements with a price
element with a value greater than 30.</p>
<p>The <b>order by</b> clause defines the sort-order. Will be sort by
the title element.</p>
<p>The <b>return</b> clause specifies what should be returned. Here it returns the title
elements.</p>
<p>The result of the XQuery expression above will be:</p>
<table width="100%" border="1" class="ex" cellspacing="0" id="table5">
<tr>
<td>
<pre><title lang="en">Learning XML</title>
<title lang="en">XQuery Kick Start</title></pre>
</td>
</tr>
</table>
<br />
<hr />
<a href="xquery_example.asp"><img alt="previous" border="0" src="../images/btn_previous.gif" width="100" height="20" /></a>
<a href="xquery_flwor_html.asp"><img alt="next" border="0" src="../images/btn_next.gif" width="100" height="20" /></a>
<br />
<hr />
<!-- **** SPOTLIGHTS 1 **** -->
<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="3" align="left" valign="top">
<img src="../images/stylusstudio_01.gif" width="118" height="470" alt="" align="top" /></td>
<td colspan="2" align="left" valign="top">
<img src="../images/stylusstudio_02.gif" width="376" height="154" alt="" /></td>
<td rowspan="3" align="left" valign="top">
<img src="../images/stylusstudio_03.gif" width="6" height="470" alt="" /></td>
</tr>
<tr>
<td colspan="2" bgcolor="#e9eaec">
<table width="376" border="0" cellspacing="5" cellpadding="0">
<tr align="left" valign="top">
<td><strong>Learn XML with Stylus Studio XML Editor – Free Download<br /></strong><br />
Stylus Studio provides tools for editing and debugging
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml/editor/default.htm" target="_blank">XML</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/xslt.html" target="_blank">XSLT</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml_schema.html" target="_blank">XML Schema</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/dtd.html" target="_blank">DTD</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/xquery.html" target="_blank">XQuery</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/web_services.html" target="_blank">Web Services</a>,and more!<br /><br />
<strong>Using Stylus Studio XML Tools You Can:<br /></strong>
<ul>
<li type="disc" style="margin-bottom:5px">
<a style="color:#1675b2" href="../../www.stylusstudio.com/convert_to_xml.html" target="_blank">
Convert any File to XML</a> (CSV, Tab-separated, HTML, EDI & more.)</li>
<li type="disc" style="margin-bottom:5px">
<a style="color:#1675b2" href="../../www.stylusstudio.com/videos/ddxqdemo/datadirectxquery.html" target="_blank">
Access and Update any database as XML</a> (SQL Server, Oracle, MySQL & more.)</li>
<li type="disc" style="margin-bottom:5px">
View, Edit, Parse, and Validate XML files.</li>
<li type="disc">
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml/publishing.html" target="_blank">
Publish your data</a>, including <a style="color:#1675b2" href="../../www.stylusstudio.com/videos/publisher1/publisher1.html" target="_blank">XML to HTML</a>
or <a style="color:#1675b2" href="../../www.stylusstudio.com/xml_to_pdf.html" target="_blank">XML to PDF</a></li>
</ul>
<p>See why millions use Stylus Studio as their preferred XML tool. Download a
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml_download.html" target="_blank">FREE TRIAL</a>
or watch an online <a style="color:#1675b2" href="../../www.stylusstudio.com/xml_videos.html" target="_blank">VIDEO DEMO</a> today!</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top">
<a href="../../www.stylusstudio.com/xml_download.html" target="_blank">
<img name="stylusstudio_05" src="../images/stylusstudio_05.gif" width="159" height="35" align="top" border="0" alt=""
onmouseover="this.src='../images/stylusstudio_05-over.gif'" onmouseout="this.src='../images/stylusstudio_05.gif'" />
</a></td>
<td align="left" valign="top">
<a href="../../www.stylusstudio.com/xml_videos.html" target="_blank">
<img name="stylusstudio_06" src="../images/stylusstudio_06.gif" width="217" height="35" align="top" border="0" alt=""
onmouseover="this.src='../images/stylusstudio_06-over.gif'" onmouseout="this.src='../images/stylusstudio_06.gif'" /></a></td>
</tr>
</table>
<hr />
<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />
<center>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*imgtxt*/
google_ad_slot = "8606855891";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</center>
<hr />
<!-- **** END SPOTLIGHTS **** -->
</td></tr>
<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='xquery_flwor.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>
</table>
</td></tr>
</table>
</td>
<td width="145" align="center" valign="top">
<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=xquery" height="1500" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>
</td>
</tr></table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -