[CDBI] Re: Working with OGC geometry data types...

[prev] [thread] [next] [Date index for 2006/03/01]

> I'll try the SQL overrides as soon as I get a chance tomorrow. I'll
> post the results here.

Judd, I just realized that what I previously posted probably won't work. I'd
try the following instead:

__PACKAGE__->set_sql(Retrieve => <<'');
SELECT __ESSENTIAL__, geometry=AsText(geometry)
FROM   __TABLE__
WHERE  %s

__PACKAGE__->set_sql(RetrieveAll => <<'');
SELECT __ESSENTIAL__, geometry=AsText(geometry)
FROM   __TABLE__

Or possibly "AsText(geometry) AS geometry", depending upon your DBMS's SQL
dialect.

Later,
Ed

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi