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

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Totally confused .....
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Webbo
Average Member

United Kingdom
982 Posts

Posted - 05 February 2011 :  17:31:33  Show Profile  Visit Webbo's Homepage  Reply with Quote
I'm running a modified version of Snitz 3.4.03 (with all security fixes) and have a test forum running version 3.4.06

Within both forums I have added several lines including the following within pop_profile.asp in order to output a members site support renewal date in the header at the top of their profile...

quote:
if MemberID = ppMember_ID then
Response.Write " <td valign=""top"" align=""center"" bgcolor=""" & strHeadCellColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Site Supporter renewal: " & ChkDate(rs("M_SPONSORDATE"),"",false) & " </font></td>" & vbNewLine
end if


Which basically checks to see if the user is looking at their own Profile page and if so should display "Site Supporter renewal: and date"

The really confusing bit is within my test forum (3.4.06) it works perfectly however within the 3.4.03 forum whilst it displays "Site Supporter renewal: " it does not display the date


I can't see any reason why it shouldn't, the ChkDate function works further down both files when displaying M_DATE

Both files include db calls:
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_SPONSORDATE"

and the only thing I can think of is that there must be a slight code change somewhere within the rest of the files that enables it to work in one but not the other.

I've been working on this on and off now for a while and never managed to get to the bottom of it, so any help or suggestions would be appreciated

Thanks in advance


Carefree
Advanced Member

Philippines
4224 Posts

Posted - 17 February 2011 :  08:48:37  Show Profile  Reply with Quote
Did you look at one of the suspect dates in the 3403 database & make sure it follows the yyyymmddhhmmss format?
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts

Posted - 19 February 2011 :  17:20:03  Show Profile  Visit Webbo's Homepage  Reply with Quote
You're a star Carefree

Comparing the two databases I had the M_SPONSORDATE type for the 3.4.03 database set as 'text'
Changing it to 'varchar(14)' did the job

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