Select records

Anatomy

<db:select var="var" var_count="var" var_result="var" type="num" distinct="bool" limit="(no limit)" offset="int">
    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

Description: DB:SELECT generates and executes a SQL select statement and retrieves the accordant result set of records 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 potential records	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
limit	int	Limit	db:select
offset	int	Offset	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

Anatomy of Fields

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

Attributes:

Name	Type	Description
var	var	Variable name for field list

db:table

Anatomy of Table

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

Attributes:

Name	Type	Description
alias	string	Alias name

db:join

Anatomy of Join clause

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

db:groupby

Anatomy of Group by clause

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

Attributes:

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

db:having

Anatomy of Having condition

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

db:orderby

Anatomy of Order by clause

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

Attributes:

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