Snitz Forums 2000

Snitz Forums 2000

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

Totally confused .....

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:

UserName:

Password:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

[quote][i]Originally posted by Webbo[/i]
[br]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[/quote]

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

[/quote]

Check here to include your profile signature.

T O P I C R E V I E W
Webbo	Posted - 05 February 2011 : 17:31:33 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
2 L A T E S T R E P L I E S (Newest First)
Webbo	Posted - 19 February 2011 : 17:20:03 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
Carefree	Posted - 17 February 2011 : 08:48:37 Did you look at one of the suspect dates in the 3403 database & make sure it follows the yyyymmddhhmmss format?

Snitz Forums 2000

This page was generated in 0.04 seconds.