storing cookie values in DB field

[karolmcauley]

Is it possible to store cookie values in a database field (Access) via an insert query?

For example, if i have set a cookie called username:

response.cookie("surname") = "username"

could i store that username value into a db, like:

INSERT INTO prediction (username,score,match,created_date)VALUES('" & username & "', '" & score & "', '" & match & "', '" & now() & "')"

If it is possible is the syntax right?

ManyThx in advance

[Carl]

Yes, you can insert data from a cookie. Besure to add

dim username
username = Request.Cookies("surname")

before your SQL.

Carl