Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

---

CATALOGMANAGER.updaterows2

Modifies field values or clears columns for multiple rows in a table using the CATALOGMANAGER command.

Syntax

<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="updaterows2" />
<ARGUMENT NAME="tablename" VALUE="table" />
<ARGUMENT NAME="primarykeyN" VALUE="key"/>
<ARGUMENT NAME="ftcmd" VALUE="updaterows" />
<ARGUMENT NAME="tablenameN" VALUE="table" />
[<ARGUMENT NAME="primarykeyN" VALUE="primary key value"/>]
[<ARGUMENT NAME="columnnameN" VALUE="columnname"/>]
[<ARGUMENT NAME="urlcolumnnameN_folder" VALUE="folder name"/>]
[<ARGUMENT NAME="columnnameN_file" VALUE="columnname"/>]
[<ARGUMENT NAME="tablekeyN" VALUE="key value"/>]
[<ARGUMENT NAME="tablekeyvalueN" VALUE="some value"/>]
[<ARGUMENT NAME="updaterowNullColumns" VALUE="column1, column2"/>]
</CATALOGMANAGER>   

Parameters

ftcmd (required)

Value must be set to "updaterows2".

tablename (required)

Name of the table containing rows to be updated.

primarykeyN (required)

Value of row's primary key. The primarykey parameter is the primary key's column name. The value of N corresponds to the row number--in the resultset--that you want to update.

columnnameN (optional)

Each column in the row to be replaced. columnname is a table column name. The value of N corresponds to the row number--in the resultset--that you want to update.

urlcolumnnameN_folder (optional)

The syntax urlcolumnname_folderN is deprecated.

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

columnnameN_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 argument name must have _file appended to the table's column name (for example, urltext_file).

tablekeyN (optional)

Use the tablekeyN parameter if you want to update rows based on a value other than the primary key. The value of tablekeyN is the column name of the column you use to perform the update. The value of N corresponds to the row number--in the resultset--that you want to update.

tablekeyvalueN (optional)

Value in the tablekey column of the row you want to update. The value of N corresponds to the row number--in the resultset--that you want to update.

This parameter is required only if the tablekey parameter is used.

updaterowNullColumns (optional)

A comma-separated list of columns that are to be cleared if no data is supplied when the user submits a form. Note that If this list is supplied, other columns are ignored and are not cleared.

Description

Like updaterows, the updaterow2 command modifies field values for multiple rows in a table; however, in contrast to updaterows, which does not allow you to clear columns, updaterows2 allows you to clear columns if there is no value for the specified column (for example, if there is no related field in the form). For url fields, updaterows2 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

This example updates the rows with godzilla and titanic in the movies table, and changes the values of the comments column to one star and three stars, respectively.

<SETVAR NAME="errno" VALUE="0" />
<CATALOGMANAGER SCOPED="GLOBAL">
  <ARGUMENT NAME="ftcmd" VALUE="updaterows2" />
  <ARGUMENT NAME="tablename" VALUE="movies" />
  <ARGUMENT NAME="id0" VALUE="1234" />
  <ARGUMENT NAME="title0" VALUE="godzilla" />
  <ARGUMENT NAME="comments0" VALUE="one star" />
  <ARGUMENT NAME="id1" VALUE="1235" />
  <ARGUMENT NAME="title1" VALUE="titanic" />
  <ARGUMENT NAME="comments1" VALUE="three stars" />
</CATALOGMANAGER> 
<IF COND="Variables.errno=0">
	 	 <THEN>
	 	 Update successful.
	 	 </THEN>
	 	 <ELSE>
	 	 <CSVAR NAME="Update failed.  See errno Variables.errno for more information."/>
	 	 </ELSE>
</IF>

See Also

addrows
replacerows
updaterows

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