Forums
This topic is locked
statistical returns
Posted 05 Aug 2002 14:10:44
1
has voted
05 Aug 2002 14:10:44 Martin Thielicke posted:
HalloI have developed a ASP Website with UD4 for a customer of mine (real estate agent)
www.immobilienkontor-rhein-main.de
Without UD4 or some Extension I have problems to develop ASP_code by freehand
There is a master.asp and the detail.asp connected to database called(immobilien.mdb). The name
of the table is immo. In this table "immo" there is an column count_views.
So what I want to get is now a statistic_value of how often a customer has looked
at an Object. Therefor I have a column count_views. Each time a customer is calling (or look at)
an Object (or product) on the detail.asp the value in count_views should increase +1.
That are the steps:
1) get the value in the column count_views
2.) increase +1
3.) update "count_views"
This does not work
<%
int_Count = (Recordset1.Fields.Item("count_views".Value)
int_Count = int_Count + 1
set count_views = int_count
%>
Sory for my bad english
So if someone could help me I would be very happy.<font size=4></font id=size4>
Replies
Replied 09 Aug 2002 18:11:32
09 Aug 2002 18:11:32 Viktor Farcic replied:
Try something like:
<pre id=code><font face=courier size=2 id=code>Recordset1.Fields.Item("count_views".Value = Recordset1.Fields.Item("count_views".Value + 1
Recordset1.Update</font id=code></pre id=code>
Viktor Farcic
www.farcic.com
TalkZone Manager
<pre id=code><font face=courier size=2 id=code>Recordset1.Fields.Item("count_views".Value = Recordset1.Fields.Item("count_views".Value + 1
Recordset1.Update</font id=code></pre id=code>
Viktor Farcic
www.farcic.com
TalkZone Manager