Add new values into Dropdown?

[jgoodman00]

I have a dropdown box which gets its values from a db table.

I need to give users the ability to add new entries to the dropdown.

What is the simplest way of doing this?



James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[YNOTU]

[tt]
1. Create a edit page with the field you need
2. Create an asp page what will do the insert into the DB

3. After inserting, redirect the user to the page with the drop-down.

 

[jgoodman00]

I understand points 1 & 2, & have already done this.

How do I automatically redirect the user back to the data-entry form as part of the asp processing page?

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[Tarwn]

After the insert you can Response.Redirect "yourPage.asp" to redirect back to the page (if you haven't output anything in the insert page).

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[YNOTU]

[tt]
<%
response.redirect &quot;your_drop_down_page.asp&quot;
%>

at the end of the processing page should take care of it.

 

[Questionaire]

Dear
You can do it with javascript code if you like

http://webdeveloper.earthweb.com/repository/javascripts/2003/07/227971/pp_editable_dropdown.html