PhotoPost Community - View Single Post

benFF · March 30th, 2005, 07:24 PM

Found a few, some relate to everyone, some just for people with letters in their zipcodes.

Firstly, the datatype for "zipcode" in the product table is int, this should be varchar

Secondly code changes required as if you had a Lat or Long < 0 (where I am is -0.XXX), the current code would assume an error! so we change it so only EQUAL to 0 will throw a problem)

REMOVED TO NOT CONFUSE PEOPLE--OMEGATRON

Thats it! I've now got classifieds running using the UK postcode system, and works great!

March 30th, 2005, 07:24 PM	#1 (permalink)
benFF Member Verified Customer Join Date: Dec 2004 Location: Osaka Posts: 158	Zip Code Integration Bugs (and fix!) Found a few, some relate to everyone, some just for people with letters in their zipcodes. Firstly, the datatype for "zipcode" in the product table is int, this should be varchar Secondly code changes required as if you had a Lat or Long < 0 (where I am is -0.XXX), the current code would assume an error! so we change it so only EQUAL to 0 will throw a problem) REMOVED TO NOT CONFUSE PEOPLE--OMEGATRON Thats it! I've now got classifieds running using the UK postcode system, and works great! Last edited by Chuck S; March 31st, 2005 at 08:33 AM.