Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 48351 invoked from network); 30 Oct 2009 17:36:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 30 Oct 2009 17:36:34 -0000 Received: (qmail 76159 invoked by uid 500); 30 Oct 2009 17:36:33 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 76086 invoked by uid 500); 30 Oct 2009 17:36:32 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 76076 invoked by uid 99); 30 Oct 2009 17:36:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Oct 2009 17:36:32 +0000 X-ASF-Spam-Status: No, hits=-1.7 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [206.190.48.130] (HELO web52207.mail.re2.yahoo.com) (206.190.48.130) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 30 Oct 2009 17:36:30 +0000 Received: (qmail 65912 invoked by uid 60001); 30 Oct 2009 17:36:09 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1256924169; bh=tDJDRDacIed9DHq5yq+OG1MB+rzFwLuJJYC5aMsb1RA=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=F9D7DuKO83dnvzcO7xEV/JlNGCiqKQt8RLW0qyYufHoXCb1kvbuBryc7UOEs6OcD6zG5hPnkYU1hwfwYR9NTSpgdAGzrSjs1zJSmhqSoRgEvCYV3U4RC86yDp9qUPLAGh8Qv2IR55cxJvL5OAxg8bGo4TkV0HH2qUPu5a6Nvlag= 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:MIME-Version:Content-Type; b=mm6tCOVGmd7IsOUo79x0z0ULMvB7HnLVMKVh4kH6Ru6Vb3ZzLvlVQ/N9LsnddUuokCKFoHTxJY8Esqd2rcoXypUWhizV/SMO0UM169dEZipt9TeYwMITMgCjapRp7l6H97KGIMsATdY07cSDuhs247FD2Tg09dh2wNLLdFs21Io=; Message-ID: <243703.63807.qm@web52207.mail.re2.yahoo.com> X-YMail-OSG: E0K2a9sVM1n943tXZgb986kS7LdPcuHcvCjpULCMbw8iIG0wS1n71oNlU63wjzyMnnjtm_OtmnDNrsBu26HU4O8FDlYn9xrZJFoApnmiwU2x_LAiQ6BxZtw8w5.kedCzMSjmDZj38G_N9SrxBYvGIPJ2houXHuXJIjVe_opVGd6pxFJ.VemyATHpjJgkcg8komdYN9aR7y_8LliUx3eOeJchms3JCzwH_lo81krNBnjBe8k7JMiySbjoLZV0PUMC_TOVGTYJZbbljbRJeSDhRoDbCmVV4gWtlfrrUy6qRVhUK842Lfa0UZlleSnscTBzRYP0O33DRaTWSj5W1Q8qD34HckpfTonsvM.OQm.._QLHzJrUzhxnXoX8VSsbylaK..qkGqHmiHHji1ay21mE2n0OtBX0OM_TissptBX_cW23iT.tKg-- Received: from [68.148.20.81] by web52207.mail.re2.yahoo.com via HTTP; Fri, 30 Oct 2009 10:36:09 PDT X-Mailer: YahooMailClassic/7.0.14 YahooMailWebService/0.7.361.4 Date: Fri, 30 Oct 2009 10:36:09 -0700 (PDT) From: Duy Nguyen Subject: CouchDB equivalent dynamic SQL To: user@couchdb.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1816497236-1256924169=:63807" --0-1816497236-1256924169=:63807 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi guys,=A0 I have a troublesome sql query that needs to translate to couchDB map/reduc= e SELECT * FROM PRODUCTSWHERE [ PRICE ]=A0AND [TYPE]' Please note that Price and Type are dynamically generated depend on user in= puts. ( i.e=A0TYPEcan be 100 <=A0PRICE=A0< 1000, or 1 <=A0PRICE=A0< 100, or= 1000 <=A0PRICE=A0< 10000.=A0TYPE=A0could be 'computer' , 'tv' etc..) I can not do dynamically query on the fly with CouchDB. what is the best wa= y to solve this problem ?=0A=0A=0A --0-1816497236-1256924169=:63807--