Dan has a good work around, going to install cfmx 7.0 this week. Maybe if im lucky they will have solved it.
gabe -----Original Message----- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Sunday, July 10, 2005 3:28 PM To: CF-Talk Subject: RE: Query of Query when date column may have a null QofQ was and is a problem in CF. I run into a lot of problems with it myself and only experimentation helped resolve them - don't trust the online documentation as it is full of bugs. TK http://www.tomkitta.com -----Original Message----- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Sunday, July 10, 2005 2:52 PM To: CF-Talk Subject: RE: Query of Query when date column may have a null Gabe, >Ran into an issue trying to perform a q in q on some data that contains >nulls in a date field. > >It appears the field gets cast one way or the other and thus pops: > >Query Of Queries runtime error. >Unsupported Date type conversion in Query of Queries. > >I need to pull the records even if they are null. Anyone run into this >and come up with a workaround? > >Mx 6.1 If you're using MS SQL, you could use ISNULL() on the date fields to return an empty string instead of the null value. However, I suspect the problem is QoQ is choking trying to compare a date field to an empty string. If this is the case, you might have to try declaring some kind of "null" date (like 1/1/1900.) - Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211512 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