Choosing either form using the while statement

**tgmiller5** · 05-28-2009, 01:18 PM

I am stuck with this. If a number is after 5 then it goes to the other form but if it is before the number 5 it is goes to the first form. Here is the code.

rs.Open sqlstatement, connection

While Not rs.EOF
response.write "<tr>"
response.write "<td> "& rs.Fields("NAME") &" </td>"
response.write "<td><a href=testforms.asp?class_code="& class_encoded &"&number="& rs.Fields("number") &">"& rs.Fields("CODE") &"</a></td>"
response.write "<td>"& rs.Fields("number") &"</td>"
response.write "<td>"& rs.Fields("campid") &"</td>"

if Session("Number") >= 5 then

response.write "<tr>"
response.write "<td> "& rs.Fields("NAME") &" </td>"
response.write "<td><a href=testenew.asp?class_code="& class_encoded &"&number="& rs.Fields("NUMBER") &">"& rs.Fields("CODE") &"</a></td>"
response.write "<td>"& rs.Fields("number") &"</td>"
response.write "<td>"& rs.Fields("campid") &"</td>"
response.write "</tr>"
end if
' loop
rs.MoveNext
wend

**Kulrom** · 12:09 PM

And how do you increment the session object?
You seem to be missing the portion Session("Number") += 1 in the While block.
Otherwise please be more specific

**Kulrom** · 05-31-2009, 06:21 AM

hey Mods .. are you following this guy? Please take care of this mortgage adverts.

**harish** · 06-02-2009, 03:44 AM

try this code hope this code will work..

Code:

<% 
dim number=0
While Not rs.EOF
response.write "<tr>"
response.write "<td> "& rs.Fields("NAME")  &" </td>"
response.write "<td><a href=testforms.asp?class_code="& class_encoded &"&amp;number="& rs.Fields("number") &">"& rs.Fields("CODE") &"</a></td>"
response.write "<td>"& rs.Fields("number")  &"</td>"
response.write "<td>"& rs.Fields("campid")  &"</td>"
 
if Session("Number") >= 5 then 

response.write "<tr>"
response.write "<td> "& rs.Fields("NAME")  &" </td>"
response.write "<td><a href=testenew.asp?class_code="& class_encoded &"&amp;number="& rs.Fields("NUMBER") &">"& rs.Fields("CODE") &"</a></td>"
response.write "<td>"& rs.Fields("number")  &"</td>"
response.write "<td>"& rs.Fields("campid")  &"</td>"
response.write "</tr>"
end if 
number=number+1
  wend
rs.MoveNext

%>