HTML Select Problem

[Beacon]

Hey All

I hope a explain the clearly enough.

I have 2 fields from 1 table:
EmployeeID
Employee_Name

I load the ASP page and it fills a Select\DropDown list with the EmployeeName's from the database.

The user selects the name they wish from the list, changes some other details and submits the form.

Now how do i convert the employee name back to the correct Employee_ID??

Especially if their are 2 emplyee's with the same name?

cheers
b

[mendhak]

You'll have a

<SELECT>
<OPTION Value="his_employee_id">his_employee_name</option>
....
</SELECT>



You can work with the value, no?

[Danial]

Hi Beacon,
Good to see you here, i thougt you left VBF.

Anyhow the most efficient way to use The ID field as its the primary key. Simply set the Value property to the EmployeeID and display Employe Name.

E.g

<select name="Emp_List">
<%
do while not rs.eof
response.write "<option value=" & rs("EmployeeID") & ">" & rs("EmployeeName") & "</option>"
 
rs.movenext
loop
%>
</select>

Now when you submit the form the EmployeeID field will be submited, now you can easily identify the rows uniquley.

e.g

dim EmpId
dim sql
 
EmpID=request.form("Emp_List")
 
sql="Update Employe set Emp_Location='London' Where EmployeeId=" & EmpId
 
conn.execute (sql)

Hope this helps.

[Danial]

Originally posted by mendhak
You'll have a

<SELECT>
<OPTION Value="his_employee_id">his_employee_name</option>
....
</SELECT>



You can work with the value, no?

Got there before me, Damm i type too slow . May be i should do more one liner

[mendhak]

And that ain't even the reason why they call me the fastest fingers in the west

[Danial]

Originally posted by mendhak
And that ain't even the reason why they call me the fastest fingers in the west

Lol, yes i heard the rumours that alien frog do have fast and long fiengers

[Beacon]

G'day boys

How's things?

excellent...why didnt i think of that before hand.
thanks the both of you.

Yeah i left VBF for GalahTech and then for Neowin. But Neowin has know Porgramming section and GT had no users.

With my new job it's hard to browse forums for more than 10min.

But if you put up a petition in Chit Chat i could submit it too my boss.

cheers
b