Home >	Contents >	Index >

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

---

ics:catalogmanager.editrows

Modifies the fields for multiple rows in a table using ics:catalogmanager.

Syntax

<ics:catalogmanager>
<ics:argument name="ftcmd" value="editrows" />
<ics:argument name="tablename" value="table" />
<ics:argument name="primarykey" value="key"/>
[<ics:argument name="primarkeyN" value="column name"/>]
[<ics:argument name="columnnameN" value="column name"/>]
[<ics:argument name="urlcolumnname_folderN" value="folder name"/>]
[<ics:argument name="columnname_fileN" value="file name"/>]
</ics:catalogmanager>   

Parameters

ftcmd (required)

Value must be set to editrows.

tablename (required)

Name of the table containing rows to be edited.

primarykeynameN (optional)

Name of the column you want to use as the primary key. The value of N corresponds to the row number to be edited. For example, if you want to edit the values in row 0 of the table, you use the following code:

inList.setValString("id0", "1")

columnnameN (optional)

Name of the column that you want to edit. The value of N corresponds to the row number--in the resultset--that you want to edit. For example, if you want to edit the value in the comments field of row 0 of the table to read "miss it", you use the following code:

inList.setValString("comments0", "miss it")

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)

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).

Description

The editrows command modifies the fields for multiple rows 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.

errno

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.editrow

ics:catalogmanager.replacerows

ics:catalogmanager.updaterows

		Home >	Contents >	Index >
	FatWire JSP Tag Reference Copyright 2005 by FatWire Software All rights reserved.