MySQL Clean Problem
This is an open discussion with no replies, filed under Troubleshooting.
Search
Create an account or sign in to comment.
This is an open discussion with no replies, filed under Troubleshooting.
Create an account or sign in to comment.
Quick Links
Symphony • Open Source XSLT CMS
--with-xsl
)
I'm trying to create a field which uses the MySQL Spatial/Geometry fields.. however I got stuck on insertion to the Database. Symphony by default 'cleans' up the Insert values by enclosing it within single quotes.
However this is giving me an issue with Spatial/Geometry types since I would need to define GeomFromText outside of these quotes. I know I could possibly do a manual insert in a single Query but I don't think it would be safe as it would probably create the field in database with potentially another field raising an error thus having an 'incorrect' entry in database.