Forums

This topic is locked

onLoad or onLeave -----> insert

Posted 30 Aug 2001 11:33:57
1
has voted
30 Aug 2001 11:33:57 Hans Gelok posted:
<font face='Verdana'>Does anybody know if it´s possible to insert/update a record automaticaly when somebody opens or leaves a page? For example, when the page refreshes automaticaly to another page.

Thnx</font id='Verdana'>

Replies

Replied 30 Aug 2001 17:46:48
30 Aug 2001 17:46:48 Viktor Farcic replied:
You can use Command with Insert/Update statement.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<font face='Verdana'>Does anybody know if it´s possible to insert/update a record automaticaly when somebody opens or leaves a page? For example, when the page refreshes automaticaly to another page.

Thnx</font id='Verdana'>


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Replied 01 Sep 2001 15:12:58
01 Sep 2001 15:12:58 Hans Gelok replied:
<font face='Verdana'>Thnxs for your tip! It works with "command --&gt; insert record". Didn't know it was that easy. </font id='Verdana'>

Replied 04 Sep 2001 15:53:50
04 Sep 2001 15:53:50 Andrew Watson replied:
can you clarify this method???

<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Replied 05 Sep 2001 11:08:08
05 Sep 2001 11:08:08 Hans Gelok replied:
Hope you understand this: for example we would like to automaticaly cound every time a certain page is opened. Create a table with one (or more) collumn (each page one collumn).

Create a new asp page and do the following:
-databindings
-command (stored procedure)
-'type' =&gt; insert
-INSERT INTO tablename (collumnname )
-VALUES (1)

Result: every time this page is opened a new record inserts with value '1'. It´s possible to use 'update' instead of 'insert'.

Success, Coach

Replied 05 Sep 2001 14:36:00
05 Sep 2001 14:36:00 Andrew Watson replied:
so this doesnt involve the UD insert record behaviour then? simply a stored procedure in the database??? OK ill give it a whirl <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

Cheers
Leed

Reply to this topic