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:

my $point = Site::Point->new('SO 1230 4560'); $dbh->do("INSERT INTO Test SET start = ST_GeomFromText( ? , 4326)", un +def, $point->sql);
As 4326 is a constant (as long as I am only dealing with this planet!) it doesn't need a placeholder.