---
title: "Skriva ut från databas"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/136380-skriva-ut-från-databas"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "eko"
published: "2005-10-25T16:45:21.000Z"
updated: "2005-10-25T16:45:21.000Z"
replies: 0
views: 172
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/136380-skriva-ut-från-databas"
---

# Skriva ut från databas

## #1 — eko, 2005-10-25T16:45Z

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%>
```

Permalänk: https://www.webforum.nu/p/136380

---

Tråden på webben: https://www.webforum.nu/amne/asp/136380-skriva-ut-från-databas