count problem??

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

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

redigerad.
glöm det :r

tackar anders