countfunction

[jestin]

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

the ASP code is as follows

[HTML]Set rssum = server.CreateOb ject("ADODB.Rec ordset")
sqlsum= "SELECT Count([ReqID]) AS TOTAL " &_
"FROM Tbl_RequestInfo " &_"WHERE (((Tbl_RequestI nfo.ReqBadgeno) >0) " & _"
AND ((Tbl_RequestIn fo.ReqServicety peid)= " & 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_RequestI nfo.ReqBadgeno) >0)
AND ((Tbl_RequestIn fo.ReqServicety peid)= " & ServiceTypeID & ")))"