<% set rsCount = Server.CreateObject("ADODB.Recordset") rsCount.ActiveConnection = MM_connDUarticle_STRING rsCount.Source = "SELECT (SELECT COUNT(*) FROM BARZELLETTE WHERE ART_APPROVED=1) AS ART_COUNT, COUNT(*) AS TYPE_COUNT FROM BARZELLETTE_TYPES" rsCount.CursorType = 0 rsCount.CursorLocation = 2 rsCount.LockType = 3 rsCount.Open() rsCount_numRows = 0 %>

Ci sono <%=(rsCount.Fields.Item("ART_COUNT").Value)%> barzellette in <%=(rsCount.Fields.Item("TYPE_COUNT").Value)%> categories

<% rsCount.Close() %>