TBook
A simple database type program with a reminder,phone book,address book and E-Mail entry. Nice calendar routine and easy to use.
AI
AI 요약: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.
소스 코드
Upload <P> As you user adds an item into there shopping cart, you should create a field that also holds the value of the SessionID (Session.SessionID). This ID is unique to all of your "current" visitors. When a users session ends, you can "clean up" your database by deleting all of the records relating to that session ID. Here is a brief run-down on the SQL you would execute in your Global.ASA file. </P> <DIV><FONT size=2><FONT face=Courier><FONT color=#0000ff><</FONT><FONT color=#800000>SCRIPT</FONT> <FONT color=#ff0000>language</FONT><FONT color=#0000ff>="vbScript"</FONT> <FONT color=#ff0000>runat</FONT><FONT color=#0000ff>="Server"></FONT></FONT></FONT></DIV> <DIV><FONT face=Courier size=2></FONT> </DIV><FONT size=2> <DIV><FONT size=2><FONT face=Courier><STRONG><FONT color=#0000ff>Sub </FONT></STRONG>Session_onStart()</FONT></FONT></DIV> <DIV><FONT face=Courier size=2> lStrSQL = <FONT color=#ff0000>"DELETE FROM ShoppingCartItems WHERE SessionID = "</FONT> & Session.SessionID</FONT></DIV> <DIV><FONT face=Courier color=#0000ff size=2><STRONG>End Sub</STRONG></FONT></DIV> <DIV><FONT face=Courier></FONT> </DIV> <DIV><FONT face=Courier color=#008000>' this is the main one you want - the others just help make </FONT></DIV> <DIV><FONT face=Courier color=#008000>' sure records get deleted if they are not needed.</FONT></DIV> <DIV><FONT face=Courier><FONT color=#000080><STRONG><FONT color=#0000ff>Sub</FONT> </STRONG></FONT>Session_onEnd()</FONT></FONT></DIV> <DIV><FONT face=Courier size=2> lStrSQL = <FONT color=#ff0000>"DELETE FROM ShoppingCartItems WHERE SessionID = "</FONT> & Session.SessionID</FONT></DIV> <DIV><FONT face=Courier color=#0000ff size=2><STRONG>End Sub</STRONG></FONT></DIV> <DIV><FONT face=Courier size=2></FONT> </DIV> <DIV><FONT size=2><FONT face=Courier><STRONG><FONT color=#0000ff>Sub </FONT></STRONG>Application_onStart()</FONT></FONT></DIV> <DIV><FONT size=2><FONT face=Courier> lStrSQL = <FONT color=#ff0000>"DELETE FROM ShoppingCartItems"</FONT></FONT></FONT></DIV> <DIV><FONT face=Courier color=#0000ff size=2><STRONG>End Sub</STRONG></FONT></DIV> <DIV><FONT face=Courier size=2></FONT> </DIV> <DIV><FONT size=2> <DIV><FONT size=2><FONT face=Courier><STRONG><FONT color=#0000ff>Sub</FONT></STRONG> Application_onEnd()</FONT></FONT></DIV> <DIV><FONT size=2><FONT face=Courier> lStrSQL = <FONT color=#ff0000>"DELETE FROM ShoppingCartItems"</FONT></FONT></FONT></DIV> <DIV><FONT face=Courier color=#0000ff size=2><STRONG>End Sub</STRONG></FONT></DIV></FONT></DIV> <DIV><FONT color=#800000 size=2><FONT face=Courier><FONT color=#0000ff></</FONT>SCRIPT<FONT color=#0000ff>></FONT></FONT></FONT></DIV>
원본 댓글 (3)
Wayback Machine에서 복구됨