---
title: "Fel i SQL"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/81891-fel-i-sql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "lillen_009"
published: "2003-07-12T20:38:12.000Z"
updated: "2003-07-12T20:49:42.000Z"
replies: 2
views: 218
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/databaser-sql/81891-fel-i-sql"
---

# Fel i SQL

## #1 — lillen_009, 2003-07-12T20:38Z

Får ett fel i följande kod. Det är Hometeam=" & RS("Name") som ger felet. 

```
<% SQL = "SELECT Name FROM teams"
Set RS = Connect.Execute(SQL) 
do until RS.EOF
response.write "<td width='100' border='1'>"
response.write RS("Name")%>

</td><td width="20" border="1">

<% SQL1 = "SELECT COUNT(*) As hemmavinst FROM games where HomePoint=3 AND Hometeam= " & RS("name") 
Set RS1 = Connect.Execute(SQL1)
response.write RS("hemmavinst") %>

</td>
<% rs.movenext
loop %>
```

Får följande fel:

> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> \[TCX\]\[MyODBC\]Unknown column 'Oster' in 'where clause'
> /tabell/tabell.asp, line 25

Oster är in kolumn!!! Det är värdet som den ska leta efter i kolumnen, dvs RS("Name") blir först Öster, sedan XXX, sedan YYY, osv. Men varför säger den att det är ett kolumnnamn?

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

## #2 — jboy_87, 2003-07-12T20:47Z

\<% SQL = "SELECT Name FROM teams"
Set RS = Connect.Execute(SQL) 
do until RS.EOF
response.write "\<td width='100' border='1'\>"
response.write RS("Name")%\>

\</td\>\<td width="20" border="1"\>

\<% SQL1 = "SELECT COUNT(\*) As hemmavinst FROM games where HomePoint=3 AND Hometeam= '" & RS("name") &"'"
Set RS1 = Connect.Execute(SQL1)
response.write RS1(0)%\>

\</td\>
\<% rs.movenext
loop %\>

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

## #3 — LarsG, 2003-07-12T20:49Z

```
SQL1 = "SELECT COUNT(*) As hemmavinst FROM games where HomePoint=3 AND Hometeam= '" & RS("name")  & "'"
```

Egentligen behöver du bara en fråga

```
select t.name,count(g.hometeam) as hemmavinster
 from teams t left join games g
  on t.name = g.hometeams 
  and g.homepoint = 3
 group by t.name
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/81891-fel-i-sql