Passing values in ASP using str

Discussion in 'C#' started by GoDoTrance, Jun 19, 2008.

0
  1. #1
    I have the following code:

    str = "execute sq_nameofquery;"

    I need to be able to pass the Session("Username") into the query. Somewhat new to this so anyone got any ideas on how to do this prior to the point where I

    Set RS = Conn.Execute (str)

    ?????????
     
    GoDoTrance, Jun 19, 2008 IP
  2. GoDoTrance

    GoDoTrance Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    For those of you that were curious, I figured it out on my own. Here is what I used


    strUser = "exec sq_queryname " & Session("Username")
     
    GoDoTrance, Jun 19, 2008 IP