is there any other way to count records ?
Code:
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT sum(qanty) as Count from itemsOrd WHERE orderID = " & OrderID
rs.Open strSQL, conn, _
adOpenStatic, adLockOptimistic
numitems = rs("Count")
response.write numitems
Leave a comment: