What's the model name? Try specifying the table name in your SQL statements.
-- Pat On 20/08/2009, at 6:44 PM, Guy Argo wrote: > > I'm building a web application that stores dates (amongst other > things). > I'd like to be able to search those dates in the format that they're > displayed > to the user, namely 'MM/YY'. I tried the following: > > define_index do > ... > indexes "date_format( filing_date, '%m/%y' )", :as => :filing_date > indexes "date_format( grant_date, '%m/%y' )", :as => :grant_date > ... > end > > but get the response: > > ERROR: index 'record_core': sql_range_query: Column 'filing_date' in > field list is ambiguous > > Any suggestions? > Guy > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
