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<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/ 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 with "unsubscribe terascript-talk" in the body.