The "Non-Numeric Zip Code Value" Issue

[Smart Girl]

Description:
The ZipCode/Postcode field fails to accept the non-numeric characters like "AB10" and displays the following error:

Query UPDATE listings_properties SET value = AB10 WHERE object_sid = 437 AND id = 'ZipCode' :
Unknown column 'AB10' in 'field list'


Affected versions and products:
iAuto 4.0.0. -- 4.0.1.
iRealty 4.0.0. -- 4.0.1.

Instructions:

Add the following lines:

function getSQLValue()
   {
      return "'". mysql_real_escape_string($this->property_info['value']) ."'";
   }

between (lines approx. # 38-39):

return $this->property_info['value'];
    }

and (lines approx. # 41-43):

   }
 
 ?>

to the system/lib/orm/types/GeoType.php file.


If you find similar issues with your copy of iAuto or iRealty, please let us know.

[huggy]

Yep, looks all fine to me and works ok. Many thanks!!