---
title: "limitstrul"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/153375-limitstrul"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "WebbisNet"
published: "2006-11-04T15:03:24.000Z"
updated: "2006-11-04T16:09:51.000Z"
replies: 2
views: 252
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/153375-limitstrul"
---

# limitstrul

## #1 — WebbisNet, 2006-11-04T15:03Z

när jag tar bort min vip så kan jag bläddra fram till fler än 100 poster så var ligger felet i denna kod

```
set vipCheck=objConn.Execute("SELECT vip, username, sender mailID, Reciever "&_
"FROM tblUsers INNER JOIN tblUsers_imail ON tblUsers.userID = tblUsers_imail.sender "&_
"WHERE Reciever="& UserID &" order by mailID desc")

if vipCheck.eof then
   response.write " "
else
 if vipCheck("VIP") = "1" then
       sqlStr = "limit 100"
   else
       sqlStr = "limit 1000"
   end if
    strSQL = "SELECT mailRead, username, mailDate, mailTime, sender, Headline, visaNyhetsbrev, message, mailID,Reciever, vip, saveMail "&_
    "FROM tblUsers INNER JOIN tblUsers_imail ON tblUsers.userID = tblUsers_imail.sender "&_
   "WHERE Reciever="& UserID &" order by mailID desc "&sqlStr
  
	end if
```

vip=1 icke vip=0 i databasen i vip kolumnen

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

## #2 — emission, 2006-11-04T15:32Z

Det är väl snarare 

vipCheck("VIP") = 1

än 

vipCheck("VIP") = "1"

eller ännu hellre

cint(vipCheck("VIP")) = 1

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

## #3 — WebbisNet, 2006-11-04T16:09Z

> **emission skrev:**
>
> Det är väl snarare 
> 
> vipCheck("VIP") = 1
> 
> än 
> 
> vipCheck("VIP") = "1"
> 
> eller ännu hellre
> 
> cint(vipCheck("VIP")) = 1

tack, den har jävlats länge för mig

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/153375-limitstrul