Ok, here's what I'm trying to do. I'm trying to get the max or min of a filename in a given directory.

Let's say I have 3 files that have year/month in the name as this.

A_200801.txt
A_200802.txt
A_200803.txt

They are all in the same directory and I want my ASP to give me back the max filename of A_200803.txt. If it were sql, I would just go a select max(filename) from table where filename like 'A_%', but being it's not SQL I can't.

So how is this done?? I found a sample script in ASP that gives me a directory listing, but it's no help in figuring out how to just grab one filename where the name may change slightly.

Thanks.

Why can't you put the filenames into a temp table [#whatevertemptable] and select the MAX or MIN from there?

You have posted in the ASP.NET forum so I will assume that your reference to "ASP" above is a reference to an ASP.NET script.

So with that out of the way, the solution to this is very simple:

System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo();
System.IO.FileInfo[] files = new System.IO.FileInfo();
files = dir.GetFiles("");

GetFiles() has a return type of FileInfo[] which is just an array of files so:


To get access to the first file in the directory you would do:
files[0]
and the last file
files[files.GetUpperBound(0)]

By doing this you are making the assumption that first file returned by GetFiles is the one that you want and vice versa for the last file.

Just be careful, you are working with IO here and if you have large amounts of files that you are loading this can become slow and bog down your server.

hth.


================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

dparsons,

Sorry about the post. I was looking for classic ASP. I didn't realize I posted in the wrong forum till your post. Regardless, I'm planning on learning .Net within the next few months so your reply still helps. I'm going to now repost in the classic ASP forum.

Thanks!

If you're putting the files up with an uploader you could always write the filename and path to the database and you'd be in like Flint.