Rows

<< Click to Display Table of Contents >>

Navigation:  IWML > Data Binding > Tags >

Rows

Usage

 

=Rows(params).datasource.field:<format>

 

For example the following expression:

 

=Rows.Vendors.Name

 

Will return a list of vendor names joined by new lines:

 

Amazoon

zBay

Home Despot

 

Rows is usable in many cases, however is most commonly used to provide values for listboxes and auto completes.

 

Rows is a one way databinding and is not updatable.

 

Parameters

 

join

 

If the join parameter is specified, it will be be used instead of new line:

 

=Rows(join:,).Vendors.Name

 

Will return:

 

Amazoon,zBay,Home Despot

 

To specify a space, enclose it in parenthesis:

 

=Rows(join:(, )).Vendors.Name

 

Will return:

 

Amazoon, zBay, Home Despot

 

Order

 

Order specifies asc (ascending) or desc (descending).

 

=Rows(Order:asc).Vendors.Name

 

returns

 

Amazoon

Home Despot

zBay

 

Parameters can also be combined:

 

=Rows(join:(, ) order:asc).Vendors.Name

 

returns

 

Amazoon, Home Despot, zBay

 

Sort

 

By default if order is specified, the display field (.Name) will be used for sorting. There are cases however that it is necessary to sort on a different field. This example will return Names as before, but instead will sort by the ID field.

 

=Rows(Sort:ID Order:desc).Vendors.Name

 

Default order is ascending. To use descending order:

 

=Rows(Sort:ID Order:desc).Vendors.Name