How about this. 1. create a table that will hold the latest value when the application isn't being access. 2. On start of the use of the application set a var in application scope
if @@application$page01counter is empty then select page01count from table and store in application$page01counter <@ASSIGN variableTimeoutTrigger VALUE="http://domain/NonApp.taf?Counter=@@application$page01counter"; SCOPE="application"> endif 3. inside one of the html result that is the page you want to count place this <ASSIGN page01counter value=<@CALC EXPR="@@application$page01counter + 1"> you can then display the current count from a variable and not hit the database each time 4. now when all users are out of the application and the variable timeout occurs the variableTimeoutTrigger will call the NonApp.taf (which is a taf not associated to the application, but can access the database) to store the last count back in the database till it starts again hey, this is all conjecture and heresay, never tried it personally, it might work :) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Scott Yoshinaga Sent: Thursday, June 20, 2002 3:26 PM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Record Counter thats possible but i need a live update on the record itself to show how many times its been accessed. On Thu, 20 Jun 2002, Robert S. Sfeir wrote: > All these suggestions PLUS: > > If you have a server log you can run webtrends, or Bolero if that's > still around, or something looking for a string in the search, this is > assuming that you have a URL which looks something like this: > > http://domain.com/sometaf?_function=get&id=21 > > where the 21 would be the file or record ID you're looking for. > > This method is non invasive to your app and give you the flexibility to > get different reports in the way you want to see them. > > R > > Thijs Kroesbergen wrote: > > >Howdy, > > > >You could put a trigger on the "select" statement. Then have the trigger > >update another table which holds the counter. > >This only works if your database supports triggers of course. > > > >-thijs > > > > > > > >>-----Original Message----- > >>From: [EMAIL PROTECTED] > >>[mailto:[EMAIL PROTECTED]]On Behalf Of Scott Yoshinaga > >>Sent: Thursday, June 20, 2002 12:30 PM > >>To: Multiple recipients of list witango-talk > >>Subject: Witango-Talk: Record Counter > >> > >> > >>Hi All... > >> > >>I was wondeering if any of you have found a way to count how many times a > >>single record in a database is viewed. > >> > >>Has anyone needed to do something similar to this? > >> > >>aloha! > >>\\scott\\ > >> > >> > >>______________________________________________________________________ __ > >>TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > >> with unsubscribe witango-talk in the message body > >> > >> > >> > >> > > > > > >_______________________________________________________________________ _ > >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > > > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
