I have spent hours trying to write a function for error checking a csv file. In my function I want to check each field, and if there is an error put the errored text in a structure in an array, the array index will be relevant to the current row id of the query i am looping, and there will be a structure of the errors in each array element ( if that makes sense )
In total I have 24 fields of each row to check, hence me wanting to put the errors in an array so that I can provide an error report to the person uploading the csv file. I have no idea how to test for the existance of the structure for each item i want to test, i create the array first, then i will check each type of field, but i dont want to issue a <cfset errorArray[#rowid#]=StructNew()> if one is already created. <cffunction name="ValidateCSV" returntype="array"> <cfargument name="rowid"> <cfargument name="medicarenumber"> <cfargument name="firstname"> <cfset errorArray=ArrayNew(1)> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54