Home > Contents > Index >
Template Tags TOC | Alpha TOC | Tag Family TOC | Purpose TOC | Annotated TOC | Index
ics:catalogmanager.updaterows
Modifies field values for multiple rows in a table using
ics:catalogmanager
.Syntax
<ics:catalogmanager>
<ics:argument name="ftcmd" value="updaterows" /> <ics:argument name="tablenameN" value="table" /> [<ics:argument name="columnnameN" value="columnname"/>] [<ics:argument name="urlcolumnnameN_folder" value="folder name"/>] [<ics:argument name="columnnameN_file" value="file name"/>] [<ics:argument name="tablekeyN" value="key value"/>] [<ics:argument name="tablekeyvalueN" value="value"/>]</ics:catalogmanager>Parameters
ftcmd (required)
- Value must be set to
updaterows
.tablename (required)
- Name of the table containing rows to be updated.
columnname
N (optional)- Each column in the row to be updated.
columnname
is a table column name. The value ofN
corresponds to the row number in the resultset that you want to update.urlcolumnnameN_folder (optional)
- The syntax urlcolumnname_folderN is deprecated.
- Subfolder name to store the uploaded file. The file is then stored under the upload folder and the subfolder. The upload folder is specified in the SystemInfo table's
defdir
column. Note that you can have multiple upload columns.- Upload columns are designated by the prefix
url
. The column name in the table must begin withurl
(for example,urltext
). The argument name must include the table's column name with_folder
appended to the column name (for example,urltext_folder
).columnnameN_file (required for non-binary files)
- Name of the file you want to upload. The column name in the table must begin with
url
(for example,urltext
). The argument name must have_file
appended to the table's column name (for example,urltext_file
).
tablekey
N (optional)- Use the
tablekeyN
parameter if you want to update rows based on a value other than the primary key. The value oftablekeyN
is the column name of the column you use to perform the update. The value ofN
corresponds to the row number in the resultset that you want to update.
tablekeyvalue
N (optional)- Value in the
tablekey
columm of the row you want to update. The value ofN
corresponds to the row number in the resultset that you want to update.- This parameter is required only if the
tablekey
parameter is used.Description
The
updaterows
command modifies field values for multiple rows in a table. For fields other than URL fields, the value of the field is modified. For URL fields,updaterows
deletes the file associated with the URL field and modifies the URL field to point to the newly uploaded file.Error Numbers
The possible values of
errno
include:
Value Description -103 No such table. -104 No table definition. -105 Database error.Example
The following example updates description column for id=100 and id=101.
Original data
id description quantity 100 Apple 100 102 Orange 300 <ics:catalogmanager>
<ics:argument name="ftcmd" value="updaterow2"/>
<ics:argument name="tablename" value="ExampleTable"/>
<ics:argument name="id0" value="100"/>
<ics:argument name="description0" value="Apples"/>
<ics:argument name="id1" value="101"/>
<ics:argument name="description1" value="Oranges"/>
</ics:catalogmanager>
Changed data
id description quantity 100 Apples 100 102 Oranges 300 See Also
The following
ics:catalogmanager
commands:ics:catalogmanager.updaterows2
ics:catalogmanager.replacerows
Home > Contents > Index > ![]()
Oracle JSP Tag Reference
Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.