---
title: "Forumprobs!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/97739-forumprobs"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "k0ffe"
published: "2004-02-19T16:43:31.000Z"
updated: "2004-02-19T16:43:31.000Z"
replies: 0
views: 136
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/97739-forumprobs"
---

# Forumprobs!

## #1 — k0ffe, 2004-02-19T16:43Z

Någon här som förstår sig på koden?
Jag vill loopa alla svar till debatterna under respektive debatt-rubrik.
Men den visar bara den översta svars-rubriken under varje debatt-rubrik.
Nån som hängde med?
Tacksam för hjälp!

```
<% 
Set RecSet = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT (select count(*) from debatt) As AntalDebatt, *, Format$([datum],'yyyy/mm/dd') AS formdatum FROM debatt order by DID desc"
RecSet.Open SQL, Connection, adOpenStatic, adLockOptimistic

Set Number = Connection.Execute("Select Count(*) As Antal FROM debatt_svar")

response.write recset("AntalDebatt") & "<br>"
while not recset.eof 

   Set RecSet2 = Server.CreateObject("ADODB.Recordset")
   SQL = "SELECT (select count(*) from debatt_svar) As AntalSvar, *, Format$([datum],'yyyy/mm/dd') AS formdatum FROM debatt_svar WHERE SID = " & recset("DID") & " order by datum desc"
   RecSet2.Open SQL, Connection, adOpenStatic, adLockOptimistic
   
  response.write ("<a href=""visa_debatt.asp?DID=" & recset("DID") & "&""SID=" & recset2("SID") & """>" & Recset("rubrik") & "</a>")

   
   response.write "Antal svar: " & recset2("AntalSvar") & "<br>"
   while not recset2.eof 
      response.write recset2("rubrik") & "<br><br>"
      recset2.movenext
   wend
   set recset2 = nothing

   recset.movenext
wend

set recset = nothing
%>
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/97739-forumprobs