Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

FLUSH

Flushes a list.

Syntax

<FLUSH LIST="LIST_NAME"/>

Parameters

LIST (required)

Name of the list to flush.

Description

The FLUSH tag flushes a list. If the list contains a database resultset, FLUSH clears the resultset from the cache. If the list contains a filelist or stringlist, FLUSH frees system resources.

errno

The possible values of errno include:

Value	Description
-100	General exception.

Example

The following example selects all rows from the NewPortalArticle table, displays the headline from each row, then flushes the list. Since the list is flushed, subsequent identical queries are rerun against the database. If the list is not flushed, the cached resultset is used for subsequent identical queries against the NewPortalArticle table.

<RENAMELIST LIST = "Articles" FROM = "PortalArticles" />
<SELECTTO FROM="NewPortalArticle" WHAT="*" LIST="Articles" />
<SETVAR NAME = "errno" VALUE = "0" />
<IF COND="Variables.errno=0">
	 	 <THEN>
	 	     <LOOP LIST="Articles">
 	 	     <CSVAR NAME="Articles.headline"/> <br/>
	 	     </LOOP>
	 	 </THEN>
</IF>
<FLUSH LIST = "Articles" />

See Also

FILELIST
STRINGLIST
SELECTTO

		Home >	Contents >	Index >
	FatWire XML Tag Reference Copyright 2005,2006,2007 by FatWire Software All rights reserved.