[Zope-it] Transazioni MySQL

[Gianluca Di Carlo]

Messaggio in formato MIME composto da pił parti.

------=_NextPart_000_0021_01C14AA3.3EC35D40
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: Quoted-Printable

Ciao,
come si usano le transazioni MySql dentro metodi zsql?
Dovrei eseguire due insert su due tabelle, dove la seconda deve inserire =
l'id creata da una colonna autoincrementante della prima, faccio cosi:

BEGIN
<dtml-var sql_delimiter>
insert into imprese (
       =
ragione_sociale,indirizzo,localita,CAP,provincia,tel,fax,email,descrizion=
e)
       values(      =20
       <dtml-sqlvar field_ragione_sociale_form type=3Dstring>,
       <dtml-sqlvar field_indirizzo_form type=3Dstring>,
       <dtml-sqlvar field_localita_form type=3Dstring>,
       <dtml-sqlvar field_CAP_form type=3Dstring>,
       <dtml-sqlvar field_provincia_form type=3Dint>,
       <dtml-sqlvar field_tel_form type=3Dstring>,
       <dtml-sqlvar field_fax_form type=3Dstring>,
       <dtml-sqlvar field_email_form type=3Dstring>,
       <dtml-sqlvar field_descrizione_form type=3Dstring>)

<dtml-var sql_delimiter>
select @id:=3DLAST_INSERT_ID()
<dtml-var sql_delimiter>
insert into account (user,password,IDImpresa) values (<dtml-sqlvar =
field_user_form type=3Dstring>,<dtml-sqlvar field_password_form =
type=3Dstring>,@id)    =20
<dtml-var sql_delimiter>
COMMIT

Per=F2 non attiva le transazioni e mi da anche errore sulla seconda =
insert.
Grazie dell'aiuto
Gianluca

------=_NextPart_000_0021_01C14AA3.3EC35D40
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: Quoted-Printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Ciao,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>come si usano le transazioni MySql =
dentro metodi=20
zsql?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Dovrei eseguire due insert su due =
tabelle, dove la=20
seconda deve inserire l'id creata da una colonna autoincrementante della =
prima,=20
faccio cosi:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>BEGIN<BR>&lt;dtml-var =
sql_delimiter&gt;<BR>insert=20
into imprese (<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
ragione_sociale,indirizzo,localita,CAP,provincia,tel,fax,email,descrizion=
e)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
values(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dtml-sqlvar=20
field_ragione_sociale_form=20
type=3Dstring&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;dtml-sqlvar=20
field_indirizzo_form =
type=3Dstring&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;dtml-sqlvar field_localita_form=20
type=3Dstring&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;dtml-sqlvar=20
field_CAP_form =
type=3Dstring&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;dtml-sqlvar field_provincia_form=20
type=3Dint&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dtml-sqlvar=20
field_tel_form =
type=3Dstring&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;dtml-sqlvar field_fax_form=20
type=3Dstring&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;dtml-sqlvar=20
field_email_form =
type=3Dstring&gt;,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;dtml-sqlvar field_descrizione_form type=3Dstring&gt;)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;dtml-var =
sql_delimiter&gt;<BR>select=20
@id:=3DLAST_INSERT_ID()<BR>&lt;dtml-var sql_delimiter&gt;<BR>insert into =
account=20
(user,password,IDImpresa) values (&lt;dtml-sqlvar field_user_form=20
type=3Dstring&gt;,&lt;dtml-sqlvar field_password_form=20
type=3Dstring&gt;,@id)&nbsp;&nbsp;&nbsp;&nbsp; <BR>&lt;dtml-var=20
sql_delimiter&gt;<BR>COMMIT<BR><BR>Per=F2 non attiva le transazioni e mi =
da anche=20
errore sulla seconda insert.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Grazie dell'aiuto</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Gianluca</DIV></FONT></BODY></HTML>

------=_NextPart_000_0021_01C14AA3.3EC35D40--