Drop lists

Results 1 to 2 of 2

Thread: Drop lists

  1. #1
    Join Date
    Dec 1969

    Default Drop lists

    I need to know how to create a drop list which is bound to a database. Once the drop list is clicked it will drop down a list with say all clients in a client table. This I can do ok but I need to then be able to select a required client and it will then populate say a form with all the clients details. What I want to do is to then edit the client data and then send back the new data to the database

  2. #2
    Join Date
    Dec 1969

    Default You did the hard part...

    SO if you have<BR><BR>&#060;SELECT Name="Employee"&#062;<BR>&#060;OPTION Value="7132"&#062; John Jones<BR><BR>and the user selects that, then in the next page you do<BR><BR>&#060;%<BR>... make the DB connection ...<BR><BR>SQL = "SELECT * FROM EmployeeInfo WHERE EmpID=" & Request("Employee")<BR>Set RS = conn.Execute(SQL)<BR>If RS.EOF Then<BR> Response.Write "Major error: No info for employee id " & Request("Employee")<BR> Response.End<BR>End If<BR><BR>... show the info about the given employee...<BR><BR>%&#062;<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts