Results 1 to 2 of 2

Thread: Please help SQl Statment

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Feb 2000
    Posts
    81

    Red face

    Ok i have a ComboBox on an asp form with three different values in it the values represent table names in my database

    ie
    LEvelOne
    LevelTwo
    LevelThree

    i want my statement to
    "Select * from " & "Combobox"


    Select* data from the name of the table????
    can this be done and how please im stuck on it???

  2. #2
    chenko
    Guest
    Im a little confused as to what you want......

    <%
    ComboValue = Request.Form("Combo1")
    sSQL = "SELECT * FROM " & ComboValue & "......."
    %>

    Try that.
    Si

Posting Permissions

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



Click Here to Expand Forum to Full Width