Hi all -
I'm trying to (unsuccessfully) import a comma delimited text file
(from an MLS service) into a MySQL db and looping over the file using
listgetat in this manner:
...
'#listgetAt('#index#',4, ',')#',
'#listgetAt('#index#',5, ',')#',
'#listgetAt('#index#',6, ',')#'
...
I'm suspecting that the format of the text file is breaking my code.
Here's a sample of the text file.
"RES","A","AUN",776082,877,"","ST","RACINE","HOFFMAN
TOWN",80011,3,2,"RES","1051","","","KELLER WILLIAMS REALTY
LLC","CHARMING RANCH STYLE HOME, 3 BEDROOMS, 2 FULL BATHS, CONCRETE
EXTENDED DRIVEWAY (ISSUES), NO FHA !!",5,"",,"","AURO",1681,
Note that text items have quotes around them and number items don't.
Also, text items can and do include commas within. Am I improperly
using the listgetat function? If so, how can I rewrite it to get
around these issues?
Many thanks in advance,
Les
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331764
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
