Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 Post count not updating
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

masloki
Starting Member

4 Posts

Posted - 21 June 2001 :  10:55:03  Show Profile
There is a random problem where some users posts are not being counted, while others are. A member id will be have 8 occurences in FORUM_REPLY but on FORUM_MEMBER the M_POSTS will be <null>. I have not made any modifications to the sql code, only look and feel parts.

The only thing I can think of that causes this problem is we dump in the User ID's (M_NAME)and passwords(M_PASSWORD) for them along with a generic member since date(M_DATE). Is there something else that we need to add when we dump data to the DB directly instead of registering each user manually.

Running SQL Server 7 SP3 on NT4 SP6 with IIS4.

Thanks for your help!

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 21 June 2001 :  11:31:32  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
Make sure to set M_POSTS to 0 when writing the first record.

Null + Anything = Null <=== This is the root cause of your problem...

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Go to Top of Page

Wixxerd
Starting Member

25 Posts

Posted - 23 June 2001 :  20:58:28  Show Profile
quote:

Make sure to set M_POSTS to 0 when writing the first record.

Null + Anything = Null <=== This is the root cause of your problem...

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead



MUAHAHHAHAA ... This fixed it... Thanx Mucho!

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07