Maciej Wisniowski wrote:
>> what I now do as an interim solution, I call the "read only" procedures
>> directly from python.
>> procedures that alter data i call from a zope connector.
>>
>>
> What do you mean by 'directly from python' and 'from a zope connector'?
>
directly from python: I
Am 18.01.2007, 17:58 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
I think I found the reason, for my problems with stored procedures.
it seems that on can not call a stored MySQL 5.0x procedure from zope
that returns a data set.
If you use the mxODBC Zope DA callproc() method then you c
> what I now do as an interim solution, I call the "read only" procedures
> directly from python.
> procedures that alter data i call from a zope connector.
>
What do you mean by 'directly from python' and 'from a zope connector'?
> I would be glad to here of any reason not to do this.
First I nee
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi there,
I think I found the reason, for my problems with stored procedures.
it seems that on can not call a stored MySQL 5.0x procedure from zope
that returns a data set.
when I call the body of the stored procedure everything works fine.
what I no
Am 18.01.2007, 11:52 Uhr, schrieb CERETTO Thierry <[EMAIL PROTECTED]>:
select distinct c.id_risque, c.libelle_risque, c.id_fiche, c.id_portee,
c.url_info
from (mots a join amotrisque b on a.id_mot = b.id_mot )
join risques c on b.id_risque = c.id_risque
where a.mot_MAJ like '%@@CRITE
> 2) I think to do that, I must to use a python script, I have a piece
> of code (above) but I don't know to connect MySql database and I don't
> know how to lunch my SQL query in python L (and I suppose which I can
> generate a HTML results in this same python script OR it's better to
> call a Pa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thierry,
I think all problems you describe can be solved with ZSQL easily.
the best thing for yo is to grap the documentation on how to do that.
you find it here
http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx
look into it, and if you fi
Hi and all my wishes for you for 2007,
Zope 2.8.6-final, python 2.3.5, win32, ZMySQLDA, MySQL for python.
In ZMI (I know, it's not very well but I'm a newbie...), I use "Z MySQL
database connection", "Z SQL method", "Page Template", etc, that's works
fine but in "Z SQL method" I use onl