Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of kartha02@gmail.com designates
 64.233.184.207 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=lKIgmiTFFtPNJqIGp1Cf4iw0fdMi1lRLsLkU/o+4my4RwtF6LBymZsvFhywyHVGJ5WLKDib755SnyBFMRqaFyjGoC1tcO7rn2WFiMI76VDiDqMqnXUQmHuaquysy5cJXgYDdDW4iiGoC69GDf6w19YcEw/boFy2k4fYjutzep9g=
Message-ID: <44a78d040512251907m4900f8baw2a1a7a77b42c8c71@mail.gmail.com>
Date: Sun, 25 Dec 2005 19:07:38 -0800
From: Rajesh Kartha <kartha02@gmail.com>
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: How to select a random record.
In-Reply-To: <43AF0540.6020001@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_17022_2576753.1135566458213"
References: <43AF0540.6020001@gmail.com>

------=_Part_17022_2576753.1135566458213
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Maybe there are other ways to perform this, but the first thing that came t=
o
my mind was to create a
Java stored procedure.  This can use simple Java code to create the logic
needed and return
a result set from the products table based on the categories and a generate=
d
random number.

Syntax for creating procedures:
http://db.apache.org/derby/docs/10.1/ref/rrefcreateprocedurestatement.html

Example:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408anders=
on/#cs_sp

Hope the above helps.

-Rajesh


On 12/25/05, Legolas Woodland <legolas.w@gmail.com> wrote:
>
> Hi
> Thank you for reading my post.
> I have a Product table and a category table.
> some of products exists in more than one category.
> I should select a random product from product table (a record)  and it
> should be from some certain categories.
> Now the question is :
> What is best solution to select a random product which is in one or more
> categories ( categories are  determined by users ).
>
>
> Thank you
>
>

------=_Part_17022_2576753.1135566458213
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Maybe there are other ways to perform this, but the first thing that came t=
o my mind was to create a <br>

Java stored procedure.&nbsp; This can use simple Java code to create the lo=
gic needed and return <br>

a result set from the products table based on the categories and a generate=
d random number.<br>

<br>

Syntax for creating procedures:<br>

<a href=3D"http://db.apache.org/derby/docs/10.1/ref/rrefcreateprocedurestat=
ement.html">http://db.apache.org/derby/docs/10.1/ref/rrefcreateproceduresta=
tement.html</a><br>

<br>

Example:<br>

<a href=3D"http://www-128.ibm.com/developerworks/db2/library/techarticle/dm=
-0408anderson/#cs_sp">http://www-128.ibm.com/developerworks/db2/library/tec=
harticle/dm-0408anderson/#cs_sp</a><br>

<br>

Hope the above helps.<br>

<br>

-Rajesh<br>

<br>
<br><br><div><span class=3D"gmail_quote">On 12/25/05, <b class=3D"gmail_sen=
dername">Legolas Woodland</b> &lt;<a href=3D"mailto:legolas.w@gmail.com">le=
golas.w@gmail.com</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" st=
yle=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex=
; padding-left: 1ex;">
Hi<br>Thank you for reading my post.<br>I have a Product table and a catego=
ry table.<br>some of products exists in more than one category.<br>I should=
 select a random product from product table (a record)&nbsp;&nbsp;and it<br=
>should be from some certain categories.
<br>Now the question is :<br>What is best solution to select a random produ=
ct which is in one or more<br>categories ( categories are&nbsp;&nbsp;determ=
ined by users ).<br><br><br>Thank you<br><br></blockquote></div><br>

------=_Part_17022_2576753.1135566458213--