When I hit save button, the names which are in the List box When
I select one of them. When I hit save button, it goes off, but it saves in the data base. When I try to retrieve it, it displays the one
which I selected. I dont want the one to be clear off when i hit save button.

assume you are using "save" as type of submit, after submit to the same page, you should let list box know what you have been submitted.
do this:
<select name=slt>
<option selected value=<%=request.form("slt")%> request.form("slt") </option>
'if u get more options juz do it like before
</select>

cheers

hi
I am not really sure what exactly you mean here, say you have a form with list of entries to be made and a list box which displays some LOV's. Now do you mean to say that once you hit the save button, it should save the entries in DB and return back to the same form with new entry?? do let me know with clarity.
Regards

sinapra

Hi shoakat,

I had posted the answer to similar query from you a couple of months back. But did not know from you then, if you tried that or successfuly incorporated that method.

Take a look at that thread here --> Html Read my second reply to that post. That holds the answer for this post.

sinapra,
He wants to maintain the same value being SELECTED on the list box after writing it to the database.

In this case the requested value should be used in place of constants there in the other post I referred here.

Eg: Cheers!

_________________________
- Vijay G
Strive for Perfection

Actually the list Box has like hundreds of employees name
present in the data base. I can add employee and delete employees
easily in the data base. The code you are referring will not work in this case employees name goes on changing, we can add or delete any time we create. the code which you refereed works fine if there are three or four options. But in employee there are 100 of employees. So hard coding is not possible.
 what i am trying to do
if strEmpId ="" or isNull(strEmpId then
str empid ="0"
end if
if strReports ="" or isNull(strReports) then
strReportsTo="0"
 if cInt(strReports) = cint(EmpId)
str selected = " selected ". The problem is that i dont understand the code. I know what it is doing. Your help will be appreciated

What I am trying to do employees are reporting to different bosses.
The employees bosses change whenever I want to. I have created two
objects one for employee and other for manager. Employees are itself
managers. Managers are in the list box and they are in the db. So I am checking in the loop. So what happens when I select managerName in the list box and I hit save. It saves in the data base, but i dont want the manager name which I selected to clear off when I hit save button.
shoakat

Hi,

The code I posted it a sample that does what exactly you wanted. But there the data is constant as per my code. You can use the same logic to implement that with values from database.

Hope that explains.
Cheers!

_________________________
- Vijay G
Strive for Perfection