ReLoad drop down the way it origionally loaded

ralphtrent · Jul 16, 2003

Hello
I am creating an ASP app that will load a list of users based on SQL. My goal is to select from the list and process my form and keep the user selected in the drop in its origionaly place. I am reshowing the form at the top of the page. I have it so it will show the default to the users name but still show him in the origial order. So it shows him twice. I want to only see him once, in his origional place. Any Help, please let me know.

Thanks
Ralph

baddos · Jul 16, 2003

Do While NOT objRS.EOF
Response.Write "<option value="& chr(34) & objRS.Fields.Item("myfield&quot

& chr(34)
If objRS.Fields.Item("myfield&quot

= Request.Form("myfield&quot

Then
Response.Write " selected"
End If
Response.Write ">"
Loop

ralphtrent · Jul 16, 2003

does it need to be a record set?

baddos · Jul 16, 2003

No... You could do the same thing from an array or collection.

jlgdeveloper · Jul 16, 2003

Ralph

Simply pass the user name/id on to the new page in a querystring.
Load the same dropdown the same way.
In the body onload event (<body onload="doLoad()&quot

fire off the following client side vbscript:

sub doLoad()
<%if request.querystring("dropdown&quot

<>"" then%>
form.myDropdown.value='<%=request.querystring("dropdown&quot

%>'
<%end if%>
end sub

That will load your dropdown to the user you want only when there is a querystring value for dropdown. Place this code in client side script tags.

Jonathan Galpin MCSD

http://www.iqzero.net

because software should be easy to use

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

ReLoad drop down the way it origionally loaded

ralphtrent

Programmer

baddos

MIS

ralphtrent

Programmer

baddos

MIS

jlgdeveloper

Programmer

Similar threads

Part and Inventory Search

Sponsor