---
title: "Jobbigt fel (Syntax)"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/66656-jobbigt-fel-syntax"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "DiDjo"
published: "2003-01-30T19:56:23.000Z"
updated: "2003-02-01T17:11:36.000Z"
replies: 12
views: 374
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/66656-jobbigt-fel-syntax"
---

# Jobbigt fel (Syntax)

## #1 — DiDjo, 2003-01-30T19:56Z

Hmmm denna kod e nog krånglig! Men om jag förklarar hur den fungerar så är det nog lättare:

```
sql = "SELECT topics.*, forums.*, statusname, statuslevel, moderator, users.posts FROM (status INNER JOIN users ON status.statusid = users.status) INNER JOIN ((forums INNER JOIN moderators ON forums.forumid = moderators.moderatorforum) INNER JOIN topics ON forums.forumid = topics.forum) ON users.username = topics.by WHERE topics.id = " & id
Set rsRoot = Server.CreateObject("ADODB.Recordset")
33-->rsRoot.Open sql, conn, 3, 3
```

Jag hade tabelen users förut och kolumnen username! Och nu vill jag byta till tabelen anv coh kolumnen anv! Hur ändrar jag den då?
Felet blir när jag ändrade själv:

```
Microsoft JET Database Engine error '80040e14' 

Syntax error in JOIN operation. 

/testing/!forum/philboard_read.asp, line 33
```

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

## #2 — LarsG, 2003-01-30T20:12Z

```
SELECT topics.*, forums.*, statusname, statuslevel, moderator, users.posts 
FROM (((status INNER JOIN users ON status.statusid = users.status) 
INNER JOIN topics ON users.username = topics.by)
inner join forums on topics.forum = forums.forumid)
INNER JOIN moderators ON forums.forumid = moderators.moderatorforum
WHERE topics.id = " & id
```

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

## #3 — DiDjo, 2003-01-31T18:35Z

ööö vad e skillnaden?

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

## #4 — DiDjo, 2003-01-31T18:37Z

Fel:

```
Microsoft VBScript compilation error '800a03fd' 

Expected 'Case' 

/testing/forum/philboard_read.asp, line 31 

SELECT topics.*, forums.*, statusname, statuslevel, moderator, users.posts
```

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

## #5 — solbulle, 2003-01-31T18:39Z

En rad...

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

## #6 — DiDjo, 2003-01-31T18:42Z

samma fel:

```
Microsoft VBScript compilation error '800a03fd' 

Expected 'Case' 

/testing/forum/philboard_read.asp, line 31 

SELECT topics.*, forums.*, statusname, statuslevel, moderator, users.posts FROM (((status INNER JOIN users ON status.statusid = users.status) INNER JOIN topics ON users.username = topics.by)inner join forums on topics.forum = forums.forumid) INNER JOIN moderators ON forums.forumid = moderators.moderatorforum WHERE topics.id = " & id
-------^
```

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

## #7 — solbulle, 2003-01-31T18:47Z

Kanske:

```
sql = "SELECT topics.*, forums.*, statusname, statuslevel, moderator, users.posts FROM " &_
" (((status INNER JOIN users ON status.statusid = users.status)" &_
" INNER JOIN topics ON users.username = topics.by)" &_
"inner join forums on topics.forum = forums.forumid)" &_
" INNER JOIN moderators ON forums.forumid = moderators.moderatorforum WHERE topics.id = " & id
```

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

## #8 — DiDjo, 2003-01-31T18:50Z

Nu är jag tillbaka till början igen!! Den säger att den inte hittar users! Vilket den inte ska! Eftersom jag underade hur man ändrade FRÅN tabelen users TILL tabelen anv och från kolumnen users till kolumnen anv!

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

## #9 — solbulle, 2003-01-31T19:12Z

Hm...

```
sql = "SELECT topics.*, forums.*, statusname, statuslevel, moderator, anv.posts FROM " &_
" (((status INNER JOIN anv ON status.statusid = anv.status)" &_
" INNER JOIN topics ON anv.username = topics.by)" &_
"inner join forums on topics.forum = forums.forumid)" &_
" INNER JOIN moderators ON forums.forumid = moderators.moderatorforum WHERE topics.id = " & id
```

Så där eller?

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

## #10 — DiDjo, 2003-01-31T19:20Z

