Home > Contents > Index >
CATALOGMANAGER.replacerow
Replaces an existing row in a table on a remote server by first deleting it, and then inserting the specified information into the row using the
CATALOGMANAGER
command.Syntax
<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="replacerow" /> <ARGUMENT NAME="tablename" VALUE="table" /> [<ARGUMENT NAME="columnname" VALUE="column name"/>] [<ARGUMENT NAME="urlcolumnname_folder" VALUE="folder name"/>] [<ARGUMENT NAME="columnname_file" VALUE="file name"/>]</CATALOGMANAGER>Parameters
ftcmd
(required)- Value must be set to
replacerow
.
tablename (required)
- Name of the table that contains the row to replace.
primarykey (optional)
- Value of row's primary key. The
primarykey
parameter is the primary key's column name.
columnname (optional)
- Each column in the row to be replaced.
columnname
is a table column name.
urlcolumnname_folder (optional)
- 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 withurl
(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 argument name must have_file
appended to the table's column name (for example,urltext_file
).Description
The
replacerow
command replaces an existing row in a table on a remote server by first deleting it, and then inserting the specified information into the row. This command should be used to clear the value of a column in a row.
Note
If the row specified by the
primarykey
value does not exist, then the row is added to the table.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 replaces the existing row information for
titanic
with information forThe Great Escape.
133
modern times
g
see it137
the general
g
see it145
a perfect world
pg
see it148
the princess bride
pg
see it138
titanic
pg 13
miss it<SETVAR NAME="errno" VALUE="0" /> <CATALOGMANAGER SCOPED="GLOBAL"> <ARGUMENT NAME="ftcmd" VALUE="replacerow" /> <ARGUMENT NAME="tablename" VALUE="moviereviews" /> <ARGUMENT NAME="id" VALUE="138" /> <ARGUMENT NAME="title" VALUE="The Great Escape" /> <ARGUMENT NAME="rating" VALUE="PG" /> <ARGUMENT NAME="comments" VALUE="see it" /> </CATALOGMANAGER> <IF COND="IsError.Variables.errno=true"> <THEN> <!--Handle error--> </THEN> </IF>After the row has been replaced, the table looks as follows:
133
modern times
g
see it137
the general
g
see it145
a perfect world
pg
see it148
the princess bride
pg
see it138
The Great Escape
PG
see itSee Also
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.