| Author |
 Topic  |
|
laser
Advanced Member
Australia
3859 Posts |
|
|
Alfred
Senior Member
USA
1527 Posts |
 Posted - 03 November 2003 : 23:42:50
|
That is what it should be, but what you see is just written manually in htm code.
Our true asp file does ignore Avenger (see my above post). |
Alfred
The Battle Group
CREDO
|
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 03 November 2003 : 23:46:48
|
I think we need a url - decorated.txt does not match the results on the decorated.asp page.
What does currid do ? I don't know  |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 04 November 2003 : 00:00:40
|
That is because our deorated.asp file is not on the server.
What you see is just htm code.
I updated the txt file.
"currid" is part of your code of a while back, when we tried to solve the medal display task. It makes sure that each name only shows up once. |
Alfred
The Battle Group
CREDO
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 04 November 2003 : 00:12:47
|
Alfred, "currid" is not doing anything ... it is simply set to mymedalMembers("member_id") and then compared to it.
I think for any custom code problem, you need to supply a txt and asp version of the file. We're now onto a completely different problem that we started off with |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 04 November 2003 : 00:24:45
|
Laser, currid was part of the code you wrote some time ago for the other file, which was supposed to prevent a name to be listed more than once.
Commenting it out enables all three names to show now.
I don't really know why it was needed in the other block of code.
Anyway, Nikkol spotted it - thanks, Lady Hawkeye!
I'll try and upload the file now to the server and replace the phony decorated.asp (which is really htm code only).
PS.: Works fine and looks good now. In the old file I had the names as links to the member's profiles - would that be difficult here?
I tried this: quote:
strPlayerName = myMedalMembers("M_NAME")
numPLayerID = GetMemberID(strPlayerName)
but it gave me a "type mismatch" error. |
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 04 November 2003 01:24:38 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 04 November 2003 : 01:45:05
|
Alfred, you make it pretty hard to help you at times Anywaym here goes ...
If you are using the original SQL statement we were fixing, namely :
strSql = "SELECT MEMBER_MEDALS.MEMBER_ID, MEMBER_MEDALS.MEDAL_NAME, FORUM_MEMBERS.M_NAME FROM FORUM_MEMBERS INNER JOIN MEMBER_MEDALS ON FORUM_MEMBERS.MEMBER_ID = MEMBER_MEDALS.MEMBER_ID;"
Then you already have the MEMBER_ID. On top of that, you don't have a GetMemberID function defined in this ASP file (which is the error you are getting now). SO, you could easily achieve what you want to do by creating a link like this :
http://forum.snitz.com/forum/pop_profile.asp?mode=display&id=25525
Obviously using your url & MEMBER_ID |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 04 November 2003 : 11:46:56
|
I am really sorry, laser, because that is exactly what I try to avoid. It is always my intention to go out of my way to make sure my questions are clear, and I also try to show what I tried and what part I don't understand. And I certainly always express my appreciation.
So, to come back to the subject, I understood that we already have the member's name with myMedalMember("M_NAME"), but wasn't sure whether I needed to write that second line (numPLayerID) as well.
I now understand how to do it, and defined it going properly!
At first I had placed it outside the loop, which of course gave me the same name and ID for all records, then I realized it has to go inside the loop, after the "If currid <> mymedalMembers("member_id") then" condition.
This works now: quote:
do while not myMedalMembers.eof
If currid <> mymedalMembers("member_id") then
strPlayerName = myMedalMembers("M_NAME") '## to set up links in names ################
numPLayerID = myMedalMembers("MEMBER_ID") '###########################################
response.write "<body bgcolor=""#6600FF""><br><div align=""center"">"
response.write "<table bgcolor=""#37008A"" border=""5"" cellpadding=""5"" cellspacing=""0"" style=""border-collapse: collapse"" bordercolorlight=""#FFFFCC"" bordercolordark=""#666600"" bgcolor=""#000000"">"
response.write "<tr><td width=""100%"" align=""center"">"
response.write profileLink(strPlayerName, numPlayerID)
'myMEDALMembers("M_NAME") & "</font>" 'this works without links
response.write "<font size=""2""> / <i>" & myMEDALMembers("M_COUNTRY") & "<br><br>"
response.write DisplayMedalIcon(myMedalMembers("member_id"))
response.write "</td></tr></table></center></div>"
currid = mymedalMembers("member_id")
End If
myMedalMembers.movenext
if not myMedalMembers.EOF then
End If
loop
and looks and functions terrific! http://www.ggholiday.com/bg/forums/decorated.asp
I am learning constantly, and happy as a clam that I can do more things myself every time you guys help me solve a puzzle!
Really looking forward to the day when I can help some poor soul with a simple problem!
Meanwhile, if you don't hear from me for a while, it means I am successfully doing things I learned here! Many thanks to all!
|
Alfred
The Battle Group
CREDO
|
|
|
|
Topic |
|
Topic Locked
