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>
<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 --> 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>
<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' => 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
Create a new asp page and do the following:
-databindings
-command (stored procedure)
-'type' => 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
Cheers
Leed