Select rows

XML

<db:select var="var" var_count="var" var_result="var" type="num" distinct="bool" offset="int" limit="(no limit)">
    ixml
    <db:fields var="var">ixml</db:fields>
    <db:table alias="string">string</db:table>
    <db:join>ixml</db:join>
    <db:groupby var="var">ixml</db:groupby>
    <db:having>ixml</db:having>
    <db:orderby var="var">ixml</db:orderby>
</db:select>

Parents: db:connection

<db:select /> generates and executes a SQL select statement and retrieves the accordant result set from the database.

Attributes

Name	Type	Description	Defined By
var	var	Result variable name for generated SQL statement	db:select
var_count	var	Result variable name for number of results	db:select
var_result	var	Result variable name for retrieved result set	db:select
type	type	Result set type	db:select
distinct	bool	Distinct result set	db:select
offset	int	Offset	db:select
limit	int	Limit	db:select

Results

Binding	Type	Predicate
var	string	N/A
var_count	int	no-result-propagation
var_result	array	no-result-propagation

Children

db:fields

XML

<db:fields var="var">ixml</db:fields>

Attributes

Name	Type	Description
var	var	Variable name for field list

db:table

XML

<db:table alias="string">string</db:table>

Attributes

Name	Type	Description
alias	string	Alias name

db:join

XML

<db:join>ixml</db:join>

db:groupby

XML

<db:groupby var="var">ixml</db:groupby>

Attributes

Name	Type	Description
var	var	Variable name for group by field list

db:having

XML

<db:having>ixml</db:having>

db:orderby

XML

<db:orderby var="var">ixml</db:orderby>

Attributes

Name	Type	Description
var	var	Variable name for associated order by field name and type pairs