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

---

CATALOGMANAGER.selectrows

Executes a query against a given table and displays records from a table using the CATALOGMANAGER command.

Note errno is not set. No error is generated if the value for a particular column is invalid (for example, enter a text character into an integer type field). Valid column edits succeed, invalid column edits do not. We recommend that you check your input carefully.

Syntax

<CATALOGMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="selectrow(s)" />
   <ARGUMENT NAME="tablename" VALUE="tablename" />
   [<ARGUMENT NAME="selwhere" VALUE="keycolumnname" />]
   [<ARGUMENT NAME="selwhat" VALUE="keycolumnvalue" />]
</CATALOGMANAGER>

Parameters

ftcmd (required)

Value must be set to selectrows.

tablename (required)

Name of the table to query.

selwhere (optional)

Lists the where clause components. If the system does not find any where clause components, it attempts to build a where clause using variables that correspond to column names.

selwhat (optional)

Lists columns to select from the table. The default is * , which selects all columns.

Description

The selectrow(s) command executes a query against a given table and displays records from a table. The rows displayed matches the criteria specified by the value of the parameters. CatalogManager assigns the returned HTML to the cshttp variable.

Example

This example selects all the columns in the Reviews table.

id (primary key)	rating	title
1	R	Reservoir Dogs
2	PG	The Ice Pirates
3	PG	Kellys Heroes

<SETVAR NAME="errno" VALUE="0" />
<CATALOGMANAGER>
  <ARGUMENT NAME="ftcmd" VALUE="selectrow(s)"/>
  <ARGUMENT NAME="tablename" VALUE="Reviews"/>
</CATALOGMANAGER>
<IF COND="IsError.Variables.errno=true">
	 	 <THEN>
	 	 <!--Handle error-->
	 	 </THEN>
	 	 <ELSE>
      <CSVAR NAME="Variables.cshttp"/>
	 	 </ELSE>
</IF>

This example selects the rating and title columns in the reviews table.

<SETVAR NAME="errno" VALUE="0" />
<CATALOGMANAGER>
  <ARGUMENT NAME="ftcmd" VALUE="selectrow(s)"/>
  <ARGUMENT NAME="tablename" VALUE="Reviews"/>
  <ARGUMENT NAME="selwhere"  VALUE="id=1"/>
  <ARGUMENT NAME="selwhat"   VALUE="rating, title"/>
 </CATALOGMANAGER>
<IF COND="IsError.Variables.errno=true">
	 	 <THEN>
	 	 <!--Handle error-->
	 	 </THEN>
	 	 <ELSE>
      <CSVAR NAME="Variables.cshttp"/>     
	 	 </ELSE>
</IF>

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