I'm
not sure where to report this but I've run into a bug in "category.cfc" and
"typeadmin.cfc". In each case a query was run and then a "query of a
query" using the DISTINCT keywrd is run to filter out
duplicates.
<cfquery name="bob" datasource="alouie">
select colA,colB,colC
from tableA
</cfquery>
..
then a q of a q
<cfquery dbtype="query" name="bob">
select
DISTINCT *
from
bob
</cfquery>
When
the data returns also includes a column of the type Oracle.CLOB the q of a q
can't examine the values for distinct on that column and throws an error.
To
"fix" this error I'm using a do nothing try catch
<cftry>
<cfquery dbtype="query" name="bob">
select DISTINCT *
from bob
</cfquery>
<cfcatch>
<!--- does nothing --->
</cfcatch>
</cftry>
</cftry>
If someone can point me to the bug track I'll report
it...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---
