Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy. This forum is not for asking programming related questions.
Sorry, I should say "Partly" Faulty.... but faulty nonetheless.
It's missing 00's & 0's from some of the zip codes.
for example, if the zip code has 2 "00's" before any other number (>0) it just displays the zip code in 3 digits. for example, the first INSERT query has the following #:
"210" (NOTICE that its' missing 00 at the beginning)
I have corrected this issue and have uploaded a corrected file...
It is not faulty, it is just storing the zip as integers instead of strings. The work around is checking the string length of the ZIP during use of it (or, like I did, make the column a varchar(5) field - varchar(10) for + 4's).
Hang on, let me see if can get a dump of mine. The reason the change on the column didn't help is because after the type change, you need to add the 00 and 0 to the front of the short zips.
Ok, I did a dump of my 41K record table. It is at http://www.everah.com/freebies/zipcode_dump.sql. Please take note that this is a massive 2MB file. I didn't feel like Zipping it up, though I can if anyone wants it zipped. FYI, this is the structure...