RE: Log file reader

2004-08-18 Thread Jim Davis
You'd probably be better off looking for a CF-able Java or COM object. MS has a nice COM-based tool here: http://www.microsoft.com/downloads/details.aspx?displaylang=en http://www.microsoft.com/downloads/details.aspx?displaylang=enfamilyid=8cd e4028-e247-45be-bab9-ac851fc166a4

Re: Log file reader

2004-08-18 Thread Claude Schneegans
Has anyone ever used/seen/have/etc a script that can read and parse IIS log files? Not exactly this, but there is a tag perfect for parsing, see CF_REExtract here: http://www.cftagstore.com/tags/cfreextract.cfm -- ___ REUSE CODE! Use custom tags; See

SOLVED: Re: Log file reader

2004-08-18 Thread Ray Champagne
Thanks for everyone's help on this.With some intense googling and some off-list help, I have found the following to be exactly what I was looking for.With some tweaks, it is going to be wicked sweet! http://tutorial34.easycfm.com/ Ray http://www.crystalvision.org At 01:45 PM 8/18/2004, you

Re: SOLVED: Re: Log file reader

2004-08-18 Thread Dick Applebaum
Ray That looks pretty good. My only comment is: if you have large log files, you may not be able to read them into a variable with cffile. If that is the case, you could easily implement a line reader with cfobject That's what I had to do (with help) to read my iTunes song library. This was

Re: SOLVED: Re: Log file reader

2004-08-18 Thread Ray Champagne
I remember your posts back a few weeks ago discussing this, but I didn't have any reason to keep up with the thread, as I have never used cfobject, but right now things are slow and I am tackling things that have been on the back burner here (hence this low-priority project), so if you don't

Re: SOLVED: Re: Log file reader

2004-08-18 Thread Dick Applebaum
Ray, here's the line reader that Joe Rinehart suggested (with a slight mod). Enjoy! Dick Hey Joe Your No Class Reader Works Great! much faster than the other! (almost as fast as a cffile read of the entire file). I simplified the EOF test so I could use a While loop. Thanks Dick Here's

Re: SOLVED: Re: Log file reader

2004-08-18 Thread Ray Champagne
So, I have a question after playing around with this (wow is it much faster than the easycfm way!): I read up a little on cfscript, is it really true that there is no way to use SQL queries inside a cfscript block?I am VERY new to cfscript, but I thought that there was a way that has been

Re: SOLVED: Re: Log file reader

2004-08-18 Thread Dick Applebaum
Thank Joe Rinehart -- he created the code. As to executing a query within cfscript Know you can't --- but you can fudge it create a function (or CFC that issues the query based on a string passed toit.The string contains the SQL statements). within the script tag invoke the function which

Re: SOLVED: Re: Log file reader

2004-08-18 Thread Ray Champagne
I will try that tomorrow - time to bust into a few 'adult beverages' tonight.My wife and I bought our first house today... Thanks (and thanks to Joe too), Ray At 05:44 PM 8/18/04, you wrote: Thank Joe Rinehart -- he created the code. As to executing a query within cfscript Know you can't ---