Re: Increment field value

2007-02-01 Thread Chris Hostetter
: Is it possible when updating a numeric field to increment the existing value : instead of replacing it with a new value? it's not currently possible to update a document "in place" at all -- you must provide all of the field values when doing an "update" -- this is largely due to some limitatio

Re: Increment field value

2007-02-01 Thread Luis Neves
I forgot one little detail. The DB server is untouchable. I have "read-only" access to it. The database is a component of an big "enterprisy" CMS. The obvious solution of adding a "#Posts" field to the table updated with a trigger is not viable. We have a ticket open with the vendor, but they

Increment field value

2007-02-01 Thread Luis Neves
Hello all, We have a Solr/Lucene index for newspaper articles, those articles have associated comments. When searching for articles we want to present the number of comments per article. What we do now is to fetch from the DB the sum of comments for each articleId that Solr returns, but this i