On Wed, Feb 11, 2009 at 12:14 AM, Pat Allan <[email protected]> wrote: > > So, the issue is the sql_query then... which means, it's very likely > one of two things... the joins stop the relevant values, or the where- > clause does. > > The latter: `expenses`.`delta` = 0 AND repeated_template = false -- > would either of these stop the relevant expenses from appearing? > > -- > Pat >
You can see from my earlier post that it is passing the delta and repeated_template checks. It turns out the problem is the the business id is being stored as char(3) so if I run the query with the business_id 498 in the condition it does work. What is the proper fix? cheers, steve --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
