Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   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 of ROWNUM 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 where List is the name of the list and colname 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, where attname 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 list MyList. 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 of tblname for row 3 is then displayed.

<SELECTTO FROM="SystemInfo" 
          WHAT="*" 
          LIST="SysList" />
<GOTOROW LIST="SysList" ROWNUM="3"/>
<CSVAR NAME="SysList.tblname"/>

See Also

SETROW

		Home >	Contents >	Index >
	Oracle XML Tag Reference Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.