dynamic links

[jacob94]

I have a dynamic data region that i created in DMX that displays a recordset from sqlserver. One of the fields is called username. I would like to make each username a hyperlink so a person viewing the report can click on any username and have it redirect to another page passing the username as a parameter.

the new link would be report2.asp (somehow with the parameter sessionusername = (what they clicked on the other page).

username
john
joe
jacob


when user click on a specific name:

http://www.123.com/report2.asp?username=jacob

etc....


is this possible and how hard to modify my dynamic data region?

ASP
sql server 2000
dmx

 

[Smeglor]

Just like so...

<%

'If your recordset loop is not included in a table row:

'Open the recordset
'Start the loop

Do While Not rs.EOF

Response.Write "<a href='report2.asp?username=" & rs("Username") & "'>username</a>"

rs.MoveNext
Loop
rs.Close
Set rs = Nothing

%>

<%

'If your recordset loop is included in a table row just add the html elements:

'Open the recordset
'Start the loop

Response.Write "<table>"

Do While Not rs.EOF

Response.Write "<tr><td><a href='report2.asp?username=" & rs("Username") & "'>username</a></tr></td>"

rs.MoveNext
Loop
rs.Close
Set rs = Nothing


Response.Write "</table>"

%>



I don't know sir...I guess its broke.

 

[Smeglor]

oops the last link should have closed the dimension first:

Response.Write "<tr><td><a href='report2.asp?username=" & rs("Username") & "'>username</a></td></tr>"

I don't know sir...I guess its broke.

 

[emozley]

Once you've got all your links in place you would have to use Request.QueryString to retrieve the value after the ?

eg

<%

rs.Open "SELECT * FROM Users WHERE UserName='" & Request.QueryString("username") & "'", DB

Response.Write("First Name: ") & rs("FirstName") & "<br>"
Response.Write("Surname: ") & rs("Surname") & "<br>"
Response.Write("Username: ") & rs("Username") & "<br>"

rs.Close

Set rs=Nothing
Set DB=Nothing

%>

 

[Bullschmidt]

And for a related link:

Classic ASP Design Tips - QueryString

http://www.bullschmidt.com/devtip-querystring.asp

Best regards,
-Paul

http://www.Bullschmidt.com

- Freelance Web and Database Developer

http://www.Bullschmidt.com/DevTip.asp

- Classic ASP Design Tips