?
Solved

Variable length

Posted on 2002-03-22
6
Medium Priority
?
497 Views
Last Modified: 2013-12-24
This should be easy if you know.  What is the maximum length of the CFToken and CFID in CF5?

Michael
0
Comment
Question by:SewellM
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:cheekycj
ID: 6891072
I am not sure what the maximum values are but since they are stored in cookies or appended to the URL the size of cookie is 4KB and you can only have 20 cookies per domain (but since you can't spread values over multiple cookies) you have a 4KB restriction on each.

if you use URL to pass the two parameters then the browser and server URL size restriction will play a part in it.

CJ
0
 
LVL 3

Author Comment

by:SewellM
ID: 6891134
Thanks, but that is not quite what I meant.

In our application, we are storing data in a table and associating it with a users session.  This data is cleared whenever the user logs back in.  In the table, I had declared the field as having a length of 4.  Well, that caused problems yesterday when the value of CFID reached 5 (rolled over from 9999 to 10000).  I posted this question and then continued to do research.  I was able to find a length for CFToken, but could not find a length for CFID.  I have since determined why.  There is no set max length for this value.  It is created as a sequential value by the CF server.  So if your server stays running without restarting or rebooting the server  for a long period of time and has high volumes of visitors, this value could reach millions or even 100 millions.

I have since adjusted the field to allow for larger values.  Thanks for your help.  I can always count on you to reply when no one else has the answer.  

Thanks, and you will probably get the points (like you NEED them).

Michael
0
 
LVL 2

Accepted Solution

by:
Cyril_H earned 75 total points
ID: 6893456
About CFID, if you check the tables that CF create to store Client Variables (CDATA, CGLOBAL), you can see that CFID column is set to CHAR(20).

Cyril
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 19

Expert Comment

by:cheekycj
ID: 6893982
Both of those points are good to know.

I knew CFID could get up there.. I have seen really high values.. but what the actual limit (rollover point) was, I didn't know.

CJ
0
 
LVL 3

Author Comment

by:SewellM
ID: 6913431
I am accepting Cyrils answer as "closest" to correct.  He validated what my research had discovered.

Cheeky, if you feel you need some points or feel slighted, let me know and I will give you some points too.... ;-)

Thanks for both your help.  
Michael
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 6913737
Thats ok.. Just glad you were able to find what you were looking for.

 really don't need any more points :-)
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
What You Need to Know when Searching for a Webhost Provider
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month12 days, 9 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question