|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
