I seem to have a problem with some data in SQL 2000, data which is being presented to the user in a drop down menu in my program with the aid of stored procedures (which gets the info from the database), ASP and VBScript.
In the database there are 103 rows of information, and these rows can all be seen in the drop down menu. However, from 100 through to 103 they are not being displayed to the screen when they are selected by the user. So, select row "99" and press "submit" and the information is displayed to the screen, but this is not the case for 100-103, all you get is a blank screen.
Hope i have explained myself properly, if not please shout.
Any ideas as to why this may be happening / point me in the right direction would be greatly appreciated.
Just to let you all know the problem has been sorted.
It was due to an error within a function that checked for null values, it was set to 99 and so didnt display anything beyond that (it has now been changed).
The code was:
Function checkValue (rawData)
if isNull(rawData) Then rawData = 0
if Len(Trim(rawData)) = 0 then rawData = 0
if NOT IsNumeric(rawData) Then rawData = 0
if rawData < 0 or rawData > 99 then rawData = 0
checkValue = rawData
Thank you for all your post, and help in working to resolve the issue, much appreciated.