ASP retrieving data from recordset array.
I'm having some trouble with the following:
My Main array has been set up earlier in the code by
arrSignType = rsFindSign.GetRows(,,Array("SignID",..."SignSize", "SignSort" ))
All these columns match from the DB (having been copied and pasted a dozen times from the SQL.) Now I try to use the data from this array...
<option value="<%=pSize %>"><%=pSize%></option>
(This option shown above I assigned earlier and works ok. It is only for test and is to be removed.)
Dim j, found, sizeValue
For i = 0 to UBound(arrSignType,2)
pSize = arrSignType(7,i)
sizeValue = ""
found = false
select case trim(LCase(pSize))
sizeValue = "L"
sizeValue = "S"
sizeValue = "M"
For j = 0 to UBound(tempArray)
if tempArray(j) = pSize then
found = true
if not found then
redim preserve tempArray(UBound(tempArray) + 1)
tempArray(UBound(tempArray)) = pSize
response.write (VbCrLf & "<option value=""" & sizeValue & """>" & pSize & "</option>")
size |<%=arrSignType(7,0)%>| found.
If I print out the UBOUND(arrSignType,2) it reads that 29 entries are present. The above string arrSignType(7,0) prints out as "".
This is probably something really silly I'm overlooking but I can't for seem to work it out. Been coming back to this for a couple of days now!!
Any help would be gratefully appreciated.
Cheers in advance Jas.