Our CRM software uses templates to hold the different address styles. It's in one database table, so it can be extended (currently 12 styles and one 'other'). However I hate our CRM software, partly because of its impossible database layout... so that's no help.
Anyways, here's one to add to your list (for The Netherlands) Mystreet 10 <-- street and number 1234 AA <-- postal code Amsterdam <-- city (no province necessary) Mingo. Doug Brown wrote: > I have a user table which will hold address information for a user. My > problem comes in where different countries use different things for their > address. Should I store all this different info in different columns, and > leave them to allow NULL values, and let the processing page handle things > and put stuff where it belongs? > > IE: > > > The US has... > > cities > States > Zip Codes > > In say the UK it has... > > towns/cities > counties > Postal Code > > In Algeria... > > City > State/Province/Region > Postal Code > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