Fel:

```
Microsoft JET Database Engine error '80040e10' 

No value given for one or more required parameters. 

/testing/forum/philboard_read.asp, line 37
```

Om jag ger er alla ASP kod runt de där istället:

```
<%
Option Explicit
Dim sql, rsRoot, rsReplies, count, id, rsUser, username, level, recordnum, cellbgcolor, se, rs, rs2, rs3, rs4, by, posts, rs1, addera, title, bye, messagecount, messagepage, lastpage, moderator, forumid, locked, repliesdisplay

%><!--#include file="conn.asp"--><%
Set rs1 = Server.CreateObject("ADODB.Recordset")
Addera = "SELECT * FROM anv where id='"&session("id")&"'"
rs1.Open Addera, Conn, 3, 3

username = Rs1("anv")
level = Request.Cookies("level")
recordnum = Request.QueryString("recordnum")

repliesdisplay = 20

if recordnum = "" then recordnum = 0 end if

id = Request.QueryString("id")
%>

<%
se=request("se")
if se="" then
	se=session("id")
end if
%>
<%
sql = "SELECT topics.*, forums.*, statusname, statuslevel, moderator, anv.posts FROM " &_
" (((status INNER JOIN anv ON status.statusid = anv.status)" &_
" INNER JOIN topics ON anv.username = topics.by)" &_
"inner join forums on topics.forum = forums.forumid)" &_
" INNER JOIN moderators ON forums.forumid = moderators.moderatorforum WHERE topics.id = " & id
Set rsRoot = Server.CreateObject("ADODB.Recordset")
rsRoot.Open sql, conn, 3, 3

moderator = rsRoot("moderator")
forumid = rsRoot("forumid")
locked = rsRoot("locked")

sql = "SELECT replies.*, statusname, statuslevel, users.icon, users.posts FROM (status INNER JOIN anv ON status.statusid = users.status) INNER JOIN replies ON users.username = replies.by WHERE replies.root = " & id & " ORDER BY date, time"
Set rsReplies = Server.CreateObject("ADODB.Recordset")
rsReplies.Open sql, conn, 3, 3

if not rsReplies.EOF then
  rsReplies.Movefirst

  for count = 1 to repliesdisplay
	rsReplies.Movenext
	if rsReplies.EOF then
	  exit for
	end if
  next
  
  if not rsReplies.EOF then
	messagecount = rsReplies.Recordcount
  end if
  
  rsReplies.Movefirst
  
end if
%>
<%
Function Smiley(text)

text = server.HTMLEncode(text)
text = Replace(text,vbCrLf,"<br>")
text = Replace(text,"(t)","<img src=""smile/weihnachten031.gif"">")
text = Replace(text,":'(","<img src=""smile/traurig001.gif"">")
text = Replace(text,"(d)","<img src=""smile/smily-sur.gif"">")
text = Replace(text,":D","<img src=""smile/supergrin.gif"">")
text = Replace(text,"(s)","<img src=""smile/stud.gif"">")
text = Replace(text,"(y)","<img src=""smile/smilie_daumen1.gif"">")
text = Replace(text,":=","<img src=""smile/shame.gif"">")

Response.Write text

End Function
%>
```

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

## #11 — solbulle, 2003-01-31T20:06Z

Jag sitter mest o flummar här nu, kanske ute på helt fel spår, men är du säker på att du har något  värde i:

se=request("se")
if se="" then
	se=session("id")

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

## #12 — DiDjo, 2003-01-31T20:55Z

ja! Det är ens ID man får där! Den får man när man loggar in! Och för att slippa skriva session("id") längre ner så tar jag den där se här uppe...

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

## #13 — DiDjo, 2003-02-01T17:11Z

Jag löste det med denna kod:

```
sql = "SELECT topics.*, forums.*, statusname, statuslevel, moderator, anv.posts FROM (status INNER JOIN anv ON status.statusid = anv.forumstat) INNER JOIN ((forums INNER JOIN moderators ON forums.forumid = moderators.moderatorforum) INNER JOIN topics ON forums.forumid = topics.forum) ON anv.anv = topics.by WHERE topics.id = " & id
Set rsRoot = Server.CreateObject("ADODB.Recordset")
rsRoot.Open sql, conn, 3, 3
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/66656-jobbigt-fel-syntax