Re: [RDBO] use sql functions in inserts and selects

2006-06-07 Thread John Siracusa
On 6/2/06 4:49 PM, John Siracusa wrote: > On 6/2/06, Ask Bjørn Hansen <[EMAIL PROTECTED]> wrote: >> 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? >> >> (Likewis

Re: [RDBO] use sql functions in inserts and selects

2006-06-02 Thread Guillermo Roditi
A trigger may also be a good approach for you if the function can be had in perl.On 6/2/06, John Siracusa <[EMAIL PROTECTED] > wrote:On 6/2/06, Ask Bjørn Hansen <[EMAIL PROTECTED] > wrote:> When I insert or update those columns I need RDBO to wrap the data I> provide in GeomFromText() ("insert into

Re: [RDBO] use sql functions in inserts and selects

2006-06-02 Thread John Siracusa
On 6/2/06, Ask Bjørn Hansen <[EMAIL PROTECTED]> wrote: > 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 si

[RDBO] use sql functions in inserts and selects

2006-06-02 Thread Ask Bjørn Hansen
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 (?, GeomF