Link Multiple Databases to One Menu Item

  • Andrew
13 years 8 months ago #145 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

Please Log in to join the conversation.

  • Miyagin
13 years 5 months 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
13 years 4 months 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.

Please Log in to join the conversation.

Moderators: Dirkjoest