Totally confused ..... - Posted (1016 Views)
Average Member
Webbo
Posts: 982
982
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...
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


 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Advanced Member
Carefree
Posts: 4224
4224
Did you look at one of the suspect dates in the 3403 database & make sure it follows the yyyymmddhhmmss format?
Posted
Average Member
Webbo
Posts: 982
982
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

 
You Must enter a message