Sorry, logTable is just an arbitrary name I came up with. You can name
the table anything you want, like SearchViewTracking.
On Nov 18, 2004, at 12:26 PM, Stuart Felenstein wrote:
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
It depends on whether you are tracking info for
individual users
Individ
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
> It depends on whether you are tracking info for
> individual users
Individual users (lucky me!)
> Now, if you want to keep separate logs for each
> user, you need to
> create a "log" table. The log table would have the
> following fields:
> relat
It depends on whether you are tracking info for individual users or
just on a global basis. On a global basis, you just need to run an
update query:
UPDATE dbTable SET searchCount=searchCount+1 WHERE queryparams
The default value for searchCount would be 0, if the record never came
up in a sea
[snip]
I'm thinking this through. In other words, when a
record is returned in a search , and insert statement
makes an entry into another table? This will involve
scripting as well as sql statements ?
[/snip]
Well, you could use triggers and stored procedures, but yeyou are
going to have t
--- Jay Blanchard
<[EMAIL PROTECTED]> wrote:
> [snip]
> 1- I need a way to mark (somewhere) that the record
> came up in a search. i.e. 700 records were returned
> in a search, each one needs to a) be marked that it
> came up in a search b) that number needs to be
> incremented
>
> 2- Step fur
[snip]
1- I need a way to mark (somewhere) that the record
came up in a search. i.e. 700 records were returned
in a search, each one needs to a) be marked that it
came up in a search b) that number needs to be
incremented
2- Step further, out of those 700 records, user
chooses to view details on
I'm not even sure what this would be called, but maybe
someone (or more then one) can give me some pointers
and where to learn how this is down:
Someone does a search on my system:
1- I need a way to mark (somewhere) that the record
came up in a search. i.e. 700 records were returned
in a search
