Hello,
I am trying to populate a couple of drop down boxes for selection. I posted before on this, but I am wondering if, in the section of BuildSelect control where the strSQL is getting the values, can a muli-dimensional array be declared here? I assume, also, that the section below
while not rsTemp.Eof
if rsTemp(0)=strValue then
BuildSelectControl = BuildSelectControl & "<option value=""" & rsTemp(0) & """ selected>" & rsTemp(1) & "</option>"
else
BuildSelectControl = BuildSelectControl & "<option value=""" & rsTemp(0) & """>" & rsTemp(1) & "</option>"
end if
rsTemp.MoveNext
wend
BuildSelectControl = BuildSelectControl & "</select>"
rsTemp.Close
set rsTemp = Nothing
else
would need changed to 'read in' the 2nd or 3rd column values..
Just not sure how to go about this...maybe I can use a get rows method in the SQL query?
Very new to asp, and am really stuck on this one. I know I need to modify the generated code, and am aware of the different methods, just not sure which/how to implement.
I would surely appreciate any pointers you could provide.
On my earlier post, Sergey answered to load the values when the page loads. Couldn't I also do that within the Buildselect....?
Sorry so lengthy,
B