> 1. Line 1 of the txt file contains what used to be column names from > excel. is there a way to remove line 1 so it stops inserting column > names into my database?
Can you create a counter before your loop starts, then increment it as the loop proceeds. <cfset ctr = ctr +1> <cfif ctr NEQ 1> <cfquery blahblah...> </cfif> If the ctr isn't on line 1, run the insert. > 2. Using code i'll put below, i get this error, and i am baffled. > > Here is the error: > > Invalid list index 17. > In function ListGetAt(list, index [, delimiters]), the value of index, > 17, is not a valid as the first argument (this list has 16 elements). > Valid indexes are in the range 1 through the number of elements in the > list. You need to dump this record variable and see what it looks like. It obviously doesn't have 17 elements in it. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
