|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)

|
|
|
|
Subject: |
Linking Cookies with databases |
|
From: |
Ian |
|
Date: |
2/21/2000 8:06:13 AM |
|
IP: |
195.7.227.230 |
I want to use a cookie that will display the users ID (a number) or create a new ID for them if they are a new user. If they are new, a new ID will be created in the field CustomerID in the Table Customers. (This table will also have a field ID that has an autonumber). This will then display their new or current ID.
I have so far written the following code that actually displays the users current ID:
<%
Response.Cookies("MYCOOKIE").Expires = DATE + 356
%>
<HTML>
<BODY>
<%
If Request.Cookies("MYCOOKIE")("userid")<> "" Then
Response.Write(Request.Cookies("MYCOOKIE")("userid"))
Else
From Else Im not sure what code may come up next. I have thought of using a SessionID, a SELECT and an INSERT.
Please could someone help me with this problem
Thankyou for your time...
regards
Ian |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|