[silva-dev] Silva SQL merger
Marc Petitmermet
petitmermet at mat.ethz.ch
Tue Jul 1 15:52:20 CEST 2003
> I am pleased to see that SQL and Silva seem to be living together.
> I would apreciate a little help (i.e. a few small examples) of how to
> make this work. Does anyone have this available?
It's quite easy. In case of mysql as database:
1. Install the zope product ZMySQLDA (or other adaptors for other sql
servers)
(maybe you also need to install some python modules, in case of
mysql this is
mysql-python)
2. Make a Z MySQL Database Connection
3. Now, within smi, you can define a silva sql data source.
Just use the correct database connection if you have more than one.
Write your sql querry there.
4. From within a silva document you can call the querries with the
external data element.
5. That's it;-)
Regards,
Marc
More information about the silva-dev
mailing list