The trick here is CF's list functions don't register empty list spots. If you do a ListLen on "1,2,,3" which looks like four spots - it'll return 3.
I tend to do a Replace() on strings like that - set ",," to ", ," - adding a space - and then that way, the list functions will sniff out that position as having a value. You really need to run that Replace() twice, back to back, though - as if you have a spot like ",,,," it'll replace the first pair of commas, and the second pair of commas, i.e. ", ,, ," - leaving the middle one still as a 'dead' position. Running the same Replace a second time catches any holdouts. --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
