Home >	Contents >	Index >

Template Tags TOC   |    Alpha TOC   |    Tag Family TOC   |    Purpose TOC   |    Annotated TOC   |    Index

---

ics:catalogmanager.selectrows

Executes a query against a given table and displays records from a table using ics:catalogmanager.

Syntax

<ics:catalogmanager>
   <ics:argument name="ftcmd" value="selectrow(s)" />
   <ics:argument name="tablename" value="tablename"/>
   [<ics:argument name="selwhere" value="keycolumnname"/>]
   [<ics:argument name="selwhat" value="keycolumnvalue"/>]
   <CSVAR name="Variables.cshttp"/>
</ics: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. You can have multiple instances of the selwhere parameter.

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 match the criteria specified by the value of the parameters. CatalogManager assigns the returned HTML to the cshttp variable.

		Home >	Contents >	Index >
	Oracle JSP Tag Reference Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.