In fact, I just wrote an article for CFDJ on using <cf_querysim> to load Apache log files for analysis. They haven't said what issue it will appear in, which leads me to believe somewhere in the August timeframe.
The technique is very simple: you create a log file definition for Apache that uses the pipe symbol to delimit fields instead of a space, then you <cfinclude> the log file inside a <cf_querysim> tag, like this: <cf_querysim> qryApacheLog client_address,ident,userid,request_time,request,response_status,size <cfinclude template="access.log"> </cf_querysim> Bam! You've a got a recordset called "qryApacheLog" that you can use as you like. If you're using CF5, you can use query-of-query to do your analysis. - Jeff BORKMAN Lee wrote: > Actually, it's even more useful than the "simulator" label implies. > > What it does, pure and simple, is create a recordset. That can be used > for > query-simulation, true, but has other uses, including creating zero-row > recordsets for populating forms. People (ie Hal) keep finding new uses > for > the tag. > > Have fun, > LeeBB > > -----Original Message----- > From: hal helms [mailto:[EMAIL PROTECTED]] > > > > You're exactly right, Evan. It simulates a query (hence it's ugly name). > Syntax is like this: > > <cf_QuerySim> > Composers > firstName,lastName,genre > Ludwig|Beethoven|Romantic > Arnold|Schoenberg|Dodecaphonic > Danny|Elfman|Modern > </cf_QuerySim> > > You'll get a recordset called "Composers" that has three fields: > firstName, lastName, and genre. Each subsequent row in the querysim tag > is a row of data in the query. > > It's very useful when writing code if and doing database queries > simultaneously. > > -----Original Message----- > From: Nat Papovich [mailto:[EMAIL PROTECTED]] > > HalHelms.com (http://halhelms.com/index.cfm?fuseaction=code.detail) has > the best implementation of it. It was Halbert's idea to begin with but > Bert Dawson (da man) made it spiffier. Bert's update is available from > the link above. > > > -----Original Message----- > > From: Evan Wilders [mailto:[EMAIL PROTECTED]] > > > > > Thanks, Nat. I'll do that. On a different topic, I've > > seen several references to a custom tag called > > cf_querysim. It looks like this is simulating a record > > set. Is that right? Where can I get that tag? > > > > > IMPORTANT NOTICE: > This e-mail and any attachment to it is intended only to be read or used > by > the named addressee. It is confidential and may contain legally > privileged > information. No confidentiality or privilege is waived or lost by any > mistaken transmission to you. If you receive this e-mail in error, > please > immediately delete it from your system and notify the sender. You must > not > disclose, copy or use any part of this e-mail if you are not the > intended > recipient. The RTA is not responsible for any unauthorised alterations > to > this e-mail or attachment to it. > > > ==^================================================================ This email was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================
