...

View Full Version : write session variables to access database



orange8
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?

thanks

nikos101
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 :)

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

nikos101
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

orange8
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

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

Spudhead
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
oCn.Close
set oCn = nothing

DakotaChick
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