[ic] Multiple DataBases & Flypages

Paul Jordan interchange-users@interchange.redhat.com
Mon May 13 13:26:00 2002


> Thanx again.
>
> I'm using mysql I have done all these stuff and in fact mysql knows of the
> "products_named" table, I can even display data from this table via the
> [data] tag but still when i access the page for an item like:
> "<url>/cgi-bin/<store>/FP6800Z.html"
>
> It shows me the "missing.html" because it does not consider
> "products_named"
> as a Products DB.
>
> Thank You
> Chaim Klar
>
>
> >From: Paul Jordan <paul@gishnetwork.com>
> >Reply-To: interchange-users@interchange.redhat.com
> >To: interchange-users@interchange.redhat.com
> >Subject: RE: [ic] Multiple DataBases & Flypages
> >Date: Mon, 06 May 2002 10:39:16 -0700
> >
> > > Thanx.
> > >
> > > My flypage "flypage_named.html" is working fine.
> > >
> > > However I can not get interchange to understand that
> "products_named" is
> > > also a product database even after restarting interchange.
> > >
> >
> >
> >
> >Be sure to top quote :)
> >
> >What db are you using mysql? gdbm? You need to define the new
> table for IC,
> >in catroot/dbconf/default, if you are not using the default IC db,
> >substitute default for mysql or whatever.
> >
> >Anyways, open one of the definitions up, and you will get the idea. You
> >could probably copy the products.foo, and then open it up and edit it
> >accordingly.
> >
> >Paul
> >


Chaim

Did you ever solve this? I had given you all my suggestions. I had never
done it, but I have ran into enough docs in the archives to suggest what I
have.

Said that, you can always just put a new column in products.txt called
"named" and indicate whether a product is named or not with 1 or 0, / Yes or
No.

That is, if your product columns are similar enough.

Paul