ASP position question
am 04.12.2005 21:18:43 von jeffOk gang, I am going to try and explain my question.
I have a page where a person's position is listed. This is what I am using
to get that position.
I first sort by the round field in the DB, then I display the table on the
page. The problem I have is, if there are say 2 people with the same round
number, it continue's counting. For example
http://65.61.20.190/GIG/ladder/main.asp
see how the 4th and 5th place show the same number of laps )that is the
number in the round field in the DB), what I want is to show both of them
with a 4. here is my script:
<%
set admin1 = conn.execute ("SELECT * FROM rounds where round > 0 ORDER
BY round DESC,username ASC")
%>
GIG Ladder Lap Count
<%
game = 1
do while not admin1.eof
var1 = admin1.fields.item("round").value
var2 = admin1.fields.item("username").value
%>
<%
game = game + 1
admin1.movenext
loop
%>
as you can see game is the position column in the displayed table.
How can I have it show the same pos for a number that is the same, but
continue counting as if they were NOT the same. Meaning, if there was a
person below them, they would be in 6th place, since 2 are tied for 4th?
I hope this makes sense
Please help
Bam
Re: ASP position question
am 04.12.2005 21:38:27 von exjxw.hannivoortJeff wrote on 04 dec 2005 in microsoft.public.inetserver.asp.db:
> Ok gang, I am going to try and explain my question.
Please do not multipost on usenet.
--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)
Re: ASP position question
am 04.12.2005 21:44:39 von jeffsorry.... i tried to delete this one
"Evertjan."
news:Xns9722DC29F158eejj99@194.109.133.242...
> Jeff wrote on 04 dec 2005 in microsoft.public.inetserver.asp.db:
>> Ok gang, I am going to try and explain my question.
>
> Please do not multipost on usenet.
>
> --
> Evertjan.
> The Netherlands.
> (Replace all crosses with dots in my emailaddress)
>
Re: ASP position question
am 04.12.2005 22:15:26 von exjxw.hannivoortJeff wrote on 04 dec 2005 in microsoft.public.inetserver.asp.db:
> sorry.... i tried to delete this one
Ok
--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)
Re: ASP position question
am 06.12.2005 21:31:16 von mmcginty"Evertjan."
news:Xns9722DC29F158eejj99@194.109.133.242...
> Jeff wrote on 04 dec 2005 in microsoft.public.inetserver.asp.db:
>> Ok gang, I am going to try and explain my question.
>
> Please do not multipost on usenet.
Hey Evertjan, if you have nothing else to contribute, why don't you just
keep your little netiquette admonitions to yourself -- because actually,
since it had absolutely nothing to do with ASP, your post was off-topic.
-----
Jeff,
The code below will do what you described. It tracks the value of the
previous row's round value, and offsets the position incrementally for as
long as the current value equals the previous value. When that is not the
case, the offset reverts to 0 and the position reflects the number of
players involved.
Any help?
-Mark
(btw, I took the liberty of improving the readability of your code, for
whatever it's worth.)
style="border-collapse: collapse; width: 27%;">
GIG Ladder Lap Count
Pos
Name
Laps
<%
Dim game, round, username, lastround, tieoffset
game = 1
tieoffset = 0
do while not admin1.eof
round = admin1.fields("round").value
if (round = lastround) then
tieoffset = tieoffset + 1
else
tieoffset = 0
end if
username = admin1.fields("username").value
%>
<%=game - tieoffset %>
<%=username %>
<%=round %>
<%
game = game + 1
lastround = round
admin1.movenext
loop
%>
> Evertjan.
> The Netherlands.
> (Replace all crosses with dots in my emailaddress)
>
Re: ASP position question
am 06.12.2005 21:43:07 von exjxw.hannivoortMark J. McGinty wrote on 06 dec 2005 in microsoft.public.inetserver.asp.db:
>> Please do not multipost on usenet.
>
> Hey Evertjan, if you have nothing else to contribute, why don't you just
> keep your little netiquette admonitions to yourself -- because actually,
> since it had absolutely nothing to do with ASP, your post was off-topic.
You are wrong, Mark.
Per Netiquette, items concerning the posting are on topic.
--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)
Re: ASP position question
am 06.12.2005 21:53:12 von mmcgintyRegardless, give it a rest, it's getting old... don't you have anything
better to do?
-Mark
"Evertjan."
news:Xns9724DCF02CAACeejj99@194.109.133.242...
> Mark J. McGinty wrote on 06 dec 2005 in
> microsoft.public.inetserver.asp.db:
>>> Please do not multipost on usenet.
>>
>> Hey Evertjan, if you have nothing else to contribute, why don't you just
>> keep your little netiquette admonitions to yourself -- because actually,
>> since it had absolutely nothing to do with ASP, your post was off-topic.
>
> You are wrong, Mark.
> Per Netiquette, items concerning the posting are on topic.
>
> --
> Evertjan.
> The Netherlands.
> (Replace all crosses with dots in my emailaddress)
>
Re: ASP position question
am 06.12.2005 22:00:43 von exjxw.hannivoortMark J. McGinty wrote on 06 dec 2005 in
> "Evertjan."
>> Mark J. McGinty wrote on 06 dec 2005 in
>>>> Please do not multipost on usenet.
>>>
>>> Hey Evertjan, if you have nothing else to contribute, why don't you
>>> just keep your little netiquette admonitions to yourself -- because
>>> actually, since it had absolutely nothing to do with ASP, your post
>>> was off-topic.
>>
>> You are wrong, Mark.
>> Per Netiquette, items concerning the posting are on topic.
> Regardless, give it a rest, it's getting old... don't you have
> anything better to do?
"regardless"
So you concede you were wrong in your argument?
"it's getting old"
So you knew it was wrong?
"don't you have anything better to do?"
That is off topic!
--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)
Re: ASP position question
am 08.12.2005 02:12:16 von mmcginty"Evertjan."
news:Xns9724DFEBC1189eejj99@194.109.133.242...
> Mark J. McGinty wrote on 06 dec 2005 in
>
>> "Evertjan."
>>> Mark J. McGinty wrote on 06 dec 2005 in
>>>>> Please do not multipost on usenet.
>>>>
>>>> Hey Evertjan, if you have nothing else to contribute, why don't you
>>>> just keep your little netiquette admonitions to yourself -- because
>>>> actually, since it had absolutely nothing to do with ASP, your post
>>>> was off-topic.
>>>
>>> You are wrong, Mark.
>>> Per Netiquette, items concerning the posting are on topic.
>
>> Regardless, give it a rest, it's getting old... don't you have
>> anything better to do?
>
> "regardless"
> So you concede you were wrong in your argument?
Netiquitte is just like etiquitte, it's a personal thing, there is no right
and no wrong. I was not agreeing with you, I was dismissing you, as your
point is inarguable. What are you, like a Martha Stewart wannabe?
> "it's getting old"
> So you knew it was wrong?
Your self-appointed netiquette police crap is getting old, give it a freakin
rest, for heaven's sake! 90% of what you post pertains exclusively to
telling other people how to post, and I'm tired of it, it's boring, it's
pointless, it's irritating.
Etiquitte is about courtesy and consideration. It's more of a concept than
an implementation. Think about it.
If you want to further this discussion, email me privately.
-Mark
> "don't you have anything better to do?"
> That is off topic!
>
> --
> Evertjan.
> The Netherlands.
> (Replace all crosses with dots in my emailaddress)
>
Re: ASP position question
am 09.12.2005 21:52:04 von Kyle PetersonI agree 100%
Give it a rest Evertjan, you must be the most anal person in real life to
act the way you do here.
BTW: I top posted again just for you. :)
"Mark J. McGinty"
news:eMAqaQ5%23FHA.160@TK2MSFTNGP12.phx.gbl...
>
> "Evertjan."
> news:Xns9724DFEBC1189eejj99@194.109.133.242...
>> Mark J. McGinty wrote on 06 dec 2005 in
>>
>>> "Evertjan."
>>>> Mark J. McGinty wrote on 06 dec 2005 in
>>>>>> Please do not multipost on usenet.
>>>>>
>>>>> Hey Evertjan, if you have nothing else to contribute, why don't you
>>>>> just keep your little netiquette admonitions to yourself -- because
>>>>> actually, since it had absolutely nothing to do with ASP, your post
>>>>> was off-topic.
>>>>
>>>> You are wrong, Mark.
>>>> Per Netiquette, items concerning the posting are on topic.
>>
>>> Regardless, give it a rest, it's getting old... don't you have
>>> anything better to do?
>>
>> "regardless"
>> So you concede you were wrong in your argument?
>
> Netiquitte is just like etiquitte, it's a personal thing, there is no
> right and no wrong. I was not agreeing with you, I was dismissing you, as
> your point is inarguable. What are you, like a Martha Stewart wannabe?
>
>> "it's getting old"
>> So you knew it was wrong?
>
> Your self-appointed netiquette police crap is getting old, give it a
> freakin rest, for heaven's sake! 90% of what you post pertains
> exclusively to telling other people how to post, and I'm tired of it, it's
> boring, it's pointless, it's irritating.
>
> Etiquitte is about courtesy and consideration. It's more of a concept
> than an implementation. Think about it.
>
> If you want to further this discussion, email me privately.
>
>
> -Mark
>
>
>> "don't you have anything better to do?"
>> That is off topic!
>>
>> --
>> Evertjan.
>> The Netherlands.
>> (Replace all crosses with dots in my emailaddress)
>>
>
>