C
Chieko Kuroda
Hello all,
I would like to learn the syntax for passing variables that I retreived from
a database to a second asp page. Currently, I'm using:
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a href=
""InterviewerInfo2.asp?timeID=" & rs("Starttime") & " "">"
How do I add more variables to my link: <a href = ...?
ie Nameofcandidate and InterviewDate
in this context:
' Iterate through times
While Not(RS.EOF)
' If date changes
If lDateID<>RS("DateID") Then
' If this is not first date, close out previous group
If lDateID>0 Then Response.write "</tr><tr><td
height=10><hr></td></tr>"
' Print header for new group
Response.write "<tr><td>Candidate Name: </td><td>" & "<B>" &
RS("NameofCandidate") & "</b>" & "</td></tr>" & vbcrlf
Response.write "<tr><td>Interview Date: </td><td>" &
RS("InterviewDate") & "</td></tr>" & vbcrlf
Response.write "<tr><td>Interview DateID: </td><td>" &
RS("DateID") & "</td></tr>" & vbcrlf
Response.write "<tr><td height=10></td></tr>" & vbcrlf
Response.write "<tr><td>Available time
Slots: </td><td>Start Time</td><td>End Time</td></tr>" & vbcrlf
' Update group
lDateID = RS("DateID")
End If
' Print detail
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a
href= ""InterviewerInfo2.asp?timeID=" & rs("Starttime") & " "">" & _
RS("StartTime") & "</a></td><td>" & RS("EndTime") & "</td></tr>"
& vbcrlf
Your help is appreciated,
Chieko
I would like to learn the syntax for passing variables that I retreived from
a database to a second asp page. Currently, I'm using:
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a href=
""InterviewerInfo2.asp?timeID=" & rs("Starttime") & " "">"
How do I add more variables to my link: <a href = ...?
ie Nameofcandidate and InterviewDate
in this context:
' Iterate through times
While Not(RS.EOF)
' If date changes
If lDateID<>RS("DateID") Then
' If this is not first date, close out previous group
If lDateID>0 Then Response.write "</tr><tr><td
height=10><hr></td></tr>"
' Print header for new group
Response.write "<tr><td>Candidate Name: </td><td>" & "<B>" &
RS("NameofCandidate") & "</b>" & "</td></tr>" & vbcrlf
Response.write "<tr><td>Interview Date: </td><td>" &
RS("InterviewDate") & "</td></tr>" & vbcrlf
Response.write "<tr><td>Interview DateID: </td><td>" &
RS("DateID") & "</td></tr>" & vbcrlf
Response.write "<tr><td height=10></td></tr>" & vbcrlf
Response.write "<tr><td>Available time
Slots: </td><td>Start Time</td><td>End Time</td></tr>" & vbcrlf
' Update group
lDateID = RS("DateID")
End If
' Print detail
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a
href= ""InterviewerInfo2.asp?timeID=" & rs("Starttime") & " "">" & _
RS("StartTime") & "</a></td><td>" & RS("EndTime") & "</td></tr>"
& vbcrlf
Your help is appreciated,
Chieko