Re: ZSQL Question - Insert multiple rows in one statement?

--===============4680949859488823420==
Content-Type: multipart/alternative; boundary=0016364275dac77342048e9fdc88

--0016364275dac77342048e9fdc88
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

2010/8/25 Jaroslav Lukesh <[email protected]>

>
> ----- Puvodn=ED zpr=E1va ----- Od: "Andreas Jung" <[email protected]>
>
>
>
>  -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> I would assume that you can use DTML-IN for looping and generating
>> multiple SQL statements of the same kind. You have to ensure that
>> the statements having a proper delimiter (there was something in DTML?!
>> DTML-SQLDELIMITER?...no idea, you need to checks the docs of this
>> ancient technology).
>>
>
> DTML is mature, not ancient. For ZSQL is DTML the best one.


For ZSQL methods perhaps - fortunately we moved on and we are having
higher-level
solutions like ORMs for implementing SQL connectivity in a more clean way.
Of course, use SQL and ZSQL methods if you need to...but from the
prospective
of software architecture we have better solutions in our toolbox.


>
>
> Did you try to make many small dynamic javascript in one page with ZPT?
> Yeah, python scripts calling, instead of placing small dtml code into
> javascript in page...
>
> ZPT is more academic platform, than for everyday usage.


Truly  nonsense.  ZPT is the adopted solution in the Zope universe for doin=
g
templating - for a variety of reasons
(e.g. support for unicode, ZPT is maintained - DTML has not seen any change=
s
and fixes lately).

-aj

>

--0016364275dac77342048e9fdc88
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">2010/8/25 Jaroslav Lukesh <span dir=3D"l=
tr">&lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt;</span>=
<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-lef=
t:1px #ccc solid;padding-left:1ex;">
<br>
----- Puvodn=ED zpr=E1va ----- Od: &quot;Andreas Jung&quot; &lt;<a href=3D"=
mailto:[email protected]" target=3D"_blank">[email protected]</a>&gt;<div class=
=3D"im"><br>
<br>
<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
I would assume that you can use DTML-IN for looping and generating<br>
multiple SQL statements of the same kind. You have to ensure that<br>
the statements having a proper delimiter (there was something in DTML?!<br>
DTML-SQLDELIMITER?...no idea, you need to checks the docs of this<br>
ancient technology).<br>
</blockquote>
<br></div>
DTML is mature, not ancient. For ZSQL is DTML the best one. </blockquote><d=
iv><br></div><div>For ZSQL methods perhaps - fortunately we moved on and we=
 are having higher-level</div><div>solutions like ORMs for implementing SQL=
 connectivity in a more clean way.</div>
<div>Of course, use SQL and ZSQL methods if you need to...but from the pros=
pective</div><div>of software architecture we have better solutions in our =
toolbox.</div><div>=A0</div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
<br>
Did you try to make many small dynamic javascript in one page with ZPT? Yea=
h, python scripts calling, instead of placing small dtml code into javascri=
pt in page...<br>
<br>
ZPT is more academic platform, than for everyday usage.</blockquote><div><b=
r></div><div>Truly =A0nonsense. =A0ZPT is the adopted solution in the Zope =
universe for doing templating - for a variety of reasons</div><div>(e.g. su=
pport for unicode, ZPT is maintained - DTML has not seen any changes and fi=
xes lately).</div>
<div><br></div><div>-aj</div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">=A0</blockquot=
e></div>

--0016364275dac77342048e9fdc88--

--===============4680949859488823420==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Zope-DB mailing list
[email protected]
https://mail.zope.org/mailman/listinfo/zope-db

--===============4680949859488823420==--