listbox results 1

[taoist]

I have a record set that shows multiple records.
and I have my listbox that is bind to a column in the table

I think the problem is in the repeated session where I get multiple records from my query.

So when I run the query I get:

Response object error 'ASP 0251 : 80004005'

Response Buffer Limit Exceeded

Execution of the ASP page caused the Response Buffer to exceed its configured limit.

.......................................................

here is the code for my listbox

<form id="form2" name="form2" method="post" action="">
<% If Not rs.EOF Or Not rs.BOF Then %>
<table width="512" border="1">
<%
While ((Repeat1__numRows <> 0) AND (NOT rs.EOF))
%>
<tr>
<td width="214"><label>
<input name="chk" type="text" id="chk" />
</label></td>
<td width="98" height="39"><%=(rs.Fields.Item("LAST").Value)%></td>
<td width="86"><label>
<select name="FIRST_GRADE" id="FIRST_GRADE"> -------MY LISTBOX
<option value="value">A</option>
<option value="value">B</option>
<%
While (NOT rs.EOF)
%>
<option value="<%=(rs.Fields.Item("INDEX1").Value)%>"><%=(rs.Fields.Item("FIRST_GRADE").Value)%></option>
<%
rs.MoveNext()
Wend
If (rs.CursorType > 0) Then
rs.MoveFirst
Else
rs.Requery
End If
%>
</select>
</label></td>
<td width="86"><label></label></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rs.MoveNext()
Wend
%>

 

[onpnt]

you can set the buffer = false at the top of the script.





General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[Sheco]

You can also use a counter and call Response.Flush after ever X number of loop iterations.

PS: If the response buffer is filling up with only options for a dropdown list then that might be too many options to be useful.

 

[onpnt]

much better solution with the .Flush Sheco





General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[taoist]

Sheco I have never done that.

what would be the exact scripting for that and where would I put it in my code