I am having a heck of a time with this little import script. When it runs,
all I receive are the messages that 'An error occurred while updating the
database.' (as I indicated it should do if the query fails)
Can anybody point me in the right direction?
Thanks!!
--
Jillian
*** *** ***
<!--- Identify the CSV source file --->
<cffile action="" file="/data/intr/pages/tools/data.csv"
variable="csv_import">
<!---
Identify the line delimiter
chr(13) = carriage return
A complete list can be found at http://www.asciitable.com
--->
<cfset dm = chr(13)>
<cfoutput>
<!--- Loop through each line in the CSV source file, using the
delimiter specified. --->
<cfloop index="k" list="#csv_import#" delimiters="#dm#">
<!--- Loop through all records on each line, using the
delimiter specified. --->
<cfloop index="l" list="#k#" delimiters=",">
<!---
Wrap action in cftry tag to catch any
problems, and display an
error message in case the database update is
unable to be completed.
--->
<cftry>
<!--- Perform SQL insert --->
<cfquery name="insert" datasource="#DSN#">
INSERT INTO person_temp (
person_id,
salutation_id,
first_name,
last_name,
title,
qualification,
organization_id,
department_id,
office_id,
status,
role_id,
org_position,
national_board,
userid,
password,
work_phone,
work_phone_ext,
fax_phone,
cell_phone,
pager_phone,
email_wireless,
lung_family,
)
VALUES (
nextval('"person_person_id_seq"'::text),
#ListGetAt(l, 1)#,
'#ListGetAt(l, 2)#',
'#ListGetAt(l, 3)#',
#ListGetAt(l, 4)#,
'#ListGetAt(l, 5)#',
#ListGetAt(l, 6)#,
#ListGetAt(l, 7)#,
#ListGetAt(l, 8)#,
'#ListGetAt(l, 9)#',
#ListGetAt(l, 10)#,
#ListGetAt(l, 11)#,
#ListGetAt(l, 12)#,
'#ListGetAt(l, 13)#',
'#ListGetAt(l, 14)#',
'#ListGetAt(l, 15)#',
'#ListGetAt(l, 16)#',
'#ListGetAt(l, 17)#',
'#ListGetAt(l, 18)#',
'#ListGetAt(l, 19)#',
'#ListGetAt(l, 20)#',
'1',
'#ListGetAt(l, 21)#',
)
</cfquery>
<!--- If the update succeeds, display
confirmation message. --->
<br /><br />
Database update completed.
<!--- If the update failes, display error
message. --->
<cfcatch type="any">
<br /><br />
An error occured while updating the
database.
</cfcatch>
</cftry>
</cfloop>
</cfloop>
</cfoutput>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
