Home >	Contents >	Index >

Template Tags TOC   |    Alpha TOC   |    Tag Family TOC   |    Purpose TOC   |    Annotated TOC   |    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 with url (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 of tablekey 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 the title column, the tablekey 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 of Jaws in the title column, the tablekeyvalue 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:

ics:catalogmanager.editrows

ics:catalogmanager.replacerow

ics:catalogmanager.updaterow

ics:catalogmanager.addrowtext

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