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 jchris@gmail.com designates
 74.125.83.180 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=w1+C21ow/Y4h/QVGnQtwA9yX0Z06AHysarWyue+X+0gAE2JP282HUF7uDbsSrEnAlo
         ffsSuM2Pr3WnVRRzJ4g819vgIoUK+BaoBdsc0fh2s+ACDLI95hR1LMhe7zYtsoQgbzvG
         VmDCiqm9i5FWHedFByM2Vh3RizHObDhgGT70g=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1081)
Subject: Re: using req.query to filter a list function in couchDB 0.10.0
From: J Chris Anderson <jchris@gmail.com>
In-Reply-To: <AANLkTikaz6IK-R9k3YaY300CIoGpbN64T1PGRXvEwruq@mail.gmail.com>
Date: Sun, 18 Jul 2010 16:22:24 -0700
Content-Transfer-Encoding: quoted-printable
Message-Id: <674A725A-4BAA-455F-9E69-B19433BA3DB7@gmail.com>
References: <AANLkTikaz6IK-R9k3YaY300CIoGpbN64T1PGRXvEwruq@mail.gmail.com>
To: user@couchdb.apache.org


On Jul 18, 2010, at 4:12 PM, Steven Prentice wrote:

> Hi,
> I am trying to use a list function to filter the results of a view in =
my
> database. I have developed the following code, but keep getting a =
reference
> error when making a request:
>=20
> Request =3D curl -X GET
> =
'..../_design/dates/_list/param/audit_resource_subresource_with_criteria?a=
s=3D"TestUser"'
>=20
> (param is the name of my list function)
>=20
> the function looks like this...what I am trying to do is allow someone =
to
> enter the name of the user to filter the view for just rows where the
> accessingsystem field =3D what is entered:
>=20
> function(head, req)
> {
>    var accessingsystem =3D req.query['as'];
>    var row;
>    while(row =3D getRow())
>    {
>        if (as && row.value[1] !=3D as)
>        {
>            continue;
>        }
>        send(row.value);
>    }
> }
>=20
> the error i get is =
{"code":500,"error":"render_error","reason":"function
> raised error: ReferenceError: as is not defined"}
>=20

looks like a garden-variety JS error:

"as" in the loop body should be replaced with accessingsystem

> any help =3D much appreciated!
> Steve