[ic] Products from second table not appearing in search results?

[IC]

> > >>> Hi folks,
> > >>>
> > >>> I have defined a second products table (products2) in catalog.cfg
> > which
> > >>> seems fine except that none of the products from this table appear
> > in
> > >>> the
> > >>> standard search results, does IC only search the default products
> > >>> table? Is
> > >>> there something else I need to define to tell IC to search the
> > second
> > >>> table
> > >>> as well?
> > >> Maybe this is what you are looking for:
> > >> http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
> > >> http://www.interchange.rtfm.info/icdocs/config/DefaultTables.html
> > >>
> > >> http://www.icdevgroup.org/docs/confs.html#ProductFiles
> > >>
> > >> CU,
> > >>
> > >> Gert
> > >>
> > >
> > > Hi Gert,
> > >
> > > I had already read these, DefaultTables is listed as an alias for
> > > ProductFiles, in catalog.cfg I have tried just having the second
> > table, I
> > > can load the skus in flypage ok but nothing in the search results.
> > >
> > > I currently have in catalog.cfg:-
> > >
> > > ProductFiles   products2
> > >
> > > Any ideas?
> >
> > Your search is explicitly set for "fi=products".  You can explicitly
> > change it to "fi=products2" or remove the designation in which case it
> > will search all tables listed in DefaultTables.
> >
> > http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_searc
> > h_file_fi
> 
> And by doing ProductFiles products2  does that not override the default
> 'products'?
> So should it not be ProductFiles products products2  in the case you add a
> second product file?
> 
> And perhaps your search is return items from products2 instead of products
> ...
> 
> But probably Peter is right and I really should go to bed :)
> 
> CU,
> 
> Gert
> 

Hi Gert,

Yes it did have both tables but since it wouldn't work I changed it to only
products2, but this still won't work with the default search (small search
component). Looking at the component it does not seem to limit a search to
any table so I cannot see why it doesn't work??

Andy.