Server.CreateObject( "Scripting.FileSystemObject" )

[Ologhai]

Hi

I use server.CreateObject( "Scripting.FileSystemObject" )
to read files from a directory. And i've to sort the files by lastdatemodified.

the only way i found it's:

(every time a user is logged)
delete sql table
add files from directory to sql table
sort by lastdatemodified
show files on the browser

i'm sure there is another way to sort this files.
i dont want use SQL table just for sort.

someone have idea ? _____________________________
Hugues Gauthier P.A,DEC
Programmeur Analyste
Progitech GS Inc.

http://www.progitech.com/

hugues.gauthier@progitech.com
hugues_gauthier@hotmail.com
Tel. : (418) 698-4383 #19
Fax.: (418) 698-8633
---------------------
ICQ: 2151800

 

[smbure]

A possible solution is to create a standalone ADODB.Recordset, populate it with the file info, and then use it's Sort property, bypassing going to SQL and the temp table altogether.

hope this helps!
smbure