<!--- This example shows ListGetAt and ListLen --->
<HTML>
<HEAD>
<TITLE>ListLen Example</TITLE>
</HEAD>

<BASEFONT FACE="Arial, Helvetica" SIZE=2>
<BODY  bgcolor="#FFFFD5">
<H3>ListLen Example</H3>

<!--- Find a list of users who wrote messages --->
<CFQUERY NAME="GetMessageUser" DATASOURCE="cfsnippets">
SELECT	Username, Subject, Posted
FROM    Messages
</CFQUERY>

<CFSET temp = ValueList(GetMessageUser.Username)>
<!--- loop through the list and show it with ListGetAt --->
<H3>This is a list of usernames who have posted messages
<CFOUTPUT>#ListLen(temp)#</CFOUTPUT> users.</H3>

<UL>
<CFLOOP FROM="1" TO="#ListLen(temp)#" INDEX="Counter">
	<CFOUTPUT><LI>Username #Counter#: #ListGetAt(temp, Counter)#</CFOUTPUT>
</CFLOOP>
</UL>

</BODY>
</HTML>       
      
