[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
--- 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 further, out
[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
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
--- 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:
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