Why do you need the files in the database? Are you looking to do some custom stats, or are you using an existing stats package?
Russ -----Original Message----- From: Blaha, James (InfoTechServ) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 13, 2005 3:25 PM To: CF-Talk Subject: Reading apache web access log files? CF Pro's, I have to read in an apache web access log file. Does anyone have any code that they can send me to parse an access log file that could be used to then import the information into a table to run some stats? If you could think of something free or a better way to do this please let me know. I have to read some old access log files... Regards, -Jim I got this far then stopped: <cffile action = "read" file = "C:\access_logTEST.txt" variable = "theFile"> <cfloop list="#theFile#" index="curLine" delimiters="#chr(10)##chr(13)#"> <!--- <cfoutput>#curLine#</cfoutput><br><br> ---> <cfloop list="#curLine#" index="Column" delimiters=" "> <cfoutput>#Column#</cfoutput><br><br> </cfloop> <HR> *** NEST RECORD ***<br><br> </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226961 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
