|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
ASP Newbie trying to create dynamic link from data field |
|
From: |
Rob |
|
Date: |
3/26/2001 4:48:58 PM |
|
IP: |
216.142.169.114 |
I cannot for the life of me find a how-to for creating the HTML for creating a link in my data output. My code is:
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout=60
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & Server.Mappath("fpdb/popentry.mdb") & ";"
%>
<%
Set rs = Conn.Execute("SELECT * FROM dbo_field_reps ORDER BY full_name ASC")
If Not rs.EOF Then
Response.Write"<table border=0 width=550 cellpadding=3>"
LinkCount = 0
Do Until rs.EOF
If LinkCount Mod 3=0 Then
If LinkCount <> 0 Then Response.Write"</tr>"
Response.Write"<tr><td>"&rs("full_name")&"</td>"
---Comment Here is where I need the help!
Else
Response.Write"<td>"&rs("full_name")&"</td>"
---Comment And Here too!
End If
LinkCount = LinkCount + 1
rs.MoveNext
Loop
Response.Write"</tr></table>"
rs.Close
Set rs = Nothing
Else Response.Write"Sorry, no record were found!"
End If
%>
<%
Conn.Close
Set Conn=Nothing
%> |
Follow Up - Re: ASP Newbie trying to create dynamic link from data field - Rob 4/4/2001 3:48:41 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
