Return-Path: 
 <cocoon-users-return-31286-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 71550 invoked by uid 500); 3 Apr 2002 19:18:42 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Delivered-To: moderator for cocoon-users@xml.apache.org
Received: (qmail 77810 invoked from network); 3 Apr 2002 14:09:44 -0000
Message-ID: <6A345CB6C1398A428FAF3AFCF5433EE725C28D@kpbrisemail1>
From: Rolfe Jenny <jenny.rolfe@knowledgepool.com>
To: cocoon-users@xml.apache.org
Subject: Re: using MSQL's LAST_INSERT_ID() with DatabaseAddAction 
Date: Wed, 3 Apr 2002 15:06:24 +0100 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C1DB18.BD8CBDA0"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C1DB18.BD8CBDA0
Content-Type: text/plain;
	charset="iso-8859-1"

I'm trying to do much the same thing as in the message beneath: 

<auth-descriptor> 
<connection>xcpt</connection> 
<table name="page"> 

<keys> 
<key param="pageid" dbcol="pageid" type="int" mode="manual"/> 
</keys> 
<values> 
<value param="pagetitle" dbcol="title" type="string"/> 
<value param="pagename" dbcol="pagename" type="string"/> 
<value param="pagestructure" dbcol="templatenum" type="string"/> 
<value param="location" dbcol="techlocation" type="string"/> 
<value param="layoutnum" dbcol="layoutnum" type="string"/> 

</values> 
</table> 

<table name="boalinks"> 
<values> 
<value param="page:pageid" dbcol="childpageid" type="int" /> 
<value param="layoutnum" dbcol="parentboaid" type="string"/> 

</values> 
</table> 

</auth-descriptor> 

What I want to do is automatically generate an id in one table and pick this

id up and put it in another table. 
The adding to multiple tables bit works fine but the childpageid column is 
empty. I have tried key:page:pageid and multiple variations on the theme 
but nothing seems to work. 

Any suggestions? 
thanks 
jenny 




----- Original Message ----- 
From: "Christian Haul" <haul@dvs1.informatik.tu-darmstadt.de
</cgi-bin/compose?curmbox=F000000001&a=7a875e2a05bac6e4ab7359b7a491f3a2&mail
to=1&to=haul@dvs1.informatik.tu-darmstadt.de&msg=MSG1017842688.30&start=9678
18&len=5177&src=&type=x>> 
To: <cocoon-users@xml.apache.org
</cgi-bin/compose?curmbox=F000000001&a=7a875e2a05bac6e4ab7359b7a491f3a2&mail
to=1&to=cocoon-users@xml.apache.org&msg=MSG1017842688.30&start=967818&len=51
77&src=&type=x>> 
Sent: Friday, March 01, 2002 3:38 PM 
Subject: Re: using MSQL's LAST_INSERT_ID() with DatabaseAddAction 


		On 01.Mar.2002 -- 03:34 PM, Giuseppe Di Pierri wrote:  > Hi
there,  > > I have  a problem using the DatabaseAddAction in MySQL.  >  > I
would do two table insertions, one after an other like the following  >
example:   The value is written to a request attribute (table.column) that
you  can use if you were using the manual method of determining the id
(looks up current max value +1).   	

		 I was about to check in new database actions to scratchpad
(atually,  new versions of the ones already there) but since I encountered
problems with datasources with today's CVS I cannot verify that they  still
work. Those do understand mysql's autoincrement columns. But  they use a
slightly different database.xml syntax *and* their name  and their
configuration sitemap-wise will change with my checkin.   If you'd like to
stay tuned.... should be only a matter of days  now.   > INSERT INTO base
(id,...) VALUES(NULL,...);  > # id is defined as INT NOT NULL AUTO_INCREMENT
>  > INSERT INTO derived (id,....) VALUES(LAST_INSERT_ID(),....);  >  >
<employee>  > <connection>personnel</connection>  > <table name="base">  >
<keys>  > <key param="id" dbcol="id" type="int" mode="manual"/>  > </keys>
> <values>  > <value param="myparam" dbcol="...." type="string" />  >
</values>  > </table>  > <table name="derived">  > <keys>  > <!-- how can I
use the mysql LAST_INSERT_ID() here,  > in order to insert the previous
inserted auto_increment value  > <key param="id" dbcol="id" type="int"/>  >
?-->  <key param="base.id" dbcol="id" type="int"/>  	

