This is much more elegant, but unfortunately FileMaker via JDBC doesn’t seem to want to play ball.
I’m still looking into it. Wayne > On 9 Jul 2019, at 10:02 pm, Peter Dobbs <pe...@enginess.io> wrote: > > SELECT * FROM table ORDER BY NEWID() > > > Peter Dobbs > President | ENGINESS | P: 416.901.6151 <tel:416.901.6151;118> | F: > 416.901.6150 <tel:416.901.6150> | enginess.io <x-msg://45/www.enginess.io> > > This message may have been dictated and poorly interpreted by Siri. If this > message contains any content that is offensive or unusual/confusing in > anyway, please disregard as Siri is useful despite being incompetent. > > This email and any attachments are confidential and are intended only for the > person(s) to whom it is addressed. It you are not the addressee named above, > any use, copying, distribution or disclosure is strictly unauthorized. If you > have received this information in error, please delete it and any attachments > and notify me immediately. > > > On Jul 9, 2019, at 8:00 AM, Peter Dobbs <pe...@enginess.io > <mailto:pe...@enginess.io>> wrote: > >> You should do that in your sql, it’s much more efficient. >> >> >> Peter Dobbs >> President | ENGINESS | P: 416.901.6151 <tel:416.901.6151;118> | F: >> 416.901.6150 <tel:416.901.6150> | enginess.io <x-msg://45/www.enginess.io> >> >> This message may have been dictated and poorly interpreted by Siri. If this >> message contains any content that is offensive or unusual/confusing in >> anyway, please disregard as Siri is useful despite being incompetent. >> >> This email and any attachments are confidential and are intended only for >> the person(s) to whom it is addressed. It you are not the addressee named >> above, any use, copying, distribution or disclosure is strictly >> unauthorized. If you have received this information in error, please delete >> it and any attachments and notify me immediately. >> >> >> On Jul 9, 2019, at 1:07 AM, ubslab <ubs...@uw.edu <mailto:ubs...@uw.edu>> >> wrote: >> >>> I don't recall that, but I used something like this: >>> >>> <@ASSIGN NAME="ResultSet" VALUE="<@ARRAY ROWS='10' COLS='1' CDELIM=',' >>> RDELIM='|' VALUE='1|2|3|4|5|6|7|8|9|10|'>"> >>> >>> <p><@VAR ResultSet></p> >>> >>> <@ASSIGN NAME='RandomizedArray' VALUE=<@ARRAY ROWS='<@NUMROWS >>> array='ResultSet'>' COLS='1'>> >>> <@ASSIGN NAME='OriginalResultSetCols' VALUE='<@NUMROWS array='ResultSet'>'> >>> >>> <@WHILE EXPR="<@VAR RandomizedArray[<@VAR OriginalResultSetCols>,1]><1"> >>> >>> <@ASSIGN NAME='ResultSetRowPos' VALUE="<@RANDOM HIGH='<@NUMROWS >>> array=ResultSet>' LOW='1'>"> >>> <@ASSIGN NAME='RandomizedArray[<@CURROW>,1]' VALUE='<@VAR >>> ResultSet[<@VAR ResultSetRowPos>,1]>'> >>> >>> <@DELROWS ARRAY='ResultSet' POSITION='<@VAR ResultSetRowPos>' NUM='1'> >>> >>> </@WHILE> >>> >>> <p><@VAR RandomizedArray></p> >>> >>> >>> -Steve K >>> >>> On 7/8/19 7:23 PM, Wayne Irvine wrote: >>>> Is there a built in method to randomise the order of the resultset from a >>>> search? >>>> >>>> Wayne Irvine >>>> >>>> Byteserve Pty Ltd >>>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/> >>>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au> >>>> p: +61 02 9960 6099 >>>> m: 0409 960 609 >>>> f: +61 02 9960 6088 >>>> >>>> >>>> >>>> >>>> ---------------------------------------- >>>> >>>> To unsubscribe from this list, please send an email to >>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe >>>> terascript-talk" in the body. >>>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to >>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe >>> terascript-talk" in the body. >>> >> >> To unsubscribe from this list, please send an email to >> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe >> terascript-talk" in the body. > > To unsubscribe from this list, please send an email to > lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe > terascript-talk" in the body. Byteserve Pty Ltd w: http://www.byteserve.com.au/ e: i...@byteserve.com.au p: +61 02 9960 6099 m: 0409 960 609 f: +61 02 9960 6088 ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.