|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Loop will not stop!
I have a query to dislay text from my SQL database onto a table on my web page. The query works in Management Studio, but when I apply it to my web page (ASP, VBScript) it goes into an unending loop. Here's the code. The '" &session("folder_id") & "'" merely maintains the session with the client after successful login. Any help would be appreciated!
<% sql1= "select [view contact].folder_id, [view contact].contactname, jobmaster.id as iid, jobmaster.customernumber, jobmaster.jobnumber, jobmaster.partnumber, jobmaster.jobdescription, jobmaster.quantity, jobmaster.mastervalidate from fp_vticket.dbo.[view contact], confirm.dbo.jobmaster where jobmaster.customernumber = '" &session("folder_id") & "'" sqlrdy = sql1 if rstemp.state=1 then rstemp.close rstemp.open sqlrdy,conn,3,1 do while not rstemp.EOF %> <% if(counter mod 1 <>0) then %> <tr> <% else %> <tr > <% end if counter=counter+1 %> <td align="center"> <%=rstemp("jobnumber") %> </td> <td align="center"> <%=rstemp("partnumber") %> </font></td> <td align="left"> <%=rstemp("jobdescription") %> </font></td> <td align="left"> <%=rstemp("quantity") %> </font></td> <td align="left"> <%=rstemp("mastervalidate") %> </font></td> <td align="left"> <a href="track.asp?id=<%=rstemp("iid")%>&jobnum=<%=rstemp("jobnumber")%>"> Track</a></li> <%rstemp.movenext loop %> |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Loop will not stop! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|