see I found a mistake already :P. <cfset request.thissession = "#session.cfid#:#session.cftoken#">
should be <cfset request.thissession = "#cfid#:#cftoken#"> this way it would grab it if you passed the cfid and cftoken in the url or in seperate cookies called cfid and cftoken (which is what I would do). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:43 AM To: CF-Talk Subject: RE: storing session variables in DB i think i read this wrong. you WANT people to be able to jump from one server to the other during a session. Well then, client variables to the rescue. you could probably mimic with session variables: in your database create a table that has these columns CDATA ------ cfid char(100) app char(64) data text ** note in msaccess, use memo Application.cfm =============== <cflock timeout="10" throwontimeout="No" type="READONLY"> <cfset request.thissession = "#session.cfid#:#session.cftoken#"> <cfset request.thisapp = application.applicationname> </cflock> <cfquery name="GetSessionInfo" datasource="#request.dsn#" username="#request.username#" password="#request.password#"> select data from cdata where cfid = '#request.thissession#' and app = '#request.thisapp#' </cfquery> <cfset temp = request.session1 = StructNew()> <cfif GetSessionInfo.RecordCount NEQ 0> <cfloop index="i" list="#GetSessionInfo.data#" delimiters="##"> <cfif trim(i) NEQ ""> <cfset a = ListGetAt(i, 1, "=")> <cfset b = ListGetAt(i, 2, "=")> <cfset temp = StructInsert(request.session1, a, b)> </cfif> </cfloop> <cfelse> <cfquery name="InsertSessionInfo" datasource="#request.dsn#" username="#request.username#" password="#request.password#"> INSERT INTO CDATA (cfid, app) VALUES ('#request.thissession#', '#request.thisapp#') </cfquery> </cfif> Onrequestend.cfm ================ <cfset request.thisdata = ""> <cfloop collection="#request.session1#" item="i"> <cfset request.thisdata = request.thisdata & i & "##"> </cfloop> <cfquery name="UpdateSessionInfo" datasource="#request.dsn#" username="#request.username#" password="#request.password#"> UPDATE CDATA SET data = '#request.thisdata#' WHERE where cfid = '#request.thissession#' and app = '#request.thisapp#' </cfquery> ************** PLEAS READ****************************** Now understand that I don't use session variables at all in my apps and never will. this is just a rough idea of what you would most likely do to mimic client variables with session variables. Personally i would rewrite the app to use client variables. But each to their own. You will probably need to correct / rewrite some of this code. Hey I wrote it off a whime and without testing :P. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:10 AM To: CF-Talk Subject: RE: storing session variables in DB dude all you have to do is make sure that each app has it's own application name in the cfapplication tag. name of app1 <cfapplication name="test"> name of app2 <cfapplication name="test2"> now the user's can't share session variables. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:06 AM To: CF-Talk Subject: storing session variables in DB I have a set of mirrored servers that are running off 1 SQL_server. I have to recode the apps that use session variables because a user could jump to a different server during a session. Is there a simple way to fix this? Can 2 different servers be aware of the same session? Can I store the session variables in the SQL-server DB? I am running Win2k, SQL-Server 2000, and (I know) CF%.0 Professional. There is no need to tell me that the Enterprise version will allow me to isolate a user to one server during a session. Thanks in advance, BJ ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists