[ic] Searching Multiple DBs

Stefan Hornburg racke at linuxia.de
Thu Jan 15 12:31:29 EST 2004


On Thu, 15 Jan 2004 18:54:50 +0200
righteous at inbox.lv wrote:

> > > Hello,
> > >
> > > Can not find a way to search multiple MySQL databases.  cgi value
> > 
> > did you mean multiple "databases" or multiple "tables"?
> 
> I was asking about multiple databases.  There is a table we want to use as a
> global table that all of our interchange catalogs can access.  We have set up a
> seperate DSN in the dbconf/mysql/globaltable.sql that points to a different
> database and the table within.  Is this the way that it would be done? 
> 
> >From there, is there anyway to search that table using the normal search
> functions.  I have now written perl code to attempt reading directly from the
> table, but Interchange is still convinced that it needs to read from
> products/globaltable.txt.

Did you include st=db in your search parameters ?

For two different SQL tables I've a working example:

<form action="[process]" method="post">
<input type="hidden" name="mv_session_id" value="[data session id]">
<input type="hidden" name="mv_todo" value="search">
<input type="hidden" name="st" value="db">
<input type="hidden" name="fi" value="anymem">
<input type="hidden" name="fi" value="retire">
<input type="hidden" name="sf" value="lname">
<input type="hidden" name="rf" value="idf,lname,fname">
<input type="hidden" name="tf" value="lname,fname">
<input type="hidden" name="su" value="1">
<input name="se" value="">
<input type="submit" value="Search">
</form>

Ciao
	Racke


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team



More information about the interchange-users mailing list