Thanks, I will give that a try... Overall, though, I think QofQ are great and very useful.
-b ....................... Ben Nadel www.bennadel.com -----Original Message----- From: Tony [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 11:23 AM To: CF-Talk Subject: Re: Q of Q crazy problem ben, i had to do this: select SUM(CAST(getReportsForVehicle.ignitionOnTime as INTEGER)) as ignitionOnTime from getReportsForVehicle where (ipAddressNum = #listGetAt(request.distinctIpAddressNumbers,o)# and weekDay = '#listGetAt(listDeleteDuplicates(valueList(getReportsForVehicle.weekday)),d) #') to get the sum to work. even if it was spec. or not spec. as an integer value... it didnt matter, i was getting stupid errors just the same. hth tw On 4/19/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > Ben, > > >I am having this really strange problem involving a query of queries > >that I have never encountered before. Basically I am building a query > >with the > >QueryNew() method: > > > > ... clip ... > > > >However, the following all cause error: > > > ><cfset REQUEST.SearchQuery[ "score" ][ REQUEST.SearchQuery.CurrentRow > >] = ArrayLen( arrCriteria ) /> <cfset REQUEST.SearchQuery[ "score" ][ > >REQUEST.SearchQuery.CurrentRow ] = > > Max( 5, REQUEST.SearchQuery[ "score" ][ > >REQUEST.SearchQuery.CurrentRow ] > >) > >/> > > > >Heck, even this causes errors: > > > >REQUEST.SearchQuery[ "score" ][ REQUEST.SearchQuery.CurrentRow ] = > > Max( REQUEST.SearchQuery[ "score" ][ REQUEST.SearchQuery.CurrentRow > >], > > REQUEST.SearchQuery[ "score" ][ REQUEST.SearchQuery.CurrentRow ] > > ) /> > > > > > >Its like any function call that returns a number corrupts the SCORE > >value for the QofQ. > > QoQ is a great idea, but it's buggy as heck. Everytime I've tried to > use it, I've run into some kind of irregularity with it that I've had > to spend time to work around. > > It sounds like you're running into casting issues. Even though CF is > typeless, it still has some issues at times when it blends to Java > that creates variables that should be typeless, but are not. I'm sure > that's why it works fine when you don't declare the variable types, > but errors when you explicitly declare the column types. > > Try using the JavaCast() function to explicitly declare your integer fields. > I suspect that will get rid of the errors. > > -Dan > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238114 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54