Home >	Contents >	Index >

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

---

ics:catalogmanager.deleterows

Deletes multiple rows in a table using ics:catalogmanager.

Syntax

<ics:catalogmanager>
<ics:argument name="ftcmd" value="deleterows" />
<ics:argument name="tablename" value="table" />
<ics:argument name="primarykeyN" value="keyvalue"/>
[<ics:argument name="Delete uploaded file(s)" 
value ="yes|no"/>]
</ics:catalogmanager>   

Parameters

ftcmd (required)

Values must be set to deleterows.

tablename (required)

Name of the table containing the rows to delete.

primarykeyN (required)

Value of row's primary key. The primarykey parameter is the primary key's column name. The value of N corresponds to the row number--in the resultset--that you want to delete.

Delete uploaded file(s)(optional)

Value should be set to yes if upload files associated with row should be deleted. Default is no.

Description

The deleterows command deletes rows in a table. You can also delete uploaded files.

Error Numbers

The possible values of errno include:

Value	Description
-105	Database error.

Example

The following example deletes all rows from ExampleTable that have id=1 or id=2.

<ics:catalogmanager>
    <ics:argument name="ftcmd" value="deleterows" />
    <ics:argument name="tablename" value="ExampleTable" />
    <ics:argument name="id0" value="1"/>
    <ics:argument name="id1" value="2"/>
</ics:catalogmanager>
 

See Also

The following ics:catalogmanager commands:

ics:catalogmanager.deleterow

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