[ic] Searching Multiple DBs
Paul Jordan
paul at gishnetwork.com
Thu Jan 15 12:50:56 EST 2004
Paul Jordan wrote:
> Did you mean "multiple databases" at once, or seperately? At any
> rate, I take it you have set up one mysql db, so set the other one
> up the same. IOW define 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 the table using THOSE vars, like in
> dbconf/mysql/foo.mysql.
>
> to search it, just call the table.
>
> [query
> ml=10
> more=1
> type=list
> sp="@@MV_PAGE@@"
> ---> table=my_table_in_other_db <----------------
> sql=|
> SELECT foo, bar
> FROM my_table_in_other_db <----------------
> WHERE somecol BETWEEN '[cgi from]' AND '[cgi to]'
> AND someothercol = '[cgi whatever]' ORDER
> BY sku |]
> [list] ....
Doh, the FROM was wrong in my example. corrected above.
Paul
More information about the interchange-users
mailing list