Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   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 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 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, 2016, Oracle and/or its affiliates. All rights reserved.