use sql functions in inserts and selects

Hi,

I'm playing with having RDBO run some of geourl.org (it is using  
Class::DBI now).   Some of the columns are "point" columns with a  
spatial index.

When I insert or update those columns I need RDBO to wrap the data I  
provide in GeomFromText() ("insert into t (name, geo) values (?,  
GeomFromText(?)").

How do I do that?

(Likewise, on selects it's helpful if I can do something similar to  
convert the column to something more easily readable than the binary  
column data).


  - ask

-- 
http://askask.com/  - http://develooper.com/