webForumDet fria alternativet

Skriva ut från databas

ASP

0 svar · 163 visningar · startad av eko

Medlem sedan juni 2002198 inlägg
Frågan#1

Hur blir koden om jag vill skriva ut "arkivet" direkt istället för att man ska behöva klicka fram det med <a href="?p=2&arcive=yes">Past Shows</a> länken. Arkivet ska skrivas ut direkt där länktexten nu står. Hur går detta till? :q

<table border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
	<td width="90"><strong>Country</strong></td>
	<td><img src="graphic/blank.gif" width="5" height="1" alt="" border="0"></td>
	<td width="100"><strong>City</strong></td>
	<td><img src="graphic/blank.gif" width="5" height="1" alt="" border="0"></td>
	<td width="200"><strong>Venue</strong></td>
	<td><img src="graphic/blank.gif" width="5" height="1" alt="" border="0"></td>
	<td width="200"><strong>Date</strong></td>
</tr><%
Session.LCID = 1033
if request("arcive") <> "yes" then
	set rs = databas.execute("SELECT * FROM tour order by datum")
	do until rs.eof
			if rs("datum") => date then
					response.write "<tr valign=""top""><td colspan=""7""><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td></tr>"
					response.write "<tr valign=""top""><td>" & left(rs("country"),20) & "</td>"
					response.write "<td><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td>"
					response.write "<td>" & rs("city") & "</td>"
					response.write "<td><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td>"
					response.write "<td>" & rs("venue") & "</td>"
					response.write "<td><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td>"
					response.write "<td><nobr>" & FormatDateTime(rs("datum"),1)  & "</nobr></td></tr>"
			end if
	rs.movenext
	loop
	rs.close
else
	set rs = databas.execute("SELECT * FROM tour order by datum desc")
	do until rs.eof
			if rs("datum") < date then
					response.write "<tr valign=""top""><td colspan=""7""><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td></tr>"
					response.write "<tr valign=""top""><td>" & left(rs("country"),20) & "</td>"
					response.write "<td><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td>"
					response.write "<td>" & rs("city") & "</td>"
					response.write "<td><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td>"
					response.write "<td>" & rs("venue") & "</td>"
					response.write "<td><img src=""img/blank.gif"" width=""5"" height=""5"" alt="""" border=""0""></td>"
					response.write "<td><nobr>" & FormatDateTime(rs("datum"),1)  & "</nobr></td></tr>"
			end if
	rs.movenext
	loop
	rs.close
end if

%></table>

<br>

<%if request("arcive") <> "yes" then%>
<a href="?p=2&arcive=yes">Past Shows</a> 
<% else %>
<a href="?p=2&arcive=no">Current Shows</a> 
<%end if%>
270 ms totalt · 4 externa anrop · v20260731065814-full.a51de22e
132 ms — deklarationer (db)
0 ms — hämta statistik (cache)
134 ms — hämta tråd, inlägg och bilagor (db)
122 ms — ändringar (db)