in reply to Re^3: DBI placeholders for spatial data
in thread DBI placeholders for spatial data
I think that the Site::Point class will benefit from...
The sql method now returns just the POINT code instead of the complete ST_GeomFromText string. This allows me to do something like this:
As 4326 is a constant (as long as I am only dealing with this planet!) it doesn't need a placeholder.my $point = Site::Point->new('SO 1230 4560'); $dbh->do("INSERT INTO Test SET start = ST_GeomFromText( ? , 4326)", un +def, $point->sql);