Trying to output flat file rows as separate rows in a table - CF
Posted on 2007-07-23
We're using CFMX 6.1 on Win2003.
I'm reading the following text from a flat file with cffile action=read :
17,test 40,7/23,in progress,jw,no|
In the next page I need to show the info in a table while outputting each numbered item as a row in a table:
ISSUE ID TEST ISSUE DATE STATUS DEVELOPER UPLOADED
19 atest 7/24 done jw no
I have tried to read the entire file and put it into a LIST:
<cfset theList = ListToArray(issuesList, '|')>
then I try to cfloop through that list with:
<cfloop from="1" to="#ArrayLen(theList)#" index="i">
<td><!--- item no --->
<td><!--- issue --->
Anyone who knows what they are doing will see that I don't. I was thinking that I would make an ARRAY of LISTS and then parse through each one and use LISTGETAT using the comma as the delimiter.
Any ideas would be appreciated.