Solved

Variable length

Posted on 2002-03-22
6
492 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
  • 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 25 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
retrieving files from old server once DNS has changed 10 72
Website being blocked? 3 126
SCCM vs Windows server 5 79
Adding multiple JVM environments to RedHat 6 7 17
In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now