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 ofN
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 isno
.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:
Home > Contents > Index > ![]()
Oracle JSP Tag Reference
Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.