Any body seen this happen before ?

The follwing code is executing the cffile command correctly and outputs
correctly from the cfdump

The cfquery to insert new records is inserting the first record from the
insert stament but is not looping to the next record

Commenting out the query, to run the insert staement, loops though and does
the screen output successfully


The code below works fine on CF MX6 using CF internal webserver but is no
longer working in CF MX7 on IIS6

<cfset sde_datasource = "sdetest">

<cfhttp name="InFile" method="get"
url="http://espatial/tpnz/input/#cffile.ClientFileName#.#cffile.ClientFileExt#"
delimiter=","></cfhttp>
<cfdump var="#InFile#">

<cfquery name="CearTable" datasource="#sde_datasource#">
truncate table tpnz_parid
</cfquery>

<cfloop query="InFile">

<cfquery datasource="#sde_datasource#">
insert into tpnz_parid (par_id) values (#InFile.par_id#)
</cfquery>

<cfoutput>#InFile.par_id#<br></cfoutput>

</cfloop>