what i'm trying to do, is to create table identical to "faults" and move all of last months entries into the new archive table.
the current SQL i have is
my question is regarding using ASP to loop through the results of a sql query and calculate a monthly total based on a date field.
I am using the following query to total the number of train rides for a given branch by day type (weekday, Sat., Sun.) and create a 3 month rolling avg. (to diminish large fluctuations in the data). I am using Oracle 9i to store the data.
Please see below for the database query, the query output, and the desired output using ASP to sum the rides for each month. Code:
As the client uploads the December news story, it replaces the November story and adds November to a dropdown menu on the news page.For example, all archived months stories can be accessed from the dropdown menu and the current month is visible on the page. Hope this makes sense! Can anyone help, or point me in the way of some script I can download?
How can i create a ZIP archive of an already present folder? This folder might have some nested folders in it too. I have seen some components where we can create the ZIP archive but these add the files to the main archive folder that will be created when you specify the name of the archived folder and its intended destination. I already have the folder with the files in it.
i want to add this portion to my site.i want to display category of news depending on date.i want to display such news one month back from current date.
do you know how to archieve data from database. if the was true with the data from database it will chechked or some thread or site for me look. i dont know to archieve it looked not same like using drop list.
i have a created a CMS in which newstitle, the newsdetails and date(automatically inserted using the date() function) that it is added is inserted into an access db. Now what i want to do is to create a news archive list which groups the news item added by month, so let's for the month of july all news are grouped into a heading call july(2007).
The page below sends archives of video for the component aspSmartUpload. All time that I try to send a video archive wmv appears this error:
Request object error 'ASP 0104 : 80004005'
Operation not Allowed
/tvonline/video_enviar.asp, line 30
In line 30 I have this.
objUpload.Upload
I already verified the way of the folder and the permission of the folder for reading and writing and I am all certainty. I do not understand because it is showing this error.
I'm experimenting with using Windows Scripting Host to open files via Shell. So far I can open Word docs and Winzip archives. Is it possible with Shell to programatically cause winzip to extract an archive it to a particular folder? Self-Extractor isn't an option in this case.
Is there a script or a simple way(I doubt), to create archive files online without components...only with asp? by "archive files"....I mean .zip files or something similar that can then be de-archived later? It is not important whether the files get compressed or not. Code: