I've got a file of comma delimited fields, and I need to put them in a
database. What I've got so far is nearly working... but it appears that
some fields are being skipped over (because they are blank). I've tried to
make all blank (,,) into (, ,) so there is technically 'space', but the data
is still not properly aligned in the columns. I'm going insane. :)
This is a line of what I'm trying to import:
1,C,7/28/2003 19:16.23,198.169.175.14,,,,,,,,,,,,Asthma
medications,Most,,Yes,It bothers me a
lot,Yes,Yes,No,No,No,,20-34,Female,Yes,
This is my code:
<cffile action="" file="/data/www/intranet/testing/data.txt"
variable="data">
<cfset data = "" ",,", ", ,", "ALL")>
<!--- Read the inputs into a "Line" variable --->
<cfset counter=1>
<cfloop Index="Line" List="#data#" delimiters="#chr(10)#" >
<cfset item1=gettoken(Line,1,",")>
<cfset item2=gettoken(Line,2,",")>
<cfset item3=gettoken(Line,3,",")>
<cfset item4=gettoken(Line,4,",")>
<cfset item5=gettoken(Line,5,",")>
<cfset item6=gettoken(Line,6,",")>
<cfset item7=gettoken(Line,7,",")>
<cfset item8=gettoken(Line,8,",")>
<cfset item9=gettoken(Line,9,",")>
<cfset item10=gettoken(Line,10,",")>
<cfset item11=gettoken(Line,11,",")>
<cfset item12=gettoken(Line,12,",")>
<cfset item13=gettoken(Line,13,",")>
<cfset item14=gettoken(Line,14,",")>
<cfset item15=gettoken(Line,15,",")>
<cfset item16=gettoken(Line,16,",")>
<cfset item17=gettoken(Line,17,",")>
<cfset item18=gettoken(Line,18,",")>
<cfset item19=gettoken(Line,19,",")>
<cfset item20=gettoken(Line,20,",")>
<cfset item21=gettoken(Line,21,",")>
<cfset item22=gettoken(Line,22,",")>
<cfset item23=gettoken(Line,23,",")>
<cfset item24=gettoken(Line,24,",")>
<cfset item25=gettoken(Line,25,",")>
<cfset item26=gettoken(Line,26,",")>
<cfset item27=gettoken(Line,27,",")>
<cfset item28=gettoken(Line,28,",")>
<cfset item29=gettoken(Line,29,",")>
<cfset item30=gettoken(Line,30,",")>
<cfquery datasource="asthma_sur">
INSERT INTO "survey"
("entry_number", "correct_status", "entry_date",
"ip_address", "name", "email", "company", "street", "city", "state", "zip",
"phone", "fax", "homepage", "comments", "why_visit", "did_you_find",
"what_added", "have_asthma", "if_have_asthma", "blue_inhaler",
"cough_wheeze", "cough_night", "exercising", "miss_work", "someone_close",
"age", "gender", "canadian", "nullfield")
VALUES
('#item1#','#item2#','#item3#','#item4#','#item5#','#item6#','#item7#','#ite
m8#','#item9#','#item10#','#item11#','#item12#','#item13#','#item14#','#item
15#','#item16#','#item17#','#item18#','#item19#','#item20#','#item21#','#ite
m22#','#item23#','#item24#','#item25#','#item26#','#item27#','#item28#','#it
em29#','#item30#')
</cfquery>
</cfloop>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
