Select Now Won't Display Any Array Elements - Too Much Data Now? 1

[Coder7]

Have you ever heard of a listbox (select) that stopped displaying any values in it? I have a production application that has not be changed in any way. The data, however has increased and there are huge amounts of data now being returned from the sql server database that are supposed to display in the select but not even one displays.

General question, has anyone heard of this happening due to an increased amount of data being loaded to the select? I've done lots of web searches but am getting nothing back .

I'll go through the asp thoroughly this weekend but thought I'd see if anyone ever heard of this.

Thanks for all insight

 

[JSpicolli]

Prolly not a max count issue, since this works.

<SELECT NAME="TEST">
	<%  
		For x = 1 To 100000
			Response.Write("<Option value='" & x & "'>" & x & "</Option>")
		Next
	
	%>
</SELECT>

 

[Coder7]

Thanks..one less thing to look at. I'm going through the asp now so I can post some specific code here.

Really appreciate your reponse....have a great weekend!

 

[Sheco]

Take a look at the HTML that is actually generated.

If it is coming out right then you have a browser problem... if the HTML is screwy then you have an ASP problem.

If it is true that NOTHING has changed then you might check these for a timeout fetching the data for the recordset.

Also there may be values in the data that were not in there before... and the ASP code may not handle these values very well. A bug like this could have been there all along but since the specific value that causes the problem was not included in the data, the bug was unknown. The special value Null can often do this... also look for numbers where the code expects only a positive integer greater than 0 and string where the code doesnt expect a zero-length string.

 

[Coder7]

REALLY great pointers, Sheco - exactly what I needed, thanks!

This code was written by someone else so I'm going through it now to see exactly what it's doing. I'll let you know what I find out.