[ic] Accessing another catalog's products table

interchange-users@icdevgroup.org interchange-users@icdevgroup.org
Thu Aug 22 07:49:02 2002


I am using interchange with mysql and everything is looking rosy so far. i have
sites up and running using interchange but now i've run into a bit of a problem.

i want to have a catalog with its products table in its own database but to use
the products table from another catalog (and another database) as well. i'm
trying to think of a way to avoid the name conflict, any ideas?

to make it clearer lets say catalog1 and catalog2 both running on the same
machine with two databases, one for each catalog.

i want catalog1 to have, from its point of view, another table (aside from the
ones automatically given to it) that is in fact the products table from catalog2.

it would be nice if catalog1 could access the products table from catalog2 as
cat2products or something...

i know it is possible to use a table from another catalog, but i believe this
case is difficult because i want the name it is accessed by to be different to
the name in the actual database. is this even possible?