Tracking Logins and Searches

14 Apr 2009 7:51 PM

SteveSuperRealtor

I need to track logins and "submits" as generally and poorly described here:
http://www.freisco.com/tracker01.htm

In short, I want to track who attempts to login, who succeeds. I also want
to know what their search criteria are on each "submit". Even if this
logging results in an email generated for each login and each search, that
would be okay. (Don't get tons of traffic anyway :-( at least for now.)
Secondarily, I'd like to know how to limit the returns; if 50 returns are in
total, how can I set up "50 returns, showing 11-20 of 50" - like ebay does
with their catalogs.

Versions: Access2000 FP2000, XP Home, Windows Web Server, FP extensions
installed.

--
Just bluffing it!

15 Apr 2009 8:16 AM

Stefan B Rusynko

You can do it using some VBscript (ASP) and hand coding
- but what are they searching (the database or your site pages)
For the sign part in see
http://support.microsoft.com/default.aspx?scid=321439
You would need to modify above to add database write (w/ say their user ID and date/time) for the tracking part
For displaying paged results from the DB see
http://www.asp101.com/samples/db_paging.asp
- similarly modify the above to write the search string to the db
(say using http://www.asp101.com/samples/form_to_db.asp)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________

Show quoteHide quote

"SteveSuperRealtor" <SteveSuperReal***@discussions.microsoft.com> wrote in message
news:E7691C1B-1E26-4B85-9925-AE5C02F19D70@microsoft.com...
|I need to track logins and "submits" as generally and poorly described here:
| http://www.freisco.com/tracker01.htm
|
| In short, I want to track who attempts to login, who succeeds. I also want
| to know what their search criteria are on each "submit". Even if this
| logging results in an email generated for each login and each search, that
| would be okay. (Don't get tons of traffic anyway :-( at least for now.)
| Secondarily, I'd like to know how to limit the returns; if 50 returns are in
| total, how can I set up "50 returns, showing 11-20 of 50" - like ebay does
| with their catalogs.
|
| Versions: Access2000 FP2000, XP Home, Windows Web Server, FP extensions
| installed.
| --
| Just bluffing it!

15 Apr 2009 2:11 PM

SteveSuperRealtor

Thanks for your quick reply. I will check your suggestions later today or
tomorrow. I've refined my webpage: http://www.freisco.com/tracker01.htm
to be a bit more concise.
The search spawns the web page; each property does not have it's own page on
my site.
I am clueless on VB scripts and coding; but I am also a quick learner.

Thanks again for your advice.

--
Just bluffing it!

Show quoteHide quote

"Stefan B Rusynko" wrote:

> You can do it using some VBscript (ASP) and hand coding
> - but what are they searching (the database or your site pages)
> For the sign part in see
> http://support.microsoft.com/default.aspx?scid=321439
> You would need to modify above to add database write (w/ say their user ID and date/time) for the tracking part
> For displaying paged results from the DB see
> http://www.asp101.com/samples/db_paging.asp
> - similarly modify the above to write the search string to the db
> (say using http://www.asp101.com/samples/form_to_db.asp)
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "SteveSuperRealtor" <SteveSuperReal***@discussions.microsoft.com> wrote in message
> news:E7691C1B-1E26-4B85-9925-AE5C02F19D70@microsoft.com...
> |I need to track logins and "submits" as generally and poorly described here:
> | http://www.freisco.com/tracker01.htm
> |
> | In short, I want to track who attempts to login, who succeeds. I also want
> | to know what their search criteria are on each "submit". Even if this
> | logging results in an email generated for each login and each search, that
> | would be okay. (Don't get tons of traffic anyway :-( at least for now.)
> | Secondarily, I'd like to know how to limit the returns; if 50 returns are in
> | total, how can I set up "50 returns, showing 11-20 of 50" - like ebay does
> | with their catalogs.
> |
> | Versions: Access2000 FP2000, XP Home, Windows Web Server, FP extensions
> | installed.
> | --
> | Just bluffing it!
>
>
>