[ic] Searching Multiple DBs
rphipps at reliant-solutions.com
Thu Jan 15 13:28:28 EST 2004
> From: interchange-users-bounces at icdevgroup.org
> bounces at icdevgroup.org] On Behalf Of righteous at inbox.lv
> > Did you mean "multiple databases" at once, or seperately? At any
> > it you have set up one mysql db, so set the other one up the same.
> > another SQLDSN SQLPASS SQLUSER (but use say SQLDSN_2 SQLPASS_2
> SQLUSER_2) etc
> > in variale (or any other place you want to define this). Then define
> > table using THOSE vars, like in dbconf/mysql/foo.mysql.
> > to search it, just call the table.
> The query code you put forth is what I tried previously, with no
> Interchange is very stubborn and continues to read from the
> instead of looking into the appropriate database indicated in
> dbconf/mysql/buyback.sql. Removing the products/buyback.txt causes
> server errors.
Do you have st=db? Once you set that IC will not look at the text files
More information about the interchange-users