Hi Andrew QofQ can be a bit of an arse some times (but bloody useful!)
I would suggest in your instance that you begin by narrowing down the fields until you actually find the one(s) which are causing the NULL error. Once you have done that, in the original query you could try CASTing or CONVERTing to a supported data type - that way QofQ would have a better guess at what each column is. Give it a try. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -----Original Message----- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 23 December 2004 08:54 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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188609 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
