What am I doing wrong, I though this would be simple..

[Graham Mattingley]

I am trying to count the records in a database, and make an array from the
answer this is the code


strQuery = "SELECT count(*) FROM resort where island_id= '"&island_drop&"'
;"
Set rsIslandinfo = adoConn.Execute(strQuery)
i = rsIslandinfo("count(*)").Value
** this bit above here works find I have done a response.write to check I
have a number in i

*** I have tryed it with and without the CInt command ***
i=CInt (i)

dim ics (i,2)

I am sure this is possible, what am I doing wrong ??

I just an ERROR 500

Help

Graham

 

[TomB]

I said that once and got a good slapping, when doing a count (I was told)
you want to use the asterisk as you may not get an accurate count. I
believe it had to do with NULLS, even if you did a COUNT(ID) where ID is the
PK and obviously wouldn't be Null.

Tom B

Do you need to count(*) as opposed to just counting one column?

You can use "SELECT COUNT([Something]) AS [TheCount] FROM [resort]..."
and then use
i = rsIslandInfo("TheCount").Value

Or better:

strQuery = "SELECT COUNT([Something]) FROM [resort]..."
Set rsIslandInfo = adoConn.Execute(strQuery)
i = rsIslandInfo.Fields.Item(0).Value

Ray at home



--
Will trade ASP help for SQL Server help

I am trying to count the records in a database, and make an array from the
answer this is the code


strQuery = "SELECT count(*) FROM resort where island_id= '"&island_drop&"'
;"
Set rsIslandinfo = adoConn.Execute(strQuery)
i = rsIslandinfo("count(*)").Value
** this bit above here works find I have done a response.write to check I
have a number in i

*** I have tryed it with and without the CInt command ***
i=CInt (i)

dim ics (i,2)

I am sure this is possible, what am I doing wrong ??

I just an ERROR 500

Help

Graham

 

[Ray at]

Ah, yes, I think that was just in a recent thread too. I remember reading
that in a thread recently anyway. I'll consider myself slapped. :]

Ray at work