Get record (ZeyOS)

Anatomy

<db:get var="var" var_fields="var" entity="string" id="int">
    ixml
</db:get>

Parents: db:connection

Description: DB:GET gets a database record, specified by an entity and an ID.

Attributes

Name	Type	Description	Defined By
var	var	Result variable name	db:get
var_fields	var	Variable name for field list	db:get
entity	string	Entity	db:get
id	int	ID	db:get

Results:

Binding	Type	Predicate
var	array	no-result-propagation

Examples

Get record

<db:get var="obj" entity="contacts" id="123"/>
<output>$obj.firstname $obj.lastname</output>
<!-- Bill Gates -->

Get and set record

<db:get var="obj" entity="contacts" id="123">
  <db:field>lastname</db:field>
</db:get>

<if value1="$obj.lastname" func="=" value2="Gates">
  <set var="obj.lastname">Jobs</set>
  <set var="obj.firstname">Steve</set>
</if>

<db:set entity="contacts" id="123" var_data="obj"/>