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

---

CATALOGMANAGER.addrows

Adds multiple rows to a table using the CATLOGMANGER command.

Syntax

<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="addrows"/>
<ARGUMENT NAME="tablename" VALUE="table"/>
[<ARGUMENT NAME="columnnameN_folder" VALUE="folder name"/>]
[<ARGUMENT NAME="columnnameN_file" VALUE="file name"/>]
[<ARGUMENT NAME="columnnameN" VALUE="column name"]/>
</CATALOGMANAGER>

Parameters

ftcmd (required)

Value must be set to addrows.

tablename (required)

Table name to add rows.

columnnameN_folder (optional)

Note: The syntax columnname_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).

columnnameN (required for non-binary files)

The name of the file you want to upload. The columnname is a table column name. 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).

Error Numbers

The possible values of errno include:

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

Example

The following example uses an HTML form to add two new rows to the table named movies.

<SETVAR NAME="errno" VALUE="0" />
<CATALOGMANAGER SCOPED="GLOBAL">
   <ARGUMENT NAME="ftcmd" VALUE="addrows" />
   <ARGUMENT NAME="tablename" VALUE="movies" />
   <ARGUMENT NAME="urlcolumnname0_folder" VALUE="urlreview" />
   <ARGUMENT NAME="columnname0" VALUE="Reviewer" />
   <ARGUMENT NAME="urlcolumnname1_folder" VALUE="urlrating" />
   <ARGUMENT NAME="columnname1" VALUE="Rating" />
</CATALOGMANAGER>   
<IF COND="IsError.Variables.errno=true">
	 	 <THEN>
	 	 <!--Handle error-->
	 	 </THEN>
</IF>

The next example modifies a table called CatalogExample. The default upload column is /export/home/temp. The CatalogExample table has the following columns:

• id (the table's primary key)

• urlText

• description

• quantity

The sample form uses a CatalogManager command to add rows to the table when the user clicks the addrow button.The text files are uploaded to the upload folder and specified subfolder on the host machine.

The first records text file, FirstAddrows.txt, is put in the /export/home/temp/CatalogForm directory; the second records text file is put in the /export/home/temp/CatalogForm/Part2 directory.

<SETVAR NAME="desc1" VALUE="first record added"/>
<FORM NAME="f1"  ACTION="CatalogManager" 
                 METHOD="post" 
   <INPUT TYPE="hidden" NAME="tablename" VALUE="CatalogExample"/>
   <INPUT TYPE="hidden" NAME="id0   "VALUE="3"/> <br/>
   FIRST URL: <INPUT TYPE="text" NAME="urlText0" 
                                 VALUE="this text will be put in a file called FirstAddrows.txt"/>
      <BR/>
   FIRST DESC: <INPUT TYPE="text" NAME="description0"
                                  VALUE="Variables.desc1" 
                                  REPLACEALL="Variables.desc1"/>  
      <BR/>
   FIRST QUANTITY: <INPUT TYPE="text" NAME="quantity0" VALUE="1"/>
       <BR/>
   FIRST FILE: <INPUT TYPE="text" NAME="urlText0_file"
                                 VALUE="FirstAddrows.txt"/> <BR/>
   FIRST FOLDER: <INPUT TYPE="text" NAME="urlText0_folder" 
                                    VALUE="CatalogForm"/> <BR/>
   <INPUT TYPE="hidden" NAME="id1"
                        VALUE="4"/> 
       <BR/>
   SECOND URL: <INPUT TYPE="text" NAME="urlText1" 
                                  VALUE="The second file will be put in a file called SecondAddrows.txt"/>       
   <BR/>
   SECOND DESC: <INPUT TYPE="text" NAME="description1"
                                   VALUE="second record added"/>  
       <BR/>
   SECOND QUANTITY: <INPUT TYPE="text" NAME="quantity1"
                                       VALUE="12"/>
   <BR/>
   SECOND FILE: <INPUT TYPE="text" NAME="urlText1_file" 
                                   VALUE="SecondAddrows.txt"/> 
   <BR/>
   SECOND FOLDER: <INPUT TYPE="text" NAME="urlText1_folder"
                                     VALUE="CatalogForm/Part2"/> 
   <BR/>
   <INPUT TYPE="submit" NAME="ftcmd" 
                        VALUE="addrows"/>   
   <BR/>
</FORM>

See Also

addrow
addrowtext

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