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

---

CATALOGMANAGER.addrowtext

Adds a row to a table using the CATALOGMANAGER command.

Syntax

<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="addrowtext"/>
<ARGUMENT NAME="tablename" VALUE="table"/>
[<ARGUMENT NAME="urlcolumnname_folder" VALUE="folder name"]/>
[<ARGUMENT NAME="columnname_file" VALUE="file name"]/>
[<ARGUMENT NAME="columnname" VALUE="column name"]/>
</CATALOGMANAGER>   

Parameters

ftcmd (required)

Value must be set to addrowtext.

tablename (required)

Name of the table to which to add text.

urlcolumnname_folder (optional)

For every file upload column (column name starts with url), you can use a parameter named urlcolumnname_folder to store the file in a subfolder under the default upload folder for the table.

columnname_file (optional)

Used to specify a name for a file that is created on the server. If not provided, the system generates a file name and gives it the extension .txt.

columnname (optional)

Value of each column in the row to be added. The columnname is a table column name.

Description

The addrowtext command adds a row to a table. If the table contains an upload column, instead of requiring a file upload, text can be uploaded and Sites creates a file to store the uploaded text.

Error Numbers

The possible values of errno include:

Value	Description
-103	No such table.
-104	No table definition.
-105	Database error.

Example

This example adds a row to the reviews table.

<SETVAR NAME="errno" VALUE="0" />
<CATALOGMANAGER SCOPED="GLOBAL">
   <ARGUMENT NAME="ftcmd" VALUE="addrowtext" />
   <ARGUMENT NAME="tablename" 
             VALUE="reviews" />
   <ARGUMENT NAME="urlcolumnname_folder" 
             VALUE="urlreview" />
   <ARGUMENT NAME="columnname_file" 
             VALUE="Review" />
   <ARGUMENT NAME="columnname" VALUE="Reviewer" />
</CATALOGMANAGER>   
<IF COND="IsError.Variables.errno=true">
	 	 <THEN>
	 	 <!--Handle error-->
	 	 </THEN>
</IF>

See Also

The following CATALOGMANAGER commands:

addrow
addrowtext

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