Ok another (very)newbie question.

Results 1 to 2 of 2

Thread: Ok another (very)newbie question.

  1. #1
    Join Date
    Dec 1969

    Default Ok another (very)newbie question.

    I am submitting a query from a list box and searching the database for a doctors specialty. I think the syntax goes something like- SELECT Specialty FROM Results where Specialty(whatever). How is the selected item from the list box passed to the querry string. How do i need to write the querry so that whatever is selected is passed?

  2. #2
    Nate Johnson Guest

    Default RE: Ok another (very)newbie question.

    intList = request.form("name_of_listbox")<BR>strSQL = "select specialty from TABLENAME where specialty = "<BR>strSQL = strSQL & intList

Posting Permissions

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