---
title: "Kolumnerna hittas inte"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/137052-kolumnerna-hittas-inte"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "WebbisNet"
published: "2005-11-06T16:31:08.000Z"
updated: "2005-11-06T16:39:27.000Z"
replies: 1
views: 275
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/137052-kolumnerna-hittas-inte"
---

# Kolumnerna hittas inte

## #1 — WebbisNet, 2005-11-06T16:31Z

I den här raden så klagar den på att den inte hittar UserID och username men de finns ju med i SQL-en

```
.Write "<a class=""menu"" href=""/view.asp?userID="& user("tblUsers.userID") &""">"& user("tblUsers.username") &"</a>&nbsp;<span class=""linkpresentation"">"& left(user("messageTime"),5) &"&nbsp;"& right(replace(user("messageDate"),"-",""),6) &"</span>" & vbCrLf
```

den hittar messageDate och messageTime

SQL-satsen

```
Set user=objConn.Execute("SELECT tblUsers_messagescroll.mCounter,tblUsers.userID, tblUsers.username, tblUsers.webblajv, tblUsers.picture, tblUsers_messagescroll.userID, tblUsers_messagescroll.mCounter,tblUsers_messagescroll.Visar, tblUsers_messagescroll.username, tblUsers_messagescroll.message, tblUsers_messagescroll.messageTime, tblUsers_messagescroll.messageDate "&_
"FROM tblUsers INNER JOIN tblUsers_messagescroll ON tblUsers.userID = tblUsers_messagescroll.userID where Visar=1 order by mCounter desc limit 12")
```

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

## #2 — LarsG, 2005-11-06T16:39Z

```
user("userID")
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/137052-kolumnerna-hittas-inte