The Mudcat Café TM
Thread #82020   Message #1503736
Posted By: GUEST,Jon
18-Jun-05 - 02:04 PM
Thread Name: Tech: Mudcat Troubles (from Max)
Subject: RE: Tech: Mudcat Troubles
Jim, I'm no expert either. I had understood what you were saying and looking for and had a feeling you could be right.

Looking again at the supersearch index, I see it does give the date/time of the post, the thread_ID and what we think is the correct message_ID. It might be possible to match that up with the date/time and thread_ID in the threads title although I'm not sure what you do if 2 date times are equal but I don't think that is unresolvable.

It doesn't sound impossible.

For Each record in threads
    Select matching records in index by date/time and thread_ID
    Assign thread record the message_ID
    Next record.

It needs a bit of refinement but what do you think in principle?