Here's my solution, for anyone interested:
<cfquery name="delete_offices" datasource="#application.dsn#">
delete from hmls_office_temp
</cfquery>
<cfset filepath =
"e:\inetpub\webroot\real_estate_data\hmls\data\#DateFormat(now(),
'yyyy_mmdd')#_idx_custom\office.txt">
<cffile action = "read" file = "#filepath#" variable = "hmls_offices">
<cfset hmls_offices = #Replace(hmls_offices, "#chr(9)#", ", ", "All")#>
<cfset hmls_offices = #Replace(hmls_offices, "#chr(13)##chr(10)#", "|", "All")#>
<cfset firstline = "true">
<cfloop index = "record" list = "#hmls_offices#" delimiters = "|">
<cfdump var = "#record#"><br>
<cfdump var = "#firstline#"><br>
<cfif firstline is "false">
<cfset temp_office_id = #listgetat(record, 1, ",")#>
<cfset office_name = #listgetat(record, 2, ",")#>
<cfset mail_address_1 = #listgetat(record, 3, ",")#>
<cfset mail_address_2 = #listgetat(record, 4, ",")#>
<cfset mail_city = #listgetat(record, 5, ",")#>
<cfset mail_state = #listgetat(record, 6, ",")#>
<cfset mail_zipcode = #listgetat(record, 7, ",")#>
<cfset phone = #listgetat(record, 8, ",")#>
<cfset fax = #listgetat(record, 9, ",")#>
<cfset office_email = #listgetat(record, 10, ",")#>
<cfquery name="insert_office" datasource="#application.dsn#">
insert into hmls_office_temp
( temp_office_id, office_name, mail_address_1,
mail_address_2, mail_city,
mail_state,
mail_zipcode, phone, fax, office_email
)
values ( <cfqueryparam cfsqltype="cf_sql_integer"
value="#temp_office_id#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#office_name#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#mail_address_1#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#mail_address_2#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#mail_city#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#mail_state#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#mail_zipcode#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#phone#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#fax#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#office_email#">
)
</cfquery>
<cfelse>
<cfset firstline = "false">
</cfif>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308174
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
