---
title: "count problem??"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/121521-count-problem"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Gimbo"
published: "2005-02-01T18:21:42.000Z"
updated: "2005-02-01T18:37:44.000Z"
replies: 3
views: 340
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/121521-count-problem"
---

# count problem??

## #1 — Gimbo, 2005-02-01T18:21Z

fattar inte varfor denna kod inte funkar:

```
    <%
    '==============================
    '===Gives dollars to customers=
    '==============================

	call openDB()
	referSQL = conn.execute("SELECT COUNT(*) FROM refer WHERE leadBy = '"&session("strEmail")&"'")

	if referSQL > 1 then
   'response.write referSQL: response.end
        set creditDollarSQL = conn.execute("SELECT leadBy FROM refer WHERE email = '"&session("strEmail")&"'")
	'dollarSQL = "SELECT leadBy FROM refer WHERE email = '"&session("strEmail")&"'"
	'Response.Write(dollarSQL) : Response.End
         dollarSQL = conn.execute("SELECT COUNT(*) FROM rug_dollar WHERE email = '"&session("strEmail")&"'")
            if dollarSQL < 1 then
              conn.execute("INSERT INTO rug_dollar(eMail, Amount) VALUES('"&creditDollarSQL("leadBy")&"', 25)")
            else
              conn.execute("UPDATE rug_dollar set Amount = 25 WHERE email = '"&creditDollarSQL("leadBy")&"'") 
            end if
	end if
	conn.close
	set conn = nothing
    %>
```

far detta felmeddelande

```
Wrong number of arguments or invalid property assignment
```

pa denna rad
if referSQL \> 1 then

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

## #2 — @nders, 2005-02-01T18:24Z

1) Du måste använda *set* för att skapa dina recordsetobjekt. Det räcker inte med att bara skriva *objekt = conn.execute....*. Sedan:

```
If clng(referSQL(0)) > 1 then
```

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

## #3 — voigtann1, 2005-02-01T18:25Z

redigerad.
glöm det  :r

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

## #4 — Gimbo, 2005-02-01T18:37Z

tackar anders

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/121521-count-problem