countfunction

[jestin]

hi friend i am trying to count a filed in oracle,

the ASP code is as follows

[HTML]Set rssum = server.CreateObject("ADODB.Recordset")
sqlsum= "SELECT Count([ReqID]) AS TOTAL " &_
"FROM Tbl_RequestInfo " &_"WHERE (((Tbl_RequestInfo.ReqBadgeno)>0) " & _"
AND ((Tbl_RequestInfo.ReqServicetypeid)= " & ServiceTypeID & ")))"
rssum.Open sqlsum, MMToConn, 1, 3[/HTML]

the above code showing an error message as

Missing Expression

Can anybody help me

[debasisdas]

try to use the following query

sqlsum= "SELECT Count([ReqID]) AS TOTAL
FROM Tbl_RequestInfo WHERE (((Tbl_RequestInfo.ReqBadgeno)>0)
AND ((Tbl_RequestInfo.ReqServicetypeid)= " & ServiceTypeID & ")))"