go ahead... be a heretic | |
PerlMonks |
DBI placeholders for spatial databy Bod (Parson) |
on Jun 25, 2021 at 17:14 UTC ( [id://11134291]=perlquestion: print w/replies, xml ) | Need Help?? |
Bod has asked for the wisdom of the Perl Monks concerning the following question: There seems to be a shortage of information available about spatial datatypes but I can create and update POINT data without placeholders. I am struggling to find the right way to do it with placeholders.
In the above code, start and end are both POINT datatypes. The print statement produces this: If the query is executed directly without placeholders, it works. The error is: ERROR: Cannot get geometry object from data you send to the GEOMETRY field It wouldn't be the end of the world if I didn't use placeholders here for the latitude and longitude as they are internally calculated and checked that they are numeric and within the vague boundaries of the UK. So, if only $uid used a placeholder there would not be a big risk. But I would rather do it properly if placeholders can be used with spatial datatypes.
Back to
Seekers of Perl Wisdom
|
|