ProductFiles not working

[Mustafa BAŽER <minivend@sumermail.com>]

Hello,

I wrote my problem before bu I did not get an answer to
solve my problem

I am using MySQL for my product files. Since items in
each category needs differen fields I could not use
single table in the same database. So I have multiple
database in the same MySQL database.

I have the following configuration in my catalog.cfg

Database products_a  products_a.asc dbi:mysql:......
Database products_a  products_a.asc dbi:mysql:......
ProductFiles products_a products_a

Seraching is not poosible. When I use 

<INPUT TYPE=\"hidden\" NAME=\"mv_searchtype\" VALUE=\"sql\">
<INPUT TYPE=\"hidden\" NAME=\"mv_search_file\"
VALUE=\"products_a\">

in the srchform.html searching is possible in the first
table but when I try it for products_b, prices comes
zero.

Is it possible seraching without specifying the table
names.
In the docs it is possible but not working. Even  the
docs says

<INPUT TYPE=\"hidden\" NAME=\"mv_search_file\"
VALUE=\"products_a\">
<INPUT TYPE=\"hidden\" NAME=\"mv_search_file\"
VALUE=\"products_b\">

possible in the same sql search query.


What am I missing? I searched the list archive but could
not find valueab solution.

Would anyone help me please?

Mustafa BAŽER


-----------------------------------------------------
This mail sent through IMP: http://web.horde.org/imp/