That is telling you the data for the lat column your trying to insert
is to long, more then likely if your inserting directly from the form
there are to many decimal places

alter this code

$lat=  $_GET['lat'];
$lng=  $_GET['lng'];

to


$lat=  $_GET['lat'];
$lat = round($lat,4);
$lng=  $_GET['lng'];
$lon = round($lon,4);


-Jeff Lake
MichiganWxSystem.com
AllisonHouse.com
TheWeatherCenter.net
GRLevelXStuff.com

On 11/1/2012 9:05, Daniel Montenegro wrote:

I'm trying to implement a project very alike that:

https://developers.google.com/maps/articles/phpsqlinfo_v3

But I'm receiving this message from my phpsqlinfo_addrow.php:

Invalid query: Data truncated for column 'lat' at row 1

I don't know what's wrong because my lat lng columns were configured in the same way shown in the code. I checked the code a lot of times and there is no typo.

I'm using PHP 5 and MySQL Workbench.

Daniel

--
You received this message because you are subscribed to the Google Groups "Google Maps JavaScript API v3" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-maps-js-api-v3/-/-GXi7XlvcwYJ. To post to this group, send email to google-maps-js-api-v3@googlegroups.com. To unsubscribe from this group, send email to google-maps-js-api-v3+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-maps-js-api-v3?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google 
Maps JavaScript API v3" group.
To post to this group, send email to google-maps-js-api-v3@googlegroups.com.
To unsubscribe from this group, send email to 
google-maps-js-api-v3+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-maps-js-api-v3?hl=en.

Reply via email to