Strange question

[jlaird]

dosen't seem to be anyplace to ask this so will just let it all hang out here.

As you all have noted I comment on Miss Agathas progress with posts here with the subject line of "Progress".

Now if there was a way to print them all out in a by date order I would have an intresting comentary for my great grand kids or some such.

Do you supose Basil could/can do that? ie pull and email em to me as a batch job so I could print em.

Guess I could do it one at a time but that seems so slow.

 

[leecreek]

You can get a list of posts ...my stuff, my posts but does not expand...

 

[bugimike]

Boy, have fun Jack, you only have 7421 (as of right now!) posts to sift through! Of course you can narrow it down with just the "progess" titles. something to do while waiting for parts deliveries!! /bcforum/images/%%GRAEMLIN_URL%%/wink.gif

 

[jlaird]

Needs to be Progress+ for subject not Re: Progress+

and the first post only of each. sigh. Hay, only 300 to wade through.

 

[bugimike]

Jack, in mine if I just click on a post I getthe whole thing, page by page!

 

[ncbugeye]

Jack,

From a programming point of view, it depends how each post is stored in the UBB.threads database. One sensible way to store a post would be as a CLOB (Character Large Object) including all the UBBCode markup etc, which can be extracted as one field in a database call. If it is stored this way or something very similar, then the CLOB data from a selected range of posts could be pulled from the database and written to a file with some kind of identifying header such as date, time etc.

To get technical for a moment, the SQL for this might be as simple as:

SELECT MEMBER, POSTDATE, POSTTIME, POSTTEXT FROM POST_TABLE WHERE MEMBER = "jlaird" AND DATE BETWEEN "2006-01-01" AND "2006-12-31" ORDER BY POSTDATE, POSTTIME

The result of the above call would be an array of useful stuff sorted in date,time order that you could then massage using a wordprocessor program. Of course there would be more to it than this, but you get the picture.

All you have to do is ask Basil if it really is this simple, and then persuade him to run the query for you and send you the results.

 

[jlaird]

Yep, just think I may do that.