Skip to main content
July 22, 2013
Answered

Coldfusion 10 Update 11 SQL Server 2012 Query.columnList() Geometry Fields Error

  • July 22, 2013
  • 1 reply
  • 3211 views

When we do a query.columnList on a table that contains a geometry

datatype column it errors with unsupported data type. This does not

seem to be fixed in CF10 - Update 11. Have you heard of this, seen

this or have a solution to this issue?


Super easy to reproduce, just create a table with a geom or geography

column, run a query Select TOP 1 * FROM TABLEWITHGEMO, whatever and

then do the queryname_columnList which normal returns column names

that you can loop through (as you most likely know).

This topic has been closed for replies.
Correct answer Carl Von Stetten

Is this working in CF11 with SQL 2014?


Doubtful.  The issue is with the DataDirect drivers, and I don't believe Adobe has gotten any love from DataDirect on this.

-Carl V.

1 reply

Carl Von Stetten
Legend
July 22, 2013

Looks like this is a known issue in CF10: https://bugbase.adobe.com/index.cfm?event=bug&id=3217374

You might want to add your vote to this bug.

-Carl V.

Gary__F
Inspiring
April 9, 2014

This is a problem for me too. But a bug in the bugbase won't let me add my vote. It keeps saying my session has expired and I need to login... repeat 10 times... give up.

The geography data type was added to SQL Server 6 years ago (2008) so CF10 really should have been patched by now. So many apps have maps and these geo coordinates need to be stored and processed.

Carl Von Stetten
Legend
April 10, 2014

Try again to add a vote.  I think the bugbase was acting up on the 8th.  I just added a comment to ask Adobe to provide an update.

-Carl V.