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