Webmaster Forum / ColdFusion / Advanced Techniques / August 2007

Hi i have a system task that runs every 60 seconds.
this  processes a piece of code, this code downloads emails with csv
attachments and saves the attachment to my server

then my code goes through the csv file and inserts each row into an array.
i then insert the array into my table.

some of the inserts are only getting 3/4 of the way through the csv file (not
inserting the full csv content into my table).
could this be a time out ?

if so how can this be fixed?

<cfset columncount = 7>
<cffile action="read" file="#currentdir#/#GetUser.Match#.csv"
variable="datafile">
<cfset counter = 1>
<cfloop index="datarec" list="#datafile#" delimiters="#chr(13)#">
<cfif counter gt 1>

<cfset dataArray = ListToArray(datarec,chr(44))>

<cfif ArrayLen(dataArray) eq columncount >

<cfquery name="INSERT" datasource="#application.ds#">
insert into sms_players_table
(Surname, FirstName, Phone, Group, Class, App_ID, ClubID)
values

('#dataArray[1]#','#dataArray[2]#','#dataArray[3]#','#dataArray[4]#','#dataArray
[5]#','#dataArray[6]#',#getuser.clubID#)
</cfquery>
<cfelse>
column count not macthed
</cfif>
</cfif><cfset counter = counter + 1>
</cfloop>