Will do, Doug.
BTW, I'm using MySQL 5 .0.22 for this project but I'll test using
Postgres when I get a moment and submit those separately.
I'll throw the rest of the info in the ticket.
Thanks,
Jon
On Jan 24, 2007, at 3:02 PM, Doug Hughes wrote:
Jon - Got ahead and submit you suggestions. However, please tell
me what dbms you're working with and provide some example of how
it's broken and how it's fixable.
Thanks,
Doug
On 1/24/07, Jon Clausen <[EMAIL PROTECTED]> wrote:
In tables with spatial columns (i.e. - point,
polygon,geometrycollection,etc.) , Reactor is throwing :
Unsupported (or incorrectly supported) database datatype:
I browsed through reactor.data.mysql.objectDAO ,
reactor.data.postgres.objectDAO, reactor.data.oracle.objectDAO and
didn't find any spatial datatypes in the getCfDataType() or
getCfSQLType() methods.
For <cfqueryparam> purposes "cf_sql_blob" maintains the integrity
of the geometry values in my tests, so for the time being, I modified
my own reactor.data.[dbtype].objectDAO files to return that cfSQL
type for geometry values. Beyond doing that, are there any
methods available to bypass the objectDAO or the usage of
<cfqueryparam> on unknown datatypes?
I can submit proposed modifications for those datatypes to the
objectDAO methods on the Trac site if anyone thinks it would be
helpful to have these datatypes available in Reactor.
Thanks,
Jon
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
--
Doug Hughes
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
