---
title: "Loop vill sig inte..."
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/53391-loop-vill-sig-inte"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "roady"
published: "2002-09-16T17:54:41.000Z"
updated: "2002-09-16T18:21:51.000Z"
replies: 4
views: 194
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/53391-loop-vill-sig-inte"
---

# Loop vill sig inte...

## #1 — roady, 2002-09-16T17:54Z

**Hur skall jag loopa på bästa sätt.?**
Eftersom jag skall loopa ut två saker, en till SQL-sats och en till en dropdown så tänkte jag göra det samtidigt för att spara DB öppningar.
Men när det skrivs ut så i dropdown menyn så får jag först en tom plats och sedan kommer listan, hur fixar jag det på smidigast sätt???

```
SQLconfirm= "SELECT confirmer.confirmSchool FROM confirmer WHERE userID = "& MyID &";"	
objRStemp.Open SQLconfirm, objConnect, adOpenForwardOnly, adLockReadOnly, adCmdText
   Do Until objRStemp.EOF
      strSchoolConfirm = strSchoolConfirm & "' OR '" & objRStemp(0)
      [red]strSchoolConfirmShow = strSchoolConfirmShow & "</option><option>" & objRStemp(0)[/red]
   objRStemp.MoveNext
   Loop

objRStemp.Close

Response.Write("<option>" & strSchoolConfirmShow & "</option>")
```

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

## #2 — LarsG, 2002-09-16T18:01Z

```
SQLconfirm= "SELECT confirmer.confirmSchool FROM confirmer WHERE userID = "& MyID &";"	
objRStemp.Open SQLconfirm, objConnect, adOpenForwardOnly, adLockReadOnly, adCmdText
   Do Until objRStemp.EOF
      strSchoolConfirm = strSchoolConfirm & "' OR '" & objRStemp(0)
      strSchoolConfirmShow = strSchoolConfirmShow & "<option>" & objRStemp(0) & "</option>" 
   objRStemp.MoveNext
   Loop

objRStemp.Close

Response.Write strSchoolConfirmShow
```

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

## #3 — roady, 2002-09-16T18:13Z

Det gick snabbt...
Men hur kan man lösa denna raden då???
Det jag får är: SELECT users.userID, users.userFname, users.userEname, users.userStatus FROM users WHERE users.userSchool = '' OR 'Hertingskolan' OR 'Tullbroskolan' AND users.userStatus \<= 5 ORDER BY users.userFname, users.userEname Asc;

```
Do Until objRStemp.EOF
      [red]strSchoolConfirm = strSchoolConfirm & "' OR '" & objRStemp(0)[/red]
      strSchoolConfirmShow = strSchoolConfirmShow & "</option><option>" & objRStemp(0)
   objRStemp.MoveNext
   Loop

SQLconfirm = "SELECT users.userID, users.userFname, users.userEname, users.userStatus FROM users WHERE users.userSchool = '"& strSchoolConfirm & "' AND users.userStatus <= 5 ORDER BY users.userFname, users.userEname Asc;"
```

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

## #4 — LarsG, 2002-09-16T18:19Z

```
strSchoolConfirm = ""
Do Until objRStemp.EOF
      if strSchoolConfirm <> "" then strSchoolConfirm = strSchoolConfirm & ","
      strSchoolConfirm = strSchoolConfirm & "'" & objRStemp(0) "'"
      strSchoolConfirmShow = strSchoolConfirmShow & "</option><option>" & objRStemp(0)
   objRStemp.MoveNext
   Loop

SQLconfirm = "SELECT users.userID, users.userFname, users.userEname, users.userStatus FROM users " & _
"WHERE users.userSchool in (" & strSchoolConfirm & ") AND users.userStatus <= 5 " & _
"ORDER BY users.userFname, users.userEname Asc"
```

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

## #5 — roady, 2002-09-16T18:21Z

Du är en Gud lasse...

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/53391-loop-vill-sig-inte