gruessle Posted March 17, 2003 Share Posted March 17, 2003 If you look to the end - you will see that Marymad and all states after that have beed cut off. Is there a maximum of states we can add? Region 3 States Minnesota,Wisconsin,Iowa,Illinois,Indiana,Missouri,Arkansas,Tennessee,Louisiana, Mississippi,Alabama,Michigan,Ohio,Kentucky,Georgia,Florida,Maine,New Hampshire,Vermont,Massachusetts,Rhode Island,Connecticut,New York,Pennsylvania,New Jersey,Delaware,Marylan I also tried adding more regions, but this option will not hold any information. I mean any states I add are not saved at all. // CUSTOMIZE THIS SETTING FOR THE NUMBER OF States NEEDED $this->regions = 4; Quote Gr?ssle Link to comment Share on other sites More sharing options...
Paul_w Posted March 17, 2003 Share Posted March 17, 2003 There is a maximum of 255 characters allowed in that field (configuration.configuration_value) in the database. You could alter it to a TEXT field which will allow you to store almost unlimited amount of data but this will slow your site down slightly. Have you tried using the 2 letter code for states instead of the full name? Quote Link to comment Share on other sites More sharing options...
gruessle Posted March 17, 2003 Author Share Posted March 17, 2003 Yes I tried two letters but I could not get it to work. Thank you for your help gruessle Quote Gr?ssle Link to comment Share on other sites More sharing options...
gruessle Posted March 17, 2003 Author Share Posted March 17, 2003 Could I change the value from 255 to 512 or something like that? Quote Gr?ssle Link to comment Share on other sites More sharing options...
Paul_w Posted March 17, 2003 Share Posted March 17, 2003 The maximum value a VARCHAR will hold is 255 characters, you will need to change it to TEXT if you must use more than 255 characters. Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Share Posted March 17, 2003 or LONGTEXT if you want to put in LOTS of data Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Paul_w Posted March 17, 2003 Share Posted March 17, 2003 or LONGTEXT if you want to put in LOTS of data I wouldn't advise using LONGTEXT unless you are going to be entering in excess of 65,535 characters per record :shock: Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.