---
title: "SQLfråga samt sortering med asp"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/10463-sqlfråga-samt-sortering-med-asp/page2"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "erka"
published: "2001-07-06T11:51:00.000Z"
updated: "2001-07-09T12:57:00.000Z"
replies: 20
views: 264
page: 2
pages: 2
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/10463-sqlfråga-samt-sortering-med-asp"
---

# SQLfråga samt sortering med asp

_Sida 2 av 2._

## #21 — erka, 2001-07-09T12:57Z

LarsG, en sissta sak ser du någe korkat i denna kod

```
SQLStmt = "SELECT * FROM (News n INNER JOIN NewsContent nc on nc.NewsId = n.NewsId) "_
	& "INNER JOIN SortOrder l ON nc.NewsLanguageid = l.NewsLanguageId WHERE nc.NewsId "_
	& "NOT IN (SELECT NewsId FROM NewsContent WHERE NewsLanguageid IN "_
	& "(SELECT NewsLanguageId FROM SortOrder WHERE Sortorder < l.Sortorder)) ORDER BY SortOrder"	 
	 
	Response.Write"<br>"
	ArrRS = Connect.Execute(SQLStmt).getrows()
	
		For i = 0 to ubound(ArrRS,2)
			
			if Cstr(language) <> Cstr(ArrRS(5, i)) then
			language = ArrRS(5, i)
			response.write language & "<br>"
						
		
			
			End If

			
			Number = ArrRS(0, i) 
			CountryRep = ArrRS(5, i)
			SQLStmt2 = "SELECT * FROM NewsContent WHERE NewsID = "& Number &" "_
					& "ORDER BY NewsLanguageID ASC"
			ArrRS2 = Connect.Execute(SQLStmt2).getrows()
			Response.Write ArrRS(6, i) &" (published: "& ArrRS(2, i) &")<br>"
			Response.Write"Existing languages: " 
				For a = 0 to ubound(ArrRS2,2)
					Response.Write"<img src=""/bin/images/flags/"& ArrRS2(1, a) &".gif"">"_
		  			& "<img src=""/bin/images/flags/1x1vit.gif"">"
				Next
			Response.Write"<br><a href=""view.asp?documentID=News&catID=wt&Action=AddStep1&NewsID="& ArrRS(0, i) &""_
			& """>Add new language version</a><br><br>"
		Next
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/10463-sqlfråga-samt-sortering-med-asp/page2  
Föregående sida: https://www.webforum.nu/amne/asp/10463-sqlfråga-samt-sortering-med-asp.md