Link to home
Start Free TrialLog in
Avatar of kdeutsch
kdeutschFlag for United States of America

asked on

Get values from request querystring

I am trying to get the values of my query string so that I can repopulate the page with the information that I originally saved from the page.  This query string was passed by Javascript so I don't know how to get the values out of it.  the first is my query string, the first value is the date, then the  (tf=36) and then the Uic=PUPAA.  I need to get these 3 values to pass to an sql statement to pull data to repopulate my page.  

http://ngmnc2-j6ops-a5/SADDotNet1/Documents/AttendanceForm.aspx?dt=24%20Jun%202008&tf=36&uic=PUPAA

This is the javascript that passed the values to the querystring to get to other page.
<script language="javascript">function showForm(theDate) {theTF = document.Form1.ddlTaskForce.value; theUIC = document.Form1.DDLUIC.value;
window.location.replace("AttendanceForm.aspx?dt=" + theDate + "&tf=" + theTF + "&uic=" + theUIC);
            }                              
</script>
Avatar of skiltz
skiltz
Flag of New Zealand image

in the code behind use request.querystring("tf")
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kdeutsch

ASKER

Ok here is what I have so far.

 Dim id As String

        id = Request.QueryString("ID")

        If id = "" Then
            Response.Redirect("Attendanceform.aspx")
            Response.End()
        End If

        sql = "select strUic from tblUIC where strUIC = " & id
        Response.Write(sql)
        Response.End()

It locks up on me at this point,  I thought I needed to pas the value to the sql string some how.