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 zachary.zolton@gmail.com
 designates 209.85.219.205 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=F9/KQcLuNahGjvMpLWW6rXPr4923OENjjNnr15/ZXTH7CcMxj8MCZ1isg4dFo1TZO4
         1MTebPMMN+lyGBeCeLeyRYxWD+7VTwmMr29JHo99LMDbYPtmh6tmQp2J98qfuuMXB20+
         0za11ocUpcjaLbbrH9mQJMgCS19GtSm6SKccs=
MIME-Version: 1.0
In-Reply-To: <243703.63807.qm@web52207.mail.re2.yahoo.com>
References: <243703.63807.qm@web52207.mail.re2.yahoo.com>
Date: Fri, 30 Oct 2009 12:55:29 -0500
Message-ID: <f728979f0910301055u62788fedr9c57e585c97e84ca@mail.gmail.com>
Subject: Re: CouchDB equivalent dynamic SQL
From: Zachary Zolton <zachary.zolton@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

CouchDB-Lucene could be used here, but you have to taken into account
that Lucene will treat the numeric values as strings.

Cheers,
Zach

On Friday, October 30, 2009, Duy Nguyen <duynguyen0511@yahoo.com> wrote:
> Hi guys,
> I have a troublesome sql query that needs to translate to couchDB map/red=
uce
> SELECT * FROM PRODUCTSWHERE [ PRICE ]=A0AND [TYPE]'
> Please note that Price and Type are dynamically generated depend on user =
inputs. ( 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 =
way to solve this problem ?
>
>
>