Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Link Multiple Databases to One Menu Item 11 years 2 months ago #145

  • Andrew
  • Andrew's Avatar Topic Author
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 or Create an account to join the conversation.

Re:Link Multiple Databases to One Menu Item 10 years 11 months ago #211

  • Miyagin
  • Miyagin's Avatar Topic Author
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 or Create an account to join the conversation.

Re:Re:Link Multiple Databases to One Menu Item 10 years 11 months ago #212

  • Miyagin
  • Miyagin's Avatar Topic Author

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 or Create an account to join the conversation.

  • Page:
  • 1
Moderators: Dirkjoest