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: [email protected] > p: +61 02 9960 6099 > m: 0409 960 609 > f: +61 02 9960 6088 > > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
