Hey people, ive made a forum on my website and i need to make a few modifications. I need to make it so when people post a reply to a message that is half way down the page for example, it moves it back to the top of the page. I used DMX to make the forum in ASP using an access db.

I would like to know how to make the posts format properly. For example if i put a like break in the message, it will display that line break when the message is viewed.

the forum is at www.austrials.com if u wanna see it.

bye!

mish

I assume that the post table you have created has a common id linking them together and a unique post id as well.

Cant you just sort the recordset by the unique id in descending order?

For the line break, use the following:

Replace(rsRecordsetname.fields.item("textfield".value, VbCrLf, "<BR>"

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

thanks for advice Vince. My data structure consits of one table to store all messages. All messages have a unique ID and replies have a parentID which relates to the ID of the message replied to. I have a recordset for the list of messages on the main page sorting the id of each message. Any idea?

I got the line break thing to work, thats cool. So how would i go about making it so they can post as html?

Thanks a million!

mish

Based on your description, the replies table that is linked by the parent message id should have an incremental ID of its own. Filter this descending for the history to show last message posted at the top.

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

there is no replies table, all messages are in the same table. There are 2 fields in the talbe, one for the ID of the message, the other for the ParentID.

Cheers

mish

Ok, mis understood.

Filter that table on two columns....

The message parent id is filtered on the URL id that is sent, in the recordset add:

ORDER BY MessageIDname DESC



Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

yeh, i think you mean the message view, like your looking at now. im talking on the main page where all the topics are listed.

sorry to be a pain

mish

Edited by - *mish* on 02 Dec 2002 12:35:42