Re: Any reason not to use this query of queries?

2008-03-27 Thread Dominic Watson
I should think so; problems occur with QoQ when it can't figure out the type of data in a column accurately. With the cfdirectory result query, there will be no problems correctly identifying the 'name' column as a string type. Dominic On 27/03/2008, Jim McAtee <[EMAIL PROTECTED]> wrote: > > I h

Any reason not to use this query of queries?

2008-03-26 Thread Jim McAtee
I have a directory containing dated log files that I need to parse. These have filenames like: reMMDD.log So I do a to pull a list of files: But I want exclude today's log from being processed. This isn't possible using cfdirectory's filter, so I figured: SELECT * FROM dir WHERE n