Hi,
I just finished a multi site project where I needed to load a node and a menu tree from another database.
I used db_set_active() to switch the db, which worked, but neither node_load() nor menu_tree() worked as expected.
node_load() loaded the node but not the fields attached to the node. Then the node is also cached wrong for the original site. I found a suggestion for Drupal 6 here http://www.opensourcery.com/blog/jonathan-hedstrom/programmatic-node-cre... which uses drupal_get_schema(NULL, TRUE); but that did not work for my case.
So is there a possibility to invoke the field loading from the right database?
When using menu_tree() the problem was different... I had on both databases a "main-menu", so menu_tree() loaded the menu in the static cache and there was the same menu two times on the same page...
I ended up using db_query which worked as expected but this is of course a little "hacky/dirty".
greetz
