http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-24T21:09:08 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00000957.htm#63886 gnerase: No, the given code is correct and preferable. The pound signs you suggest are superfluous. As a rule of thumb, the only places you need pound signs are inside <cfoutput> blocks and inside strings (e.g. <cfset Foo="Bar#N#Baz">). Adobe has some best practices documented here:<br /><br />http://livedocs.adobe.com/coldfusion/7/htmldocs/00000932.htm HorsePunchKid 0 0 2007-03-07T13:13:15 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000957.htm#49769 Just to correct the statement: <cfset total_records=test.recordcount>. There should be "#" signs. It should read: <cfset total_records=#test.recordcount#>. gnerase 0 0 2006-06-15T16:40:14 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000957.htm#47120 rather than writing loops for a one dementional array you can also use the following trick:<br /><cfset myarray = listToArray(valueList(test.FirstName))><br />Not as messy, though I don't know how it compairs for speed. <br /><br />(it's also worth pointing out that if you susspect you have comma's in your data you might want to try doing it with a diffrent delimiter such as:<br /><cfset myarray = listToArray(valueList(test.FirstName,"|"),"|")> ) hpottash 0 0 2006-04-04T07:36:34