Results 1 to 1 of 1

Thread: ASP : Populate drop down list

  1. #1
    125
    posts
    Registered User

    ASP : Populate drop down list

    Hi,

    I'm having trouble populating a form dropdown box from a access DB RS. Does anyone know of a way to do this and that allows you to change the value of the dropdown and
    re-submit?

    Code:
     
    Response.write("<option value='Corporate'>Corporate</option>")
    Response.write ("<option value='Customer Services'>Customer Services</option>")
    Response.write ("<option value='Authoring Creative'>Authoring &amp; Creative</option>")
     Response.write ("<option value='Production'>Production</option>")
     Response.write ("<option value='Finance'>Finance</option>")
     Response.write ("<option value='Artwork'>Artwork</option>")
     Response.write ("<option value='It'>IT </option>")
    Response.write ("<option value='Warehouse'>Warehouse</option>")
    Response.write ("<option value='Sales'>Sales</option>")
    Response.write ("<option value='Purchasing'>Purchasing</option>")
    Response.Write("<option selected=""selected"" value=""" & recordset("strDepartment") & """>" & _
                          recordset("strDepartment") & "</option>")
    ok, so the above code select the relevent department from the db but it duplicates.

    Thanks
    Last edited by burns; January 9th, 2007 at 10:42 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012