Richard Smith wrote:

> > I'm finalizing my tinkering somewhere between today
> > and thursday, having handled the basic issues. I'll then mail a
> > sketch and a proposal to the list, which will show what will need
> > to be done to engineer it.
> 
> Well from what I can see from the _outdated_ documentaqtion all you
> need to do is add an extra table in. This will allow multiple
> articles to multiple categories. See below...

I was referring to scripting work above, but on to linking:

> Field Name    |    Type    |    Len
> - ----------------------------------------------
> refno            int            11
> category         int            11
> parent           int            11
> child            int            11
> sitegroup        int            11
> 
> This will mean not only multiple stores per category, but also allow
> child atricles to articles... I mean it's only a quick INNER JOIN
> statment to link the lot together.

True, but makes management of this table will require good care (when
to delete articles etc) plus there's no longer a way to find 'the'
parent for an article, unless you can do the above as an add-on (in
which case you know a lot more about SQL than I do). And it'd bereally
cool if we could device a solution that handles generic links
(topic/topic links e.g.).

> p.s. Should this be moved to the Dev mailing list?

Probably.

Emile



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to