 			</cfloop>
 		<cfif #o# is 1>
 			<cfset colNames=replace(colNames,",","","first")>
-		</cfif>	
+		</cfif>
 		<cfif len(#colVals#) gt 1>
 			<!--- Excel randomly and unpredictably whacks values off
 				the end when they're NULL. Put NULLs back on as necessary.

	TRANS_REMARKS varchar2(4000),
	IS_PUBLIC_FG number,
	TRANS_AGENT_1  varchar2(255),
	TRANS_AGENT_ROLE_1  varchar2(255), 
	TRANS_AGENT_2  varchar2(255),
	TRANS_AGENT_ROLE_2  varchar2(255),
	TRANS_AGENT_3  varchar2(255),

		i$agent_id_6=getAgentID(TRANS_AGENT_6)
</cfquery>
<cfquery name="cid" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
	update CF_TEMP_ACCN set
		i$collection_id=(select collection_id from collection where collection.guid_prefix=CF_TEMP_ACCN.guid_prefix)
</cfquery>
<cfquery name="cid" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
	update CF_TEMP_ACCN set IS_PUBLIC_FG=0 where IS_PUBLIC_FG is null or IS_PUBLIC_FG != 1
</cfquery>
<cfquery name="dup" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
	update
		CF_TEMP_ACCN
	set
		i$status='duplicate accn number'
	where
		i$collection_id || ':' || ACCN_NUMBER in (select collection_id || ':' || accn_number from trans,accn where trans.transaction_id=accn.transaction_id)
</cfquery>

