Hi All.
I have a problem with a Query of a Query. The error I'm getting is:
Query Of Queries runtime error.
Sorting on columns of type "java.sql.Types.NULL" is not supported.
The code is:
<cfquery name="qry_accommodationData" dbtype="query">
SELECT *
FROM qry_accommodationData
ORDER BY #orderBy#, AdultPrice
</cfquery>
Most of the time this works fine, but every now and again it gets a
dataset that it has this problem with. I have compared the first row
of a good dataset with the first row of bad dataset and they appear to
be pretty much same, apart from slightly different values. As far as
I'm aware CF uses the first row of the dataset to set the data types
and in both the good and bad datasets none of the columns in the first
have null values.
Anyone got any ideas?
Andrew.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188607
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
