It seems that the only way to really do the cities is to create a separate field for each state and province. Dumping 38,000 values into a single city field causes memory allocation errors and it's just a huge mess.
How I'm doing this is creating a field for each state/province, dumping the values into the field, then setting the dependency in the html to show the corresponding city drop down according to which state/province is selected. It seems to work this way ok but there are some draw backs.
The first draw back is the shear time it's taking to build this thing, I've just pulled an all-nighter and I'm only 25% done. The second draw back is I can't set the state/province field as required as the state and province and city are all completely different fields. The third draw back is I have to set the profiles to not display blank fields as it would show a line for state, a line for province, and a line for every single state and provinces cities. The fourth and most concerning drawback is how this will affect the list search, I'm going to have to do some jerry rigging on the search function to show the corresponding dependent drop downs to force the search to look at the correct fields and not show ALL of the fields. I'm not even trying to think about that part yet.
I know you guys are thinking about adding an integrated conditional dependency field function in cb 2.0 and I would say it actually should have been part of cb from the start, but have you guys done any work on this for the new version yet?
I also ran into a non cb issue last night while building this that really has me ticked off. It seems once your html code gets too long the joomla html source editor will simply cut your code off at that point when you hit save. I've had to move over to finishing the build in a regular html file until I can figure out how to get the full code into the blank module without using the stupid html editor or finding a way to get the editor to not cut it off. I can't find anything in the editor params to fix this, I've turned off auto clean up code, I've even tried the jce editor and it still cuts it off. Anyone here ever run into this issue and found a work around on it? I've done some searching on the joomla forum and on Google but haven't been able to find anything on it. I don't know if this is a bug or if Joomla designed this on purpose.
This stupid registration form is setting me back by at least a week and really making me look bad. I just kind of assumed someone else would have a cities drop down solution built that I could just plug in and go with it like there is a countries txt file you can just dump and go already built. I had hoped to be finishing up the custom profile template by now instead of grinding away on this mind numbing tedious cantankerous registration form. Not to mention I haven't even gotten to trying to get the cb captcha plugin to work with it yet lol.
For anyone that wants to look at the form it's currently at
www.oohya.net/sandbox/oohya/registration.html
since I can't get the html editor to take all of the code to put it in the light box module.
Post edited by: sfraise, at: 2010/09/29 13:29