ben, did you get that working? tw On 4/19/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > 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:238186 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
