Okay so what I want to do is use the default database add action to update two tables, in one I automatically generate an id then I want to also put this id into the second table. So here's what I do:
<connection>xcpt</connection>
<table name="page">
<keys>
<key param="pageid" dbcol="pageid" type="int" mode="manual" />
</keys>
<values>
<value param="layoutnum" dbcol="layoutnum" type="string"/>
...more values...
</values>
</table>
<table name="boalinks">
<values>
<value param="key:page:pageid" dbcol="childpageid" type="int" />
...more values...
</values>
</table>
I've tried putting in a key, tried page.pageid, etc, etc, ect. Basically I'm randomly trying stupid things now, pissing in the wind and getting very angry with it.
I'm using cocoon-2.0.2-dev on Tomcat 4.01
I may cry very soon...
And yes I know I've already double posted a big bloated version of this plea for help but this will be the last time I ask, promise!
jenny
