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: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=dOxsBdxy+vkVlHmMaV177o+qaiAV3Iikxdr+gvkE6M3sZX+gBHDz6lHC2nKymxgkM1ZX5fy6QOqaGGK2JTIi5AGM+shZNG875ZZwYXCBFXFbNUEXXxS5lKXYUL1nkzHhJUQKyHGE5JhUlZSjxunePqJiPdeSx+jt7KITQn0pL9A=;
Message-ID: <949240.42364.qm@web52210.mail.re2.yahoo.com>
Date: Fri, 30 Oct 2009 13:46:31 -0700 (PDT)
From: Duy Nguyen <duynguyen0511@yahoo.com>
Subject: Re: CouchDB equivalent dynamic SQL
To: user@couchdb.apache.org
In-Reply-To: <415EAAEA-4699-4AA2-8368-E8FF6E305750@apache.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-370998442-1256935591=:42364"

--0-370998442-1256935591=:42364
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Thanks for reply , guys. If i want to select all tv or computer that have p=
rice in between 1000 and 2000,=A0
?startkey=3D [ ["computer", "tv"] , 1000]&endkey=3D[["computer", "tv"]=A0, =
2000]&include_docs=3Dtrue
Is it correct ?

--- On Sat, 10/31/09, Adam Kocoloski <kocolosk@apache.org> wrote:

From: Adam Kocoloski <kocolosk@apache.org>
Subject: Re: CouchDB equivalent dynamic SQL
To: user@couchdb.apache.org
Date: Saturday, October 31, 2009, 12:59 AM

On Oct 30, 2009, at 1:36 PM, Duy Nguyen wrote:

> Hi guys,
> I have a troublesome sql query that needs to translate to couchDB map/red=
uce
> SELECT * FROM PRODUCTSWHERE [ PRICE ] AND [TYPE]'
> Please note that Price and Type are dynamically generated depend on user =
inputs. ( i.e TYPEcan be 100 < PRICE < 1000, or 1 < PRICE < 100, or 1000 < =
PRICE < 10000. TYPE could be 'computer' , 'tv' etc..)
> I can not do dynamically query on the fly with CouchDB. what is the best =
way to solve this problem ?

Hi Duy, it won't always be a perfect translation.=A0 But CouchDB's compound=
 view keys should be able to help you in this situation.=A0 In your map, em=
it([doc.type, doc.price], null) and then query the view with

?startkey=3D["computer", 1000]&endkey=3D["computer", 10000]&include_docs=3D=
true

or

?startkey=3D["tv", 100]&endkey=3D["tv", 1000]&include_docs=3Dtrue

Best, Adam

=0A=0A=0A      
--0-370998442-1256935591=:42364--