[ic] is there a way to pull out a max value in a database

[interchange-users@icdevgroup.org (John Rennie (home))]

Tom asked...
>[loop search=|
>       fi=my_database
>       rf=code
>       sf=code
>       se=maximum
>  |]
>[loop-code]
>[/loop]
>
>I want the maxium value to be displayed.
>If the code field is from 0-100. it will only display
>100
>There is probably a simple way to do this but my brain
>is not functioning properly right now. 8-)
>
>Thanks for any help,
>Tom
How about just setting the rows returned to 1? Set ml=1 in your
search.

John.