[ic] Two catalogs one products table

Mike Heins interchange-users@icdevgroup.org
Fri Dec 13 15:44:00 2002


Quoting Brian Kosick (briank@nacs.net):
> Mike Heins wrote:
> 
> >Quoting Brian Kosick (briank@nacs.net):
> >  
> >
> >>Mike Heins wrote:
> >>
> >><SNIP>
> >>
> >>    
> >>
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>Not knowing what the problem is, I suspect that you are the victim of a
> >>>default [query ...] somewhere. You would need [query base=merchandising
> >>>...] instead.
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >>The problem is that I'm trying to share the products table of one site 
> >>(site1) with another site(site2) I did it by specifing
> >>a new SQLDSN variable and then editing the products pgsql file to use 
> >>the new DSN.
> >>    
> >>
> >
> >This is all fine, but you are assuming facts not in evidence here. Like
> >the original behavior you are talking about. Trying to read your mind,
> >I am guessing your original problem is that the "promo" component
> >doesn't work.
> >
> >Did you try what I said? Look for a [query ...] calling merchandising?
> >Like the one in templates/components/promo?
> >
> >There is no other reason that anything would return things from
> >the Products DSN. [query ...] must have a base table to try and
> >query on. This has been covered on the mail list innumerable times.
> >
> >  
> >
> Mike, I don't think that we're syncing on this.....
> 

That is right. You are apparently ignoring my suggestion to simply
place a base=merchandising parameter in your promo (or other component)
query tag. That is certainly your option -- I won't trouble you any
further.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun