ExportNodeXMLToColumn

Syntax

bool ExportNodeXMLToColumn (strParam)

Parameters

Three comma-separated values:

1. The smart parameter path to the bound object of the Document Hierarchy. This object's XML property will be added to a designated column of the Export database.
2. The String value of the name of the target column in the Export database. The action will add the value of the calling object's XML property to this column.
3. Optional: Can be set to the numerical value of 1 or 3. If this parameter is not specified, quotes will be placed around the value in the SQL query to update the table.

Setting the value to 1 causes this action to return False if the Table name is invalid; otherwise the error will not be discovered until the action that performs the DB insert call, such as an AddRecord action, is called. This value would typically only be used in a development environment as it will increase processing time.

Setting the value to 3 allows NULL and if the column value is not NULL, the column value will be surrounded in quotes in the SQL query to update the database.

Returns

False if:

1. There is no connection to the database.
2. The column identified by the parameter does not exist.
3. A SetTableName action was not previously used.
4. The smart parameter path does not point to a valid object of the Document Hierarchy.

Otherwise, True.

Level

All, but generally at the Page or Field level.

Details

This action exports the value of the XML property of the bound object (node) of the Document Hierarchy to a column of the Export database.

Example:

ExportNodeXMLToColumn("@P\MyField,MYDBCOLUM")