quote:
Originally posted by ruirib
Well I simply don't understand how is it possible for the count SQL statements not to work! I have no explanation for that. And you wrote that uploading a new admin_order_config.asp doesn't change it, right?
ruirib,
Here is what I did to get it working:
for the categorycount:
replaced this: '## Forum_SQL
strSql2 = "SELECT COUNT(CAT_ID) AS PAGECOUNT "
strSql2 = strSql2 & " FROM " & strTablePrefix & "CATEGORY"
set rsCount = my_Conn.Execute(strSql2)
categorycount = rsCount("PAGECOUNT")
rsCount.close
rs.open strSql, my_Conn, adOpenStaticwith this: rs.open strSql, my_Conn, adOpenStatic
categorycount = cLng(rs.recordcount)
for the forumcount:
replaced this: '## Forum_SQL
strSql2 = "SELECT COUNT(F.FORUM_ID) AS PAGECOUNT "
strSql2 = strSql2 & " FROM " & strTablePrefix & "FORUM F"
strSql2 = strSql2 & " WHERE F.CAT_ID = " & rs("CAT_ID")
set rsCount = my_Conn.Execute(strSql2)
forumcount = rsCount("PAGECOUNT")
rsCount.close
set rsCount = nothingwith this: forumcount = cLng(rsForum.recordcount)
Topic Locked
Posted - 17 June 2004 : 22:07:42
