On 09:42 Fri 15 Oct , adamcooper wrote:
> I think a simple fix to your problem would be to change this line:
>
> set_property :sql_query_killlist => "SELECT id FROM
> #{Project.quoted_table_name} WHERE state='archived' OR state='pfrozen'
> OR state='started' OR state='unpublished'"
>
> to
>
> set_property :sql_query_killlist => "SELECT `projects`.`id` * 5 + 3
> AS `id` FROM #{Project.quoted_table_name} WHERE state='archived' OR
> state='pfrozen' OR state='started' OR state='unpublished'"
Thanks a lot, guys!
set_property :sql_query_killlist => \
"SELECT projects.id * 5 + 3 AS id FROM #{Project.quoted_table_name} " \
+ "WHERE state='archived' OR state='pfrozen' OR state='unpublished'"
That worked.
Pat, may be it would make sense to include this issue in TS documentation?
Thanks again.
Regards, Danil.
--
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.
