Question is how do you want to treat Null. Since NULL has no value, you will have to use IsNULLL() or your db equivalent to set a value that is either the highest or lowest, depending on how you wish to sort. If you need to keep the value as NULL, then create a sort field that contains the converted value(s).
Andy -----Original Message----- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 2:54 AM To: CF-Talk Subject: QofQ Problem: Sorting on columns of type "java.sql.Types.NULL" is not supported. 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:188637 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
