Home > Contents > Index >
COPYLIST
Creates a copy of the specified list.
Syntax
<COPYLIST LIST="NewList" FROM="SomeList"/>Parameters
LIST (required)
- The list created as a result of the copy.
FROM (required)
- The source list.
Description
The
COPYLIST
tag creates a copy of the specified list. Note that this operation can affect performance, since all resultset rows are cached in RAM if the list is a query. UseIsList
, specifying the name of the new list that you copied. Note that the new list is initialized to row 1 if it is not empty.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
When using 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 thecolname
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 columnurlheader
.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 the list that uses it.
Error Numbers
The possible values of
errno
include:
Value Description -505 List copy error.Example
The following example selects all rows from the NewPortalArticle table and stores them in
PortalArticles
.PortalArticles
is copied toArticles
andheadline
from each row inArticles
is displayed.<SELECTTO FROM="NewPortalArticle" WHAT="*" LIST="PortalArticles" /> <SETVAR NAME = "errno" VALUE = "0" /> <COPYLIST LIST = "Articles" FROM= "PortalArticles" /> <IF COND="Variables.errno=0"> <THEN> <LOOP LIST="Articles"> <CSVAR NAME="Articles.headline"/> <br/> </LOOP> </THEN> </IF>
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.