[silva-dev] Silva SQL merger
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
(maybe you also need to install some python modules, in case of
mysql this is
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;-)
More information about the silva-dev