coun record from table and display in row wise

[idsanjeev]

sir goodmorning
i wants to count record according to how much reply send by viewer and how much time views.
so what logic and syntax have to use.

[shweta123]

Hi,

Do you specify the more details about your requirement. Do you want to count how many users visited the page and what is the meaning of reply send by viewer?

sir goodmorning
i wants to count record according to how much reply send by viewer and how much time views.
so what logic and syntax have to use.

[idsanjeev]

thanks for taking response
i wants to count the how much user read the topic and if any user reply on topic then how many reply on that topic .
i wants to display both fild on page in its row after count

[shweta123]

Hi,

It depends on how you have done the coding of the page and also on your table structure.

One way is to do the required functionality is

The table which is containing information related to topics which users read and reply , you can add two more fields into it , one to store the information for no of users who read the topic and other to store no of users who replied to the topic.
So each time , when user will click on the link for that topic , retrieve last ReadCount from the db , increment it by one and store that value into database.
In a similar way , after inserting the record into table when user replies for the topic , increment the ReplyCount in database and update the table.


Hope so this will help.

[idsanjeev]

i have don't how to increament if primary key is in table so plz give me i have a field in topmaster for counting reply noofreply and i am using this code but this is worng
code:(asp)
conn.Mode = adModeReadWrite
conn.Open
R.Open "Select * from reply ", conn, adOpenStatic, adLockOptimistic, adCmdText
R.Addnew
R("top_id") =vtopid
R("rep_id") = vrepid
R("rep_by") = request.cookies("userid")
R("rep_dt") = Cdate(date())
R("reply") = vreply
R.UPdate
R.Close
R1.Open "Select no_of_reply from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
R1.Addnew
R1("no_of_reply")=vnoofreply
R1.update
R1.close
error is cannot insert NULL into ("STARTER"."TOPMASTER"."TOP_ID")
so i don't know i can i do it what code have to use for increament in topmaster field insertion in reply table is done but error in topmaster

[shweta123]

Hi,
You are getting the error message because
TopId is primary key in the table , so you can not insert a Null value into it.
So please check the value of variable vtopid using Response.Write(vtopid).
and write this code before R.Addnew for getting the latest Topid.

<%
Dim sql

sql = "Select max(topid) as maxtopid from reply"
set rs = conn.execute(sql)
vtopid= rs.Fields("maxtopid")

If isNull(vtopid) or vtopid = ' ' then
vtopid = 0
else
vtopid = vtopid +1
end if
rs.close
%>

i have don't how to increament if primary key is in table so plz give me i have a field in topmaster for counting reply noofreply and i am using this code but this is worng
code:(asp)
conn.Mode = adModeReadWrite
conn.Open
R.Open "Select * from reply ", conn, adOpenStatic, adLockOptimistic, adCmdText
R.Addnew
R("top_id") =vtopid
R("rep_id") = vrepid
R("rep_by") = request.cookies("userid")
R("rep_dt") = Cdate(date())
R("reply") = vreply
R.UPdate
R.Close
R1.Open "Select no_of_reply from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
R1.Addnew
R1("no_of_reply")=vnoofreply
R1.update
R1.close
error is cannot insert NULL into ("STARTER"."TOPMASTER"."TOP_ID")
so i don't know i can i do it what code have to use for increament in topmaster field insertion in reply table is done but error in topmaster

[idsanjeev]

but how can increament noofreply which is in table topmaster and reply is in table reply so what code have to use count reply based on topid and disply on page just like forum .

[shweta123]

Hi,

To increment no of replies , add these lines to your code

R1.Open "Select sum(no_of_reply) as reply_count from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText

'Get total no replies
vnoofreply = R1("reply_count")

If isNull(vnoofreply) or noofReply ="" then
''''''''If this is the first reply set it to 1
vnoofReply=1
else
vnoofReply= vnoofReply +1
end if

''''''''Update table topmaster with the new value of noofReply
Sql = "Update topmaster set no_of_reply = " & vnoofreply &" where TopicId = " & vtopid &""
conn.execute(Sql)

but how can increament noofreply which is in table topmaster and reply is in table reply so what code have to use count reply based on topid and disply on page just like forum .

[idsanjeev]

hi
its generate error report
unexpected end of SQL command

[shweta123]

Hi,

At which line you are getting error? When the errors related to Sql statement come in the ASP page , you can debug it as Response.write(sql), copy that sql statement into the query Analyzer of the server, solve the error there and then put the corrected sql query into the ASP page.

hi
its generate error report
unexpected end of SQL command

[idsanjeev]

error at line when using code for update topmaster for noofreply
conn.execute(Sql)