How do you count the replies in a thread?

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

How do you count the replies in a thread?

Author

Message

Rey

Posted: 08/30/2004, 6:25 PM

Can any one help me add the # of replies to a thread in the sample forum that came with CodeCharge Studio using the same Database.

Nicole

Posts: 586

Posted: 08/31/2004, 4:30 AM

Rey,
Add special Label to a grid form on Default page that displays number of replies. In its Before Show event (or in Before Show Row event of a grid) use code like:

  
messages.Label1.Value = CCDLookUp("count(*)", "forum_messages", "message_id_parent=" & DBConnection1.ToSQL(messages.Label1.Value, ccsInteger), DBConnection1)

of course use real field, form and connection names

_________________
Regards,
Nicole

Rey

Posted: 09/03/2004, 6:38 PM

Thanks Nicole I wish I can repay.

Rey

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login