Recent content by dkn

Cheers!! I'm sure I'll be able to cobble something up from that.

Hi all, I have an application that produces some reports in the form of charts / graphs. My users want trendlines adding to some of the charts, but the charting software I am using doesn't automatically support trendlines. So my alternative is to manually calculate a trendline and add it as a...

Thanks vongrunt, I'll give it a wizz and see how it goes. David

Not sure if this will help, but I wrote a document management application a couple of years back. I think I used Asp Simple Upload to manage the file transfer part - anyway, if the user specified a path that didn't exist (i.e. a new directory) then these were created automatically when the file...

Hi All, Does anyone know if there is an ASP Function that works in reverse to the WeekOfYear function. As an example, I have a table that stores the Week as an integer between 1 and 52, and also the year. I want a function that I can supply these two arguments, and get the date of the Monday of...

OK, problem solved. Created a Schema.ini file and stuck it in the same same directory as the CSV file and hey presto, it works! For anyone who is interested, here is the content of the Schema,ini file :- [data0021.txt] Format=CSVDelimited Col1=RecNumber Long Col2=UsageDate Text Col3=UsageTime...

I think I may be onto something.... Very useful article here :- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting03092004.asp It looks like I can create a file called Schema.ini, were I can specify the data type for each field in the CSV file. Just need...

Keith, Thanks for the reply. I was thinking along the same lines, but what confuses me is I haven't (and dont know how to) define data types when reading the CSV file. This is the line of code that does all the work of creating a recordset from the CSV file :- MySet.Open "SELECT * FROM...

Hi all, I'm currently working on a reporting application that get its data from a CSV file. The data from the CSV file is read and placed in an Access DB table. Here is the code I am using... Set MyConn = Server.CreateObject("ADODB.Connection") Set MyConn2 =...

Thanks, I'll give it a try.

Hi I'm currently developing a Document Management System, and one of the requirements is to keep a log of all files that are downloaded and uploaded to the server. I'm having problems with creating a download log. The document detail are displayed in a table, with the download activated by...

Unfortunately the previous server isn't with us anymore, so I can't check the settings. As an aside, does anyone have (or have a link to) the help pages for aspsimpleupload. The only site I can find where they're available is asphelp.com, and this has been inaccessible for a while now. Thanks...

Hi I have a document management system that uses the ASPSimpleUpload component to upload the files to the server. We have recently moved servers and the way the upload performs has changed. When I was previously uploading a document, if the directory structure it was required to be uploaded...

Okay, more info for anyone who may be able to help. I can create a single sub directory on the fly, but when I want to create multple level subdirs on the fly I get the error telling me to check the permissions. #################### example if I upload a file with say the following path...

Hi I have a document management system that uses the ASPSimpleUpload component to upload the files to the server. We have recently moved servers and the way the upload performs has changed. When I was previously uploading a document, if the directory structure it was required to be uploaded...