I have a chart which displays data. The primary, unique field for the table is ChartID. The first column displays city, state. The city and state link to another page which is an update form. The update form does have a password associated with it. I want the link to open a new form for the specific city,state associated with the ChartID. My SQL statement is:
sql = "SELECT tblGeneral.ChartID, tblGeneral.City, tblGeneral.State, " & _
"tblStaff.LNOStaffDesignat
ion, tblStaff.StaffGenNotes, tblStaff.FTE,
"FROM tblGeneral INNER JOIN tblStaff ON tblGeneral.ChartID= tblStaff.ChartID " & _
"WHERE tblStaff.LNOStaffDesignati
on = 'In Transition' "
My display code for the link to the update form is:
Response.Write "<TD class='CCTable' width='175px'><a target='_blank'
href='
http://vaww.MyWebSite/SiteDetails.asp?step=1&ChartID=" & objRS("ChartID")
Is there code I can use to pass the password to the SiteDetails page so it will open?