Respone.Writing a count query

[Garabaldi]

Hi,

I'm trying to get a total for the amount of records I have in a table to write to an asp page.

Here is an example of my script so far:

Public objSystem
Public sSystem2
set objSystem = Server.CreateObject("ADODB.Recordset&quot

sSystem2 = "Select Count(*) From tb_System"
objSystem.Open sSystem2, objADOConn

How do I get the result of my Query to print to asp.

Thanks!!!

 

[Shemzar]

Try This,

myconn="Put your database connection string in here"
set rs = server.CreateObject("ADODB.Recordset")
getcountsql = "select count(*) from tb_System"
rs.Open getcountsql, myconn,1,2
if not rs.eof and not rs.bof then
    Response.Write("Total Record Count " & rs(0)
else
    Response.Write("No recordset created - ?")
end if

Regards,
S.

 

[Shemzar]

Oops there was a syntax erro in the last posting (sorry!) this is try this instead;

myconn="Put your database connection string in here"
set rs = server.CreateObject("ADODB.Recordset&quot
getcountsql = "select count(*) from tb_System"
rs.Open getcountsql, myconn,1,2
if not rs.eof and not rs.bof then
Response.Write("Total Record Count " & rs(0))
else
Response.Write("No recordset created - ?&quot
end if

Regards,
S.