RE: QofQ Problem: Sorting on columns of type "java.sql.Types.NULL" is not supported.
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: SELECT * FROM qry_accommodationData ORDER BY #orderBy#, AdultPrice 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
RE: QofQ Problem: Sorting on columns of type "java.sql.Types.NULL" is not supported.
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: SELECT * FROM qry_accommodationData ORDER BY #orderBy#, AdultPrice 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