pe-db@zope.org
Objet : Re: RE : [Zope-DB] How lunch SQL request from python script ?
On Jan 19, 2007, at 7:31 AM, Charlie Clark wrote:
> keep replies on the mailing list so that others can learn from them.
This is repeated so often that you'd think that the list
administrator
On Jan 19, 2007, at 7:31 AM, Charlie Clark wrote:
keep replies on the mailing list so that others can learn from them.
This is repeated so often that you'd think that the list
administrators would get a clue and set the default Reply-to: header
to include the list address. I run
>
> The only thing that's missing for me is using this idiom with existing
> ZSQL methods and that's because I've forgotten how to get them to
> render the query rather than execute it. Anyone care to enlighten me! ;-)
Not sure if I understand you, but do you think about
src__=1 parameter when cal
Am 19.01.2007, 13:27 Uhr, schrieb Maciej Wisniowski
<[EMAIL PROTECTED]>:
Please, stay on the list
First, isn't Charlie Clark solution good for you? It seems to be
reasonable.
Thanks! ;-)
I have try to use external method but without success... (I have read
some post as you suggested it)
Am 19.01.2007, 12:22 Uhr, schrieb CERETTO Thierry <[EMAIL PROTECTED]>:
Thierry,
keep replies on the mailing list so that others can learn from them.
Hi,
Thanks Charlie, your method works well (after some hours of labor...)
My code below (not finalized, but, for Zope/Python/MySsql newbies, can
Please, stay on the list :)
First, isn't Charlie Clark solution good for you? It seems to be
reasonable.
> I have try to use external method but without success... (I have read some
> post as you suggested it)
>
Create database connection object called 'myconnection' in ZMI and
connect it to
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