Christian, you gave me the trigger to look at the source: 

Is this also correct ? 
<key param="key:base:id" dbcol="id" type="int"/> 

bye 
pino 

		> </keys>  > <values>  > <value param="..." dbcol="..."
type="string" />  > </values>  > </table>  > </employee>   Chris.  	


------_=_NextPart_001_01C1DB18.BD8CBDA0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Re: using MSQL's LAST_INSERT_ID() with DatabaseAddAction =
</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Courier New">I'm trying to do much the same =
thing as in the message beneath:<BR>
<BR>
&lt;auth-descriptor&gt;<BR>
&lt;connection&gt;xcpt&lt;/connection&gt;<BR>
&lt;table name=3D&quot;page&quot;&gt;<BR>
<BR>
&lt;keys&gt;<BR>
&lt;key param=3D&quot;pageid&quot; dbcol=3D&quot;pageid&quot; =
type=3D&quot;int&quot; mode=3D&quot;manual&quot;/&gt;<BR>
&lt;/keys&gt;<BR>
&lt;values&gt;<BR>
&lt;value param=3D&quot;pagetitle&quot; dbcol=3D&quot;title&quot; =
type=3D&quot;string&quot;/&gt;<BR>
&lt;value param=3D&quot;pagename&quot; dbcol=3D&quot;pagename&quot; =
type=3D&quot;string&quot;/&gt;<BR>
&lt;value param=3D&quot;pagestructure&quot; =
dbcol=3D&quot;templatenum&quot; type=3D&quot;string&quot;/&gt;<BR>
&lt;value param=3D&quot;location&quot; dbcol=3D&quot;techlocation&quot; =
type=3D&quot;string&quot;/&gt;<BR>
&lt;value param=3D&quot;layoutnum&quot; dbcol=3D&quot;layoutnum&quot; =
type=3D&quot;string&quot;/&gt;<BR>
<BR>
&lt;/values&gt;<BR>
&lt;/table&gt;<BR>
<BR>
&lt;table name=3D&quot;boalinks&quot;&gt;<BR>
&lt;values&gt;<BR>
&lt;value param=3D&quot;page:pageid&quot; =
dbcol=3D&quot;childpageid&quot; type=3D&quot;int&quot; /&gt;<BR>
&lt;value param=3D&quot;layoutnum&quot; dbcol=3D&quot;parentboaid&quot; =
type=3D&quot;string&quot;/&gt;<BR>
<BR>
&lt;/values&gt;<BR>
&lt;/table&gt;<BR>
<BR>
&lt;/auth-descriptor&gt;<BR>
<BR>
What I want to do is automatically generate an id in one table and pick =
this<BR>
id up and put it in another table.<BR>
The adding to multiple tables bit works fine but the childpageid column =
is<BR>
empty. I have tried key:page:pageid and multiple variations on the =
theme<BR>
but nothing seems to work.<BR>
<BR>
Any suggestions?<BR>
thanks<BR>
jenny<BR>
<BR>
<BR>
<BR>
<BR>
----- Original Message -----<BR>
From: &quot;Christian Haul&quot; &lt;<U></U></FONT><U><FONT =
COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Courier =
New">haul@dvs1.informatik.tu-darmstadt.de =
&lt;/cgi-bin/compose?curmbox=3DF000000001&amp;a=3D7a875e2a05bac6e4ab7359=
b7a491f3a2&amp;mailto=3D1&amp;to=3Dhaul@dvs1.informatik.tu-darmstadt.de&=
amp;msg=3DMSG1017842688.30&amp;start=3D967818&amp;len=3D5177&amp;src=3D&=
amp;type=3Dx&gt;</FONT></U><FONT SIZE=3D2 FACE=3D"Courier New">&gt;<BR>
To: &lt;</FONT><U><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Courier =
New">cocoon-users@xml.apache.org =
&lt;/cgi-bin/compose?curmbox=3DF000000001&amp;a=3D7a875e2a05bac6e4ab7359=
b7a491f3a2&amp;mailto=3D1&amp;to=3Dcocoon-users@xml.apache.org&amp;msg=3D=
MSG1017842688.30&amp;start=3D967818&amp;len=3D5177&amp;src=3D&amp;type=3D=
x&gt;</FONT></U><FONT SIZE=3D2 FACE=3D"Courier New">&gt;<BR>
Sent: Friday, March 01, 2002 3:38 PM<BR>
Subject: Re: using MSQL's LAST_INSERT_ID() with DatabaseAddAction<BR>
<BR>
</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Courier New">On 01.Mar.2002 -- 03:34 PM, Giuseppe Di Pierri =
wrote:&nbsp; &gt; Hi there,&nbsp; &gt; &gt; I have&nbsp; a problem =
using the DatabaseAddAction in MySQL.&nbsp; &gt;&nbsp; &gt; I would do =
two table insertions, one after an other like the following&nbsp; &gt; =
example:&nbsp;&nbsp; The value is written to a request attribute =
(table.column) that you&nbsp; can use if you were using the manual =
method of determining the id&nbsp; (looks up current max value =
+1).&nbsp;&nbsp;</FONT> &nbsp;<BR>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =
FACE=3D"Courier New"> I was about to check in new database actions to =
scratchpad (atually,&nbsp; new versions of the ones already there) but =
since I encountered&nbsp; problems with datasources with today's CVS I =
cannot verify that they&nbsp; still work. Those do understand mysql's =
autoincrement columns. But&nbsp; they use a slightly different =
database.xml syntax *and* their name&nbsp; and their configuration =
sitemap-wise will change with my checkin.&nbsp;&nbsp; If you'd like to =
stay tuned.... should be only a matter of days&nbsp; now.&nbsp;&nbsp; =
&gt; INSERT INTO base (id,...) VALUES(NULL,...);&nbsp; &gt; # id is =
defined as INT NOT NULL AUTO_INCREMENT&nbsp; &gt;&nbsp; &gt; INSERT =
INTO derived (id,....) VALUES(LAST_INSERT_ID(),....);&nbsp; &gt;&nbsp; =
&gt; &lt;employee&gt;&nbsp; &gt; =
&lt;connection&gt;personnel&lt;/connection&gt;&nbsp; &gt; &lt;table =
name=3D&quot;base&quot;&gt;&nbsp; &gt; &lt;keys&gt;&nbsp; &gt; &lt;key =
param=3D&quot;id&quot; dbcol=3D&quot;id&quot; type=3D&quot;int&quot; =
mode=3D&quot;manual&quot;/&gt;&nbsp; &gt; &lt;/keys&gt;&nbsp; &gt; =
&lt;values&gt;&nbsp; &gt; &lt;value param=3D&quot;myparam&quot; =
dbcol=3D&quot;....&quot; type=3D&quot;string&quot; /&gt;&nbsp; &gt; =
&lt;/values&gt;&nbsp; &gt; &lt;/table&gt;&nbsp; &gt; &lt;table =
name=3D&quot;derived&quot;&gt;&nbsp; &gt; &lt;keys&gt;&nbsp; &gt; =
&lt;!-- how can I use the mysql LAST_INSERT_ID() here,&nbsp; &gt; in =
order to insert the previous inserted auto_increment value&nbsp; &gt; =
&lt;key param=3D&quot;id&quot; dbcol=3D&quot;id&quot; =
type=3D&quot;int&quot;/&gt;&nbsp; &gt; ?--&gt;&nbsp; &lt;key =
param=3D&quot;base.id&quot; dbcol=3D&quot;id&quot; =
type=3D&quot;int&quot;/&gt;&nbsp;</FONT> &nbsp;&nbsp;&nbsp;<BR>
<BR>
<FONT SIZE=3D2 FACE=3D"Courier New">Christian, you gave me the trigger =
to look at the source:<BR>
<BR>
Is this also correct ?<BR>
&lt;key param=3D&quot;key:base:id&quot; dbcol=3D&quot;id&quot; =
type=3D&quot;int&quot;/&gt;<BR>
<BR>
bye<BR>
pino<BR>
</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Courier New">&gt; &lt;/keys&gt;&nbsp; &gt; &lt;values&gt;&nbsp; =
&gt; &lt;value param=3D&quot;...&quot; dbcol=3D&quot;...&quot; =
type=3D&quot;string&quot; /&gt;&nbsp; &gt; &lt;/values&gt;&nbsp; &gt; =
&lt;/table&gt;&nbsp; &gt; &lt;/employee&gt;&nbsp;&nbsp; =
Chris.&nbsp;</FONT> &nbsp;&nbsp;&nbsp;&nbsp;<BR>

</P>

</BODY>
</HTML>
------_=_NextPart_001_01C1DB18.BD8CBDA0--