hahahaha, oops! (:

----- Original Message -----
From: "Mathias Höggren" <mathias@(protected)>
To: <JSP-INTEREST@(protected)>
Sent: Wednesday, February 11, 2004 2:26 PM
Subject: SV: Java / MySQL Question


> Hi,
>
> Since you're using MySQL you could always use this non-standard solution:
>
> SELECT * FROM myTable ORDER BY rand() LIMIT 1
>
> Brgds
> Mathias
>
>
> -----Ursprungligt meddelande-----
> Från: A mailing list about Java Server Pages specification and reference
> [mailto:JSP-INTEREST@(protected)
> Skickat: den 11 februari 2004 13:22
> Till: JSP-INTEREST@(protected)
> Ämne: Re: Java / MySQL Question
>
>
> rs.last();
> int randomRow = (int)(Math.random()*rs.getRow());
> rs.absolute(randomRow);
> ***********
> the usual get column stuff...
> ***********
>
> ----- Original Message -----
> From: "Jack Lauman" <jlauman@(protected)>
> To: <JSP-INTEREST@(protected)>
> Sent: Wednesday, February 11, 2004 1:49 PM
> Subject: Java / MySQL Question
>
>
> > I have a table containing information about different businesses. I
> > want to randomly select a single row from the table using a prepared
> > statement in a java bean. (Using MySQL 4.0.17 and JBoss 3.2.2)
> >
> > What is the most eficient way to do this?
> >
> > TIA
> >
> > Jack
> >
> >
>
===========================================================================
> > To unsubscribe: mailto listserv@(protected)
> JSP-INTEREST".
> > For digest: mailto listserv@(protected)
> DIGEST".
> >
> > Some relevant archives, FAQs and Forums on JSPs can be found at:
> >
> > http://java.sun.com/products/jsp
> > http://archives.java.sun.com/jsp-interest.html
> > http://forums.java.sun.com
> > http://www.jspinsider.com
> >
>
>
===========================================================================
> To unsubscribe: mailto listserv@(protected)
> JSP-INTEREST".
> For digest: mailto listserv@(protected)
> DIGEST".
>
> Some relevant archives, FAQs and Forums on JSPs can be found at:
>
> http://java.sun.com/products/jsp
> http://archives.java.sun.com/jsp-interest.html
> http://forums.java.sun.com
> http://www.jspinsider.com
>
>
===========================================================================
> To unsubscribe: mailto listserv@(protected)
JSP-INTEREST".
> For digest: mailto listserv@(protected)
DIGEST".
>
> Some relevant archives, FAQs and Forums on JSPs can be found at:
>
> http://java.sun.com/products/jsp
> http://archives.java.sun.com/jsp-interest.html
> http://forums.java.sun.com
> http://www.jspinsider.com
>

===========================================================================
To unsubscribe: mailto listserv@(protected)".
For digest: mailto listserv@(protected)".

Some relevant archives, FAQs and Forums on JSPs can be found at:

http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com