Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of jjfutbol@gmail.com designates
 209.85.216.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=YIVLq7AfoLIQir3scfvcoJHUO/yQluU4Qyn3SDTPjRVaavZFdEGIbnYylEvZN0Ansd
         F2GF8jnwSF/oQ9kL19BwBqwZ/+Mb3HepZLXzebL7dx7ta27W8D6y6jT5AXowYxhw1eND
         Bcw0ktxqFLt3zEcPnGir0xkEM7KwRzqq1wGV8=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1082)
Subject: Re: wrong view results?
From: Javier Julio <jjfutbol@gmail.com>
In-Reply-To: <AANLkTimQ6P0_7mO+7J1apvYT1zTC-OA6mSyJo2cLBte2@mail.gmail.com>
Date: Wed, 9 Feb 2011 19:46:18 -0500
Content-Transfer-Encoding: quoted-printable
Message-Id: <C0A89B84-4DDD-4A98-A6E9-051531A1DF08@gmail.com>
References: <AANLkTimKUE9aaNiSKYGjKEgzoxGYX7uOuUT0FS2Exfe0@mail.gmail.com>
 <AANLkTi=Sj0ufYZNqXdJUophu-OAd62dv8ivvNnR1-C_J@mail.gmail.com>
 <E398DF7E-F05E-4D8F-ACA4-493D95A2C076@gmail.com>
 <AANLkTimQ6P0_7mO+7J1apvYT1zTC-OA6mSyJo2cLBte2@mail.gmail.com>
To: user@couchdb.apache.org

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 <jjfutbol@gmail.com> =
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
>>=20
>> On Feb 9, 2011, at 7:31 PM, Paul Davis wrote:
>>=20
>>> On Wed, Feb 9, 2011 at 5:52 PM, Mark Hahn <mark@elleh.com> 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.
>>>>=20
>>>> I have a view called itemByEmailNum.  Here is the definition of the =
view ...
>>>>=20
>>>> function(doc) {
>>>>  if(doc.type =3D=3D 'item')
>>>>    emit([doc.email, doc.itemNumber], null);
>>>>=20
>>>> Here is what I get from that view with no keys specified.
>>>>=20
>>>> {"total_rows":2,"offset":0,"rows":[
>>>> =
{"id":"86d5d83c65c3d901e29c7567be001233","key":["root",12],"value":null},
>>>> =
{"id":"86d5d83c65c3d901e29c7567be001e68","key":["root",13],"value":null}
>>>> ]}
>>>>=20
>>>> Here is the url of the view that seems to give the wrong results.
>>>> I've added spaces here for clarity.
>>>>=20
>>>> /bb/_design/bb/_view/itemByEmailNum ? keystart=3Dsusan%40elleh.com, =
0 &
>>>> keyend=3Dsusan%40elleh.com, 1000000000 & include_docs=3Dtrue &
>>>> descending=3Dtrue
>>>>=20
>>>> 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.
>>>>=20
>>>> {"total_rows":2,"offset":0,"rows":[
>>>> =
{"id":"86d5d83c65c3d901e29c7567be001e68","key":["root",13],"value":null,"d=
oc":{
>>>> ... }},
>>>> =
{"id":"86d5d83c65c3d901e29c7567be001233","key":["root",12],"value":null,"d=
oc":{
>>>> ... }}
>>>> ]}
>>>>=20
>>>> Any help would be appreciated.  I'm using CouchDB 1.0.1.
>>>>=20
>>>=20
>>> keystart and keyend should be start_key and end_key.
>>=20
>>=20
>=20
> 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.