Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   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. Use IsList , 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 where List is the name of the list and colname 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, 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 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 to Articles and headline from each row in Articles 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, 2019, Oracle and/or its affiliates. All rights reserved.