Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [assombracao] randon results

Quote Reply
Re: [assombracao] randon results In reply to
Hi,

Sorry about the late reply!
In this case, you should replace the code below (around line #805 within SQL/Table.pm):

$self->select_options ("ORDER BY $in->{sb} $in->{so}") if ($in->{sb});

WITH:

if ( lc $in->{sb} eq 'rand' ) {
$self->select_options ("ORDER BY rand()");
}
elsif ( $in->{db} ) {
$self->select_options ("ORDER BY $in->{sb} $in->{so}");
}

Hope that helps.

TheStone.
Subject Author Views Date
Thread randon results assombracao 6422 Nov 22, 2002, 9:29 AM
Post Re: [assombracao] randon results
assombracao 6166 Feb 24, 2003, 3:26 PM
Thread Re: [assombracao] randon results
jean 6183 Feb 26, 2003, 11:50 AM
Thread Re: [jean] randon results
assombracao 6164 Feb 26, 2003, 6:56 PM
Thread Re: [assombracao] randon results
assombracao 6139 Mar 4, 2003, 4:04 PM
Thread Re: [assombracao] randon results
assombracao 6031 May 27, 2003, 2:39 PM
Thread Re: [assombracao] randon results
604 6002 May 30, 2003, 1:55 PM
Thread Re: [TheStone] randon results
assombracao 5969 Jun 14, 2003, 9:33 AM
Thread Re: [assombracao] randon results
604 5971 Jun 14, 2003, 9:22 PM
Post Re: [TheStone] randon results
assombracao 5602 Dec 17, 2004, 10:16 AM