Variable length

This should be easy if you know.  What is the maximum length of the CFToken and CFID in CF5?

Michael
LVL 3
SewellMAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Cyril_HConnect With a Mentor Commented:
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
 
cheekycjCommented:
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
 
SewellMAuthor Commented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
cheekycjCommented:
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
 
SewellMAuthor Commented:
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
 
cheekycjCommented:
Thats ok.. Just glad you were able to find what you were looking for.

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

From novice to tech pro — start learning today.