View Full Version : write session variables to access database

12-08-2007, 01:43 PM
I have a load of info that a user has entered, it is in the form of session variables. Can anyone point me in the direction of how I can write that information back to an accesss database?


12-08-2007, 02:56 PM
Em I think you would have to extract the data from the MySQL database into a csv format using a tool like MySQL query browser :)

12-08-2007, 03:25 PM
I don't want to retrieve the info, I want to write it to the database

12-08-2007, 04:22 PM
As far as I am aware php can't write to a microsoft product directly. You'd need ASP to do that perhaps

12-08-2007, 06:43 PM
sorry dude...but this is the ASP forum and I mentioned in my first post about writing TO a databse...it seems like you are answering someone elses question.

I am using ASP and not PHP....thanks for the effort though

12-08-2007, 06:52 PM
now that wasn't very clever of me was it :(

12-10-2007, 09:10 AM
What are you having trouble with, exactly? Connecting to a database? Using session variables? You just need to construct a SQL statement, open a connection and execute the statement:

strSQL = "INSERT INTO table (field) VALUES ('" & session("mySessionKey") & "')"
set oCn = server.createObject("ADODB.Connection")
oCn.Open(myConnectionString (http://www.connectionstrings.com/))
oCn.Execute strSQL
set oCn = nothing

12-11-2007, 08:21 AM
Spud, it sounds like his biggest issue is figuring out how to parse the session string into its individual parts so it can be inserted into the database.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum