also i think you'll have to put square brackets around the start and end key values in the url
On Thu, Feb 10, 2011 at 6:53 AM, Mark Hahn <[email protected]> wrote: > I didn't have startkey or start_key. I had keystart (duh). Thanks > for pointing me in the right direction. > > On Wed, Feb 9, 2011 at 4:46 PM, Javier Julio <[email protected]> wrote: > > It looked odd to me at first too and I just happened to have that page > open. Glad I checked. Yeah makes sense its used a lot. Nice that either one > will be supported! > > > > Are you getting the correct results now Mark? Let us know. > > > > On Feb 9, 2011, at 7:42 PM, Paul Davis wrote: > > > >> On Wed, Feb 9, 2011 at 7:37 PM, Javier Julio <[email protected]> > wrote: > >>> No it should be "startkey" and "endkey" (no underscores, has to be all > lowercase otherwise not recognized). > http://wiki.apache.org/couchdb/HTTP_view_API > >>> > >>> On Feb 9, 2011, at 7:31 PM, Paul Davis wrote: > >>> > >>>> On Wed, Feb 9, 2011 at 5:52 PM, Mark Hahn <[email protected]> wrote: > >>>>> I'm getting what seems to me to be the wrong view results. Of course > >>>>> if I am doing something wrong it would be no surprise. > >>>>> > >>>>> I have a view called itemByEmailNum. Here is the definition of the > view ... > >>>>> > >>>>> function(doc) { > >>>>> if(doc.type == 'item') > >>>>> emit([doc.email, doc.itemNumber], null); > >>>>> > >>>>> Here is what I get from that view with no keys specified. > >>>>> > >>>>> {"total_rows":2,"offset":0,"rows":[ > >>>>> > {"id":"86d5d83c65c3d901e29c7567be001233","key":["root",12],"value":null}, > >>>>> > {"id":"86d5d83c65c3d901e29c7567be001e68","key":["root",13],"value":null} > >>>>> ]} > >>>>> > >>>>> Here is the url of the view that seems to give the wrong results. > >>>>> I've added spaces here for clarity. > >>>>> > >>>>> /bb/_design/bb/_view/itemByEmailNum ? keystart=susan%40elleh.com, 0 > & > >>>>> keyend=susan%40elleh.com, 1000000000 & include_docs=true & > >>>>> descending=true > >>>>> > >>>>> This should not have gotten any results since the only docs have the > >>>>> first key of "root" and both the keystart and keyend in this request > >>>>> have a first key of susan%40elleh.com. Here are the results it > >>>>> returned. I've snipped the doc properties for clarity. > >>>>> > >>>>> {"total_rows":2,"offset":0,"rows":[ > >>>>> > {"id":"86d5d83c65c3d901e29c7567be001e68","key":["root",13],"value":null,"doc":{ > >>>>> ... }}, > >>>>> > {"id":"86d5d83c65c3d901e29c7567be001233","key":["root",12],"value":null,"doc":{ > >>>>> ... }} > >>>>> ]} > >>>>> > >>>>> Any help would be appreciated. I'm using CouchDB 1.0.1. > >>>>> > >>>> > >>>> keystart and keyend should be start_key and end_key. > >>> > >>> > >> > >> Ah right. Older versions are still on the no underscore version. 1.1.0 > >> and beyond will recognize both because people tend to add the > >> underscore. > > > > >
