Home > Contents > Index >
GOTOROW
Sets the current row in a list to a specific row.
Syntax
<GOTOROW LIST="LIST_NAME"
ROWNUM="NUMBER"/>Parameters
LIST (required)
- Name of list.
ROWNUM (required)
- Row number to set as current row.
Description
The
GOTOROW
tag sets the current row in a list to a specific row. The system generates runtime errors if the value ofROWNUM
is not an integer. Values beyond the range of the list also yield an error.The column values of the current row 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 moves the list,
SysList
, to row 3. The value oftblname
for row 3 is then displayed.<SELECTTO FROM="SystemInfo" WHAT="*" LIST="SysList" /> <GOTOROW LIST="SysList" ROWNUM="3"/> <CSVAR NAME="SysList.tblname"/>See Also
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.