Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1217 | Replies: 3
 |
•
•
Join Date: May 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
How to I rearrange this so that only distance less than or equal to 25 are displayed?
For i = 1 to 20
Display(rs)
rs.MoveNext
If rs.Eof Then Exit For
If rs("distance")>25 Then Exit For
Next Last edited by peter_budo : May 3rd, 2008 at 7:42 pm. Reason: Keep It Organized - please use [code] tags
•
•
Join Date: Mar 2008
Posts: 117
Reputation:
Rep Power: 1
Solved Threads: 13
Junior Poster
first thing i noticed is that your comparison sign is incorrect:
should be
I would also change the loop, to loop till end of file instead of using the counter i, what if the records that are less than 25 are in the fileds that are not extracted by your counter.
Hope this helps a bit.
If rs("distance")>25 Then Exit Forshould be
If rs("distance")<25 Then Exit ForI would also change the loop, to loop till end of file instead of using the counter i, what if the records that are less than 25 are in the fileds that are not extracted by your counter.
Hope this helps a bit.
•
•
Join Date: Apr 2008
Posts: 11
Reputation:
Rep Power: 1
Solved Threads: 0
Newbie Poster
Nearly, should be...
If rs("distance")<=25 Then Exit For
...for less than or equal to. :o)
If rs("distance")<=25 Then Exit For
...for less than or equal to. :o)
•
•
Join Date: Mar 2008
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by webthang_rob 
Nearly, should be...
If rs("distance")<=25 Then Exit For
...for less than or equal to. :o)
If I understand the original question, then both these response seem incorrect. My interpretation of your response is that the "loop" will stop at the first occurence of a distance < 25. The poster seem to be asking for loop that will display only distants under 25, which I interpret as " show me all the distants that are < 25.
Therefore, he must use something such as :
do while not rs.eof
if rs("distant")<25 then
response.write " display me" ' or whatever he wants to do
end if
rs.movenext
loop
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
