nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DataDeploy

Ashley

I am having difficulty finding a decent explanation of the following tags that sit within the destination section of the datadeploy config file.

<select></select>
<update></update>

At present if I try to run the configuration file with both a select and update I get the error:

column is present in both <select> and <update>

where the code reads:
<select>
<column name="oneliner" value-from-field="oneliner">
</select>
<update>
<column name="oneliner" value-from-field="oneliner">
</update>

Note: the field name in the template and the database are both named the same.

The configuration file is pushing data from teamsite templating records to a SQL Server 2000 database.

I would really gratefull if someone could point me in the right direction as to where I am going wrong. On running the config file at present I have esablished that it is connecting to the database server & reading in the teamsite templating records but is just failing to push the data into the database.

Find more posts tagged with

Comments

Adam Stoller

I believe the columns specified in <select> should be those that specify a unique identification for the particular row you wish to update, and that the columns specified in <update> are the columns within the row selected that you wish to modify.

I am pretty sure (98%) that you cannot use the same columns for both select and update (within the same transaction)

--fish
(Interwoven Senior Technical Consultant)

Ashley

Thanks for your reply:

So if i wanted to read data from the tempalting field "oneliner" and insert this into the database field "oneliner" what should the select + update statements look like?

Adam Stoller

I think you'll need to provide more detailed information about the table / schema that you are using, and the data that you are trying to update.

Show examples of the kind of data that exists in your DB table (a row of data) and then another example of how you want to change that information.

You may also need to attach your DataDeploy configuration file (please attach, do not in-line it)

--fish
(Interwoven Senior Technical Consultant)

Ashley

The database schema is as follows:

tbl_pressrelease
---------------------------------------------------
Field Name: Data Type:
---------------------------------------------------
pressrelease_id int(4)
firstname nvarchar(50)
surname nvarchar(50)
content_owner_email nvarchar(50)
expiry_date char(7)
image char(7)
print_friendly_page char(7)
email_feature char(7)
meta_description nvarchar(100)
additional_keywords nvarchar(250)
meta_keywords nvarchar(250)
oneliner varchar(72)

Note: All the above fields with the exception of the primary key pressrelease_id allow null values

The table currently has no records (rows) and I am looking to insert the content from the temsite template into this table. Rather than try to pull all these fields I have opted to just populate one for testing purposes

The field I am trying to capture looks like the following in the teamsite template:

<item name="Oneliner">
<description>
Enter a 'oneliner' to appear on the press release index page. This can also be selected for the homepage newsitems. (Maximum 60 characters).
</description>
<database data-type="VARCHAR(72)" />
<text required="t" size="50" maxlength="60" />
</item>

I have attached a copy of the configuration file I am currently using

Thanks for your help,
Ashley

Edited by Ashley on 08/06/03 05:34 AM (server time).

Ashley

See Attached:

dd_global_pressrelease.cfg

Edited by Ashley on 08/06/03 05:39 AM (server time).