Link Multiple Databases to One Menu Item
- Andrew
- Topic Author
14 years 5 months ago #145
by Andrew
Link Multiple Databases to One Menu Item was created by Andrew
It would be great if Joodatabase was able to link more than one database to a specific menu item. This way, for my site, I could remove clutter from the menu links by having one menu item for two databases that would be shown together. Any ideas when this might be added to future versions?
Great work so far!
Thanks,
Andrew
Great work so far!
Thanks,
Andrew
Please Log in to join the conversation.
- Miyagin
- Topic Author
14 years 1 month ago #211
by Miyagin
Replied by Miyagin on topic Re:Link Multiple Databases to One Menu Item
There is a non comercial plugin called ExternalDB wich allows to use Joomla framework with diferents Mysql DB´s, i use it to obtain date from diferents server (just mysql no MSSQL or Oracle for those one i just use ODBC´s). It will be interesting add the power of ExternalDB to jooDatabase.
Please Log in to join the conversation.
- Miyagin
- Topic Author
14 years 1 month ago #212
by Miyagin
There is a way to solve this creating a view CREATE VIEW [name] AS SELECT .... FROM bbdd1.table1 t1, bbdd2.table2 t2 WHERE.....
And them, you can use this view on joodatabase.
[Miyagin 2010-11-25 11:59:34]:
There is a non comercial plugin called ExternalDB wich allows to use Joomla framework with diferents Mysql DB´s, i use it to obtain date from diferents server (just mysql no MSSQL or Oracle for those one i just use ODBC´s). It will be interesting add the power of ExternalDB to jooDatabase.
Replied by Miyagin on topic Re:Re:Link Multiple Databases to One Menu Item
There is a way to solve this creating a view CREATE VIEW [name] AS SELECT .... FROM bbdd1.table1 t1, bbdd2.table2 t2 WHERE.....
And them, you can use this view on joodatabase.
[Miyagin 2010-11-25 11:59:34]:
There is a non comercial plugin called ExternalDB wich allows to use Joomla framework with diferents Mysql DB´s, i use it to obtain date from diferents server (just mysql no MSSQL or Oracle for those one i just use ODBC´s). It will be interesting add the power of ExternalDB to jooDatabase.
Please Log in to join the conversation.
Moderators: Dirk, joest