Sql Count in ASP question

[thebmwz4]

Hi, i want to have the number of rows in the Database table. However the system cant display the value. Can someone help me see where is the error?
Thanks.

<%dim NumberofBets
Set objRS = Server.CreateObject("ADODB.Recordset")
countSQL = "Select COUNT(*) AS NumberofBets from InvestDetails"
objRS.ActiveConnection = connectDB
objRS.Open countSQL, connectDB
%>

Total : <%=NumberofBets%>

[<Eddie>]

<%
dim NumberofBets
Set objRS = Server.CreateObject("ADODB.Recordset")
countSQL = "Select COUNT(*) AS NumberofBets from InvestDetails"
objRS.ActiveConnection = connectDB
objRS.Open countSQL, connectDB
%>

Total : <%=NumberofBets%>
Think about what the code above is doing.

First line is the declaration of a variable called NumberofBets. From here you have opened a database connection and passed a query to it which will return the number of records. Note: What you haven't done is then assign the variable NumberofBets to the return value of the recordset...there is no NumberofBets=objRS.Field("NumberofBets")...so when you output the variable NumberofBets, it has no value.

;)

[Terrorke]

Completly correct.

You do not assign anything to your variable numberofbets

[thebmwz4]

Yo! thanks for the enlightenment. issue solved, yeah

The 's ' is missing thou.

NumberofBet=objRS.Fields("NumberofBets")

Thanks :)

[thebmwz4]

Ok, Eddie, Terrorke, thanks for the help!
Improve my understanding now
cheers

[Terrorke]

Happy we could help :)