I solved this by splitting the sql-string like this:
if intTotalMemberPosts > 0 then set rscount1=my_conn.execute("SELECT COUNT(*) AS inttcount FROM "&strTablePrefix&"TOPICS WHERE T_AUTHOR="&ppMember_ID&"") set rscount2=my_conn.execute("SELECT COUNT(*) AS intrcount FROM "&strTablePrefix&"REPLY WHERE R_AUTHOR="&ppMember_ID&"") intpcount=clng(rscount1("inttcount"))+clng(rscount2("intrcount")) rscount1.close rscount2.close
set rscount1=nothing set rscount2=nothing intdpercentage=abs(round(((intTotalMemberPosts-intpcount)/intTotalMemberPosts)*100))
Is there any reason I can't do it like this? I get a number and it might be correct.. I can't really tell =) <
Nope, no reason at all; it does the same thing. Curious as to why the nested query didn't work, though, maybe that version of MySQL just doesn't support them - can you response.write it and post it here 'til we double check?
<
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
save percentage deleted posts/user
Posted - 17 May 2006 : 05:08:35
