I'm having difficulty understanding what happening behind the scenes of the
CFLOOP below. I hope I explain this properly. The code below reads in an
external file then based on the tabs, carriage returns etc. outputs in a table
format. What I want to do is get each tab entry into a variable so I can shove
it into a database but I'm not sure how?
This is what I have so far...
<cffile action="READ"
file="C:\mywork\list.txt"
nameconflict="OVERWRITE"
variable="results">
<cfloop index="listrow" list="#results#" delimiters="#chr(10)#">
<cfloop index="thiscol" list="#listrow#" delimiters="#chr(10)#,#chr(9)#,'
','=',';'">
<td class="dirlinks">
<cfoutput>#thiscol#</cfoutput>
</td>
</cfloop>
</tr>
</cfloop>
This outputs in a table with 5 tabs
entry1 entry2 entry3 entry4 entry5
entry1 entry2 entry3 entry4 entry5
entry1 entry2 entry3 entry4 entry5
entry1 entry2 entry3 entry4 entry5
How can I "grab" each entry and shove it into a variable so I can add it to a
database as the CFLOOP loops through file I read in?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:932
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
