|
PIEBALDconsult wrote: Along with dropdowns with more than a few items.
... that are not sorted or in any recognisable pattern
Also, those that have wide line spacing so you can only see 5 items without having to scroll down
|
|
|
|
|
Oh, those. In SSIS there's a drop down that is apparently sorted by the GUIDs of items. 
|
|
|
|
|
Websites that are designed to only work on developers' uber 4k monitors -- for example, dropdown menus whose bottom disappears off the bottom of the monitor and then dismiss when you move the mouse to the scroll bar to scroll down. Not everyone's system has a 4k monitor. Bad developer!
Websites that STILL don't know there's a 97003 zip code. Paypal (a financial institution  ) & UPS, I'm looking at you.. it's been 5 years now. Get a clue!
|
|
|
|
|
patbob wrote: Websites that STILL don't know there's a 97003 zip code. Paypal (a financial institution ) & UPS, I'm looking at you.. it's been 5 years now. Get a clue!
Wow, you're right. I just checked the zip code database I use for websites. It's using data from 2007. I can only imagine UPS and PayPal are using a similar source. How long ago was 97003 created and where is it?
Here's the two entries I have where it should fall into. It's in CSV format...
"ZIPCODE","LATITUDE","LONGITUDE","CITY","STATE","ABBR"
...
"97002","+45.224241","-122.819800","AURORA","OREGON","OR"
"97004","+45.247636","-122.468991","BEAVERCREEK","OREGON","OR"
...
Google says it's Washington County, Oregon. I'm thinking now it's a good time to update my data source.
Jeremy Falcon
|
|
|
|
|
Jeremy Falcon wrote: How long ago was 97003 created and where is it?
Like I said, 5 years ago, so 2012. It was official on July 1st, but the post office was still delivering mail to the old zip code until the following January.
Where is it.. well.. unincorporated Washington County, Oregon. I could provide the info, but I don't know what the official location designation is (so I'll probably be wrong), and it'll be in the updated zip code database anyway (this isn't the only new zip code).
|
|
|
|
|
Gotcha, just updated my cached info, but it's only as recent as Jan 2012 now. Although, after a quick google fu, turns out thar be sources that are more recent that offer zip/postal code data. So there's hope for UPS et al...
Postal Codes 97003[^]
As a bonus, seems you share a zip with Mexico and Guadeloupe.
Jeremy Falcon
|
|
|
|
|
So what's the deal.. I wouldn't expect you would need to update your zip code database manually. I figured the USPS sold zip code databases, and everybody updated from those from time to time. Is that not the case, or is this just your personal zip code database?
Oh, and I'd have said something other than "Beaverton" for the 97003 zip code.. so its probably good you went and got that from a more authoritative source 
And.. you didn't mention if you got the other new zip code too? Just curious.
|
|
|
|
|
patbob wrote: So what's the deal.. I wouldn't expect you would need to update your zip code database manually. I figured the USPS sold zip code databases, and everybody updated from those from time to time. Is that not the case, or is this just your personal zip code database?
It's my personal DB I keep around for the odd times when I need to validate stuff. If it was for a live production site I'd update more than once a decade. 
patbob wrote: Oh, and I'd have said something other than "Beaverton" for the 97003 zip code.. so its probably good you went and got that from a more authoritative source
There's so many non kid sister friendly jokes that can made about that.
patbob wrote: And.. you didn't mention if you got the other new zip code too? Just curious.
Probably not. My quick update was in the same format which went back to 2012. To use that 2017 data I'd need to cook up a new import. Which I will... when I'm not being lazy (as in not looking for a new job).
Jeremy Falcon
|
|
|
|
|
Jeremy Falcon wrote: My quick update was in the same format which went back to 2012
97078 is the other new one. I can never remember what it is, so I had to look it up:
..the U.S. Postal Service is creating two new ZIP Codes in the Beaverton/Aloha area, effective July 1, 2014. The new ZIP Codes are 97003 and 97078. This says 2014, but I'm sure its been longer than that.. I must be having a señor moment.
|
|
|
|
|
patbob wrote: I must be having a señor moment.
Si Señor
Jeremy Falcon
|
|
|
|
|
|
|
Makes you love the damned edge around a textbox in WinForms
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
And stop using Java Applets!
if (Object.DividedByZero == true) { Universe.Implode(); }
Meus ratio ex fortis machina. Simplicitatis de formae ac munus. -Foothill, 2016
|
|
|
|
|
Link pls.
The best way to make your dreams come true is to wake up.
Paul Valery
|
|
|
|
|
I'm not sure if this is a worse tease, but Amazon sends me spam every 2 days, almost without fail, and those messages contain items they simply won't ship to Canada - no reason given.
If you won't ship it, stop trying to sell it to me!! Of all companies, you'd think Amazon would've figured this out by now...
|
|
|
|
|
And phone numbers can only and must have 10 digits.
|
|
|
|
|
Not forgetting websites that request you to sign up for updates,
...often on 1-off visits coz you followed someone else's suggested link
as if we all really want more spam in our email boxes
Them lately/new pop/slide-downs just under the address bar notifications, for some reason AdBlock doesn't catch them.
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
In the immortal words of Rammstein
Quote: We're all living in America
America is wunderbar
We're all living in America
Amerika, Amerika
* CALL APOGEE, SAY AARDWOLF
* GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
* Never pay more than 20 bucks for a computer game.
* I'm a puny punmaker.
|
|
|
|
|
Chris,
Do you remember the Red Rose Tea commercials? "Only in Canada, you say... pity"
|
|
|
|
|
Not sure we got that one in Australia.
cheers
Chris Maunder
|
|
|
|
|
Red Rose Tea, as sold in Canada, is an orange pekoe; in the U.S., it's a black tea.
Look up the commercials on Youtube.
But, I agree with you on the 'State/Province' issue.. quick annoying.
|
|
|
|
|
What? Are you going on about that Canada-isn't-a-state thing again?
Software Zen: delete this;
|
|
|
|
|
Websites, even Canadian websites, that offer some prize or promotion
but deep within the official rules...NOT VALID IN QUEBEC!
73
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
