Hi
I have an application that uses mySQL spatial data types. I can read the data as text by modifying the SELECT statement to be something like SELECT asText(myfield). This is fine for viewing but doesn't help me when it comes to adding/editing values into this field. MySQL uses the GeomFromText function to convert text to its internal spatial representation - is there anyway I can amend the INSERT and UPDATE functions to allow me to use this function in the PHPRunner events or output code.
a long shot I know - but it would help a lot if I could find a way round this problem.
thanks
Mark