• Hi Guest! Being a Paying Supporter is NOT a requirement to participate at BCF. However, subscribing will help ensure we can continue to serve the LBC community for years to come. If you enjoy BCF and find our forum a useful resource...Please consider supporting us by **Upgrading**
    (PS: Subscribers don't see this banner)
Tips
Tips

Strange question

jlaird

Great Pumpkin
Country flag
Offline
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

Jedi Warrior
Country flag
Offline
You can get a list of posts ...my stuff, my posts but does not expand...
 

bugimike

Yoda
Offline
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
 
OP
jlaird

jlaird

Great Pumpkin
Country flag
Offline
Needs to be Progress+ for subject not Re: Progress+

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

bugimike

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

ncbugeye

Jedi Warrior
Offline
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.
 
OP
jlaird

jlaird

Great Pumpkin
Country flag
Offline
Yep, just think I may do that.
 
Similar threads
Thread starter Title Forum Replies Date
jlaird MGB Strange daily question. MG 10
tahoe healey strange OD question. Austin Healey 9
J TR4/4A Strange question that may involve the coil- Triumph 13
jlaird Todays strange question Spridgets 6
John_Mc Strange question Triumph 21
T I know this is a strange question but...... Spridgets 20
jlaird Another strange but not dumb question Spridgets 1
Vargus TR2/3/3A Strange dents Triumph 19
nicko Strange Engine Noise Austin Healey 7
C MGB strange?? MG 3
J TR2/3/3A such strange thread on gear shift knob Triumph 12
7 Strange A/C - radio problem Other Cars 7
S TR2/3/3A Strange part Triumph 3
steveg Strange gasket pieces Austin Healey 5
steveg Strange Oil Leak Austin Healey 7
D TR2/3/3A Strange hole! Triumph 5
SherpaPilot Strange Noise While Cornering in TR6 Racing 3
Jim_Gruber Strange noises - Bad U Joint perhaps? Spridgets 10
Michael Oritt Strange debris found in sump Austin Healey 19
F TR2/3/3A Strange Loud Noise Triumph 11
C Strange...can won't start and then magically ressurects Austin Healey 16
bighealeysource Strange problem with throttle staying open Austin Healey 6
D TR2/3/3A Strange Transmission Issue Triumph 9
Rhodyspit75 Strange windshield washers Spridgets 0
andrea Very strange austin healey 3.9 Austin Healey 5
M Strange Healey Tach Austin Healey 9
Rut Strange occurance! Spridgets 19
aeronca65t Big Healey-strange wheels Austin Healey 12
bighealeysource Okay, here's one with a strange noise from the engine Austin Healey 7
J TR2/3/3A Strange fiberboard panel behind rear seat in TR3 Triumph 10
JPSmit What is that strange grinding sound in the distance? Spridgets 3
PAUL161 MGB Strange Reminder of a Missing Friend. MG 4
B Strange rear light Other British Cars 6
KVH Strange Sound Like Compressed Air Escaping Triumph 14
Bremer TR2/3/3A TR3A: Strange brake bleeding behaviour Triumph 4
B SU Carbs have strange vacuum fitting Triumph 17
Kleykamp TR2/3/3A Strange TR3 side curtains ??? Triumph 13
HAN8L1965 Strange event ? Spridgets 6
T strange litter Triumph 5
aeronca65t Strange and interesting MGs MG 3
PAUL161 Strange 5 Speed Conversion - Will it Work? MG 41
W Strange occurence Spridgets 5
P Strange clunking noise Triumph 20
bugedd Strange trans noise Spridgets 7
Musicman Strange Clicky/Tappy Sound Triumph 6
SilentUnicorn Strange things British Motorbikes 4
Bremer Strange, but interesting... factory blunders? Triumph 8
M another strange bugeye on ebay Spridgets 12
JAV strange noise Austin Healey 4
J Strange electric problem. Jaguar 11

Similar threads

Top