< where > 元素(The < where > Element,< where

w3pop.com :: 网络学院 :: APPML :: < where > 元素

< where > 元素

作者:w3pop.com 翻译/整理:w3pop.com 发布:2007-04-28 浏览:803 ::

The <where> element defines a fixed WHERE clause to be added to the SQL every time the application runs.
<where>元素定义了一个固定的WHERE子句，并在应用程序每次运行时将其添加到SQL查询语句中。

Example
案例

<?xml version="1.0" ?>

<appml>

<title>CUSTOMERS</title>

<database>
<connection>northwind</connection>
<sql>SELECT Companyname,ContactName,Country
FROM Customers</sql>
</database>

<filters>
<where>Country='Germany'</where> </filters>

<htmlreport />

</appml>

View the output produced by the AppML HTML List Service
查看由AppML HTML 报告服务输出的结果

View the XML source file
查看XML 源文件

< where > 元素

Example 案例

评论 (0) All

Example
案例