---
title: "Top 5 + databas"
type: "forum-thread"
url: "https://www.webforum.nu/amne/webbutveckling/20396-top-5-databas"
topic: "Webbutveckling"
topic_url: "https://www.webforum.nu/amne/webbutveckling"
author: "Lazerzubb"
published: "2001-01-21T10:16:00.000Z"
updated: "2001-01-25T22:09:00.000Z"
replies: 1
views: 407
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/webbutveckling/20396-top-5-databas"
---

# Top 5 + databas

## #1 — Lazerzubb, 2001-01-21T10:16Z

Så här ser koden ut i asp 
//
\<!-- #include virtual="/land/adovbs.stm" --\>
\<%	Set Connect = Server.CreateObject("ADODB.Connection")
	Connect.Open "driver={Microsoft Access Driver (\*.mdb)};dbq=D:/inetpub/wwwroot/sok1.mdb" 

SQL = "SELECT TOP 5 \* FROM sok ORDER BY ID DESC"
set rs=Connect.Execute(SQL)
if not rs.eof then
do until rs.eof
%\>
\<%=rs("LAND")%\>\<br\>
\<%rs.movenext
loop
%\>\<%
end if

rs.close
set rs=Nothing
Connect.close
set connect=nothing

%\>
// 
jag vill få den i wml.

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

## #2 — AG, 2001-01-25T22:09Z

Nåt i den här stilen borde fungera utmärkt:

```
<%
Response.ContentType="image/vnd.wap.wbmp"
%>
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="main" title="wap">
<p>
<!-- #include virtual="/land/adovbs.stm" -->
<% Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=D:/inetpub/wwwroot/sok1.mdb" 
SQL = "SELECT TOP 5 * FROM sok ORDER BY ID DESC"
set rs=Connect.Execute(SQL)
if not rs.eof then
do until rs.eof
%>

<%=rs("LAND")%><br/>
<%
rs.movenext
loop
end if
%>
</p>
<%
rs.close
set rs=nothing
connect.close
set connect=nothing
%>

</card>
</wml>
```

Andreas

\[Redigerat av AG den 25 jan 2001\]

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

---

Tråden på webben: https://www.webforum.nu/amne/webbutveckling/20396-top-5-databas