Home > Contents > Index >
SETROW
Sets the current row in a list to the first, last, next or previous row.
Syntax
<SETROW LIST="LIST_NAME"
ACTION="ACTION_VAL"/>Parameters
LIST (required)
- Name of list.
ACTION (required)
- Directive to set the current row. Possible values are:
NEXT -
Set current row to next row in list.PREV -
Set current row to previous row in list.FIRST -
Set current row to first row in list.LAST -
Set current row to last row in list.Description
The
SETROW
tag sets the current row in a list to the first, last, next, or pervious row.The column values of the current row of a list can be obtained using the syntax,
List.colname
whereList
is the name of the list andcolname
is the name of the column in the list.
Note
In the case of StringLists, the values can be obtained by using List.Item.
You can use the following attributes to return information about the list using the syntax,
List.attname
, whereattname
can be one of the following attributes:
#numRows
Number of rows in this list#curRow
Current row in this list.#moreRows
Boolean (true/false) to indicate whether there are more rows following the current row.#numCols
Number of columns in this list.@<colname>
Only used on lists that contain resultsets. Contents of the file in the specified column if the colname begins with "url".For example,
MyList.#numRows
returns the number of rows in the listMyList
.MyList.@urlheader
retrieves the contents of the file specified by the column urlheader.The value of a list is maintained during the processing of a page request. If the list contains a resultset, the resultset is maintained independently of a list that uses it.
Error Numbers
The possible values of
errno
include:
Value Description 2 No row increment. -500 No such row. -503 No such list.Example
This example displays a value from the first three rows of "
mylist
".
<SETROW LIST="mylist" ACTION="FIRST"/>
First Row: <CSVAR NAME="ListName.val"/>
<SETROW LIST="mylist" ACTION="NEXT"/>
Second Row: <CSVAR NAME="ListName.val"/>
<SETROW LIST="mylist" ACTION="NEXT"/>
Third Row: <CSVAR NAME="ListName.val"/>
See Also
FILELIST
GOTOROW
SELECTTO
STRINGLIST
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.