---
title: "2 st loopar"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/62804-2-st-loopar"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "crisse6"
published: "2002-12-21T06:08:41.000Z"
updated: "2002-12-23T01:32:38.000Z"
replies: 4
views: 156
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/62804-2-st-loopar"
---
# 2 st loopar
## #1 — crisse6, 2002-12-21T06:08Z
Hej!
Nar jag ska skriva ut inlagg och avsandare, antal inlagg osv sa maste jag(?!) kora med tva st loopar verkar det som. Men far inte ihop det.
rs("f_text") ar sjalva inlagget.
rs3..... ar med info om avsandare, "niva", inlagg...
sql satserna ser ut sa har:
```
set rs = Server.CreateObject("Adodb.Recordset")
If request.querystring("info") = "ja" then
sql = "select * from t_viktigt where ForumID = "& request.querystring("forumID") &" and svarID = "& request.querystring("svarID") &""
else
sql = "SELECT * from t_threads where ForumID = "& request.querystring("forumID") &" AND svarID = "& request.querystring("svarID") &""
end if
sql3 = "select t_threads.*, t_users.* from t_threads, t_users where t_users.username = t_threads.f_by AND t_threads.f_by = t_threads.f_user"
set rs3 = objConn.execute(sql3)
```
och sa har ser loopen ut och utskrivningen ut:
```
response.write "
"&_
"
Inskickad av:
" &_
"
Inlägg:
"
first = true
do while not rs.eof and intCurrentPost < rs.pagesize
if bgcolor = "#FFFFFF" then
bgcolor = "#f5f5f5"
else
bgcolor = "#FFFFFF"
end if
strContents = strContents
if first then
response.write "
" &_
"
"& rs3("f_by") &"
"& rs3("misc") &" Inlagg: "& rs3("posts") &"
"
first = false
end if
if not isnull(rs("f_text")) then
response.write "
"& fixa(rs("f_text")) &"
" &_
"
"
intCurrentPost = intCurrentPost +1
rs.movenext
wend
```
liten julklapp! :e
Permalänk: https://www.webforum.nu/p/62804
## #2 — crisse6, 2002-12-21T16:32Z
ingen?
Permalänk: https://www.webforum.nu/p/892868
## #3 — solbulle, 2002-12-21T16:57Z
Vad händer/händer inte?
Permalänk: https://www.webforum.nu/p/892884
## #4 — crisse6, 2002-12-21T17:07Z
far felmess pa "wend".... hmm.... vill alltsa bara loopa ut tva olika recset men i ett och samma "paket" :)
hur skulle du gora solis?
Permalänk: https://www.webforum.nu/p/892887
## #5 — crisse6, 2002-12-23T01:32Z
fick ordning pa det genom en join i min lilla sql :)
Permalänk: https://www.webforum.nu/p/893344
---
Tråden på webben: https://www.webforum.nu/amne/asp/62804-2-st-loopar