Home > Contents > Index >
ics:catalogmanager.editrow
Modifies the fields of a row in a table using
ics:catalogmanager
.Syntax
<ics:catalogmanager>
<ics:argument name="ftcmd" value="editrow" /> <ics:argument name="tablename" value="table" /> <ics:argument name="primarykey" value="key"/> [<ics:argument name="columnname" value="column name"/>] [<ics:argument name="urlcolumnname_folder" value="folder name"/>] [<ics:argument name="columnname_file" value="file name"/>] [<ics:argument name="tablekey" value="column name"/>] [<ics:argument name="tablekeyvalue" value="some value"/>]</ics:catalogmanager>Parameters
ftcmd (required)
- Value must be set to
editrow
.
tablename (required)
- Name of the table whose row is edited.
primarykey (required)
- Value of a row's primary key. The
primarykey
parameter is the primary key's column name.
columnname (optional)
- The information in the field you are editing. The
columnname
parameter is the name of the column to be edited.
urlcolumnname_folder (optional)
- 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. 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
).
columnname_file (required for non-binary files)
- The name of the file you want to upload. The column name in the table must begin with
url
(for example,urltext
). The agrument name must have_file
appended to the table's column name (for example,urltext_file
).
tablekey (optional)
- Use the
tablekey
parameter if you want to update rows based on a value other than the primary key. The value oftablekey
is the column name of the column you use to perform the update. For example, if you want to update a table based on the value in thetitle
column, thetablekey
parameter looks as follows:
inList.setValString("tablekey", "title")tablekeyvalue (optional)
- Value in the
tablekey
columm of the row you want to update. For example, if you want to update a row with a value ofJaws
in thetitle
column, thetablekeyvalue
parameter looks as follows:
inList.setValString("tablekeyvalue", "Jaws")- This parameter is required only if the
tablekey
parameter is used.
Description
The
editrow
command modifies the fields of a row in a table. The fields in the row are modified with the new values. If a URL field is edited, the content of the associated server-side upload file is modified to contain the new value. Thus, a user can pass text to update the back end storage for a given URL column value.Error Numbers
The possible values of
errno
include:
Value Description -103 No such table. -104 No table definition. -105 Database error.See Also
The following
ics:catalogmanager
commands:
Home > Contents > Index > ![]()
Oracle JSP Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.