The Off Topic Thread.

[Trumpy]

You think I know how to do that techie stuff?

[KEN 24T]

You think I know how to do that techie stuff?

SELECT Member_ID, Record_ID FROM Posts WHERE Record_Number = 100000;

[sharkey]

You think I know how to do that techie stuff?

SELECT Member_ID, Record_ID FROM Posts WHERE Record_Number = 100000;

I don't think that will work.

If you go to your assistant and then your last 10 posts it puts the post number up. My post that was pretty close to number 100,000 comes up as Post Preview: #102729

But could you work it out from this number somehow?

[Guest]

Yea they sound shmiko,be louder tomorrow haha

vik

[KEN 24T]

I don't think that will work.

What? Did I get the SYNTAX wrong?

[Trumpy]

I think Chris needs to check the database to find out.

[sharkey]

I don't think that will work.

What? Did I get the SYNTAX wrong?

No. It's just I don't think the ID# started at 1.

It is up to 102,753+ already.

[KEN 24T]

I think Chris needs to check the database to find out.

:o

Where is he? Is he doing that now? Did you call him?

... don't just sit there man, this is important ... what's his number?

Think I'm going to need a wee Johnny ... :o

[Trumpy]

You'd better go get rid of your hot dogs, this may take a while....

[sharkey]

OK

I have a theory. One of my last posts I made from one IE window whilst checking the Post Count in another. The Post Count was 100,031.

I then went to 'My assistant' and viewed my last 10 posts. The Post # came up as 102,760. So the numbers are 2,729 ahead of the count.

This would mean that whover made Post # 102,729 made the 100,000th post.

And that was me :o

But then I could be completely wrong

Edited 18/03/04 06:20 AM by sharkey