It could be many different things. Developing apps with client
variables
can be very tricky.
Here are some things to keep in mind. Maybe one of them will point you
in
the right direction:
- When using a DB to store client vars they are kept in a table called
CDATA
- Unless you say <cfapplication ... setClientCookies="no"> then CFID
and
CFTOKEN will be stored in cookies
- If a CFID and CFTOKEN are specified in the URL string they will take
precedence over the CFID and CFTOKEN in the cookies
- If CFID and CFTOKEN are in the URL string and someone bookmarks the
page
then every time the bookmark is used the session will be resumed with
the
variables that existed when the page was bookmarked.
- cookies max out at 4000 characters
If someone bookmarks then gives the bookmark to a friend sessions can
get
mixed up.
You may have queries that are written wrong which return multiple rows
when
you only expect them to return one. This is an easy one to miss. You
think
you have one row so you say ...myQuery.column... and it returns the
first
row - which may not have the data you need. I've seen this screw up
sessions before.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 12:31 PM
To: CF-Talk
Subject: Client Variable Mix Up
For some reason I have an intranet site that everyone connects via
their own
IP address (no proxy). During the course of the day peoples sessions
will
be mixed up. Usernames which are found via client variables are linked
to
the wrong user. I originally had it as session variables, changed them
all
to client variables in an access database and then changed it to SQL
server.
If you have any ideas PLEASE let me know this has been pulling my hair
out.
Thanks,
Neil
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
