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 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).
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
SQL = "CREATE TABLE "
SQL = SQL + Left(Date, 2) & ":" & Left(Right(Date, 7), 2) & ":" & Right(Date, 4)
SQL = SQL + " AS(SELECT *"
SQL = SQL + " FROM Faults"
SQL = SQL + " WHERE (((Month([DateAdded]))=Month(Date())-1));"
the error that appears is... "Error 3290 - Syntax Error in CREATE TABLE statement"
can you work out whats wrong?
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?
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.
View Replies View Relateddo 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.
View Replies View RelatedI need to know how to create a dynamically named list of a collection of records from my database.
All the records come from one table using the DateCreated column as the column that I want to collate the records with.
I want to group all the records in eg: march 2007 under a dynamic heading of 'March 2007' and the same for every other month in the table.
The date format in the DateCreated column is: dd/mm/yyyy
It's kind of a blog achive.
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.
Is it possible to extract files and folders from a zip archive using ASP? If not classic, will .net do it as a standard task, ie no activex dlls, etc?
View Replies View RelatedI have being trying a create a dynamic news section on my web site for a while now and I cant get it to work.
I would link the home page to display the four newest news items and then a link to a news archive on a seperate page.
The news archive will have links ordered by YEAR then MONTH, similar to the following page: Code:
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.
View Replies View RelatedIs 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:
View Replies View RelatedEnvironment:
Development PC: W2K Professional
WebServer: W2K Server, IIS 5.0
Peer-to-Peer network
I'd like to create a new asp.net project on a remote server (not on the
local (development) machine. I have looked for info on how to do this, but
all I can find are instructions on how to create on localhost, then deploy
later to remote machine.
what's involved in creating an ASP? I need to create a web page where users can check their past history of the account.
View Replies View RelatedSo i currently have an asp page that creates an xml document with information from a database. However I need to link to my schema when creating the Root element here,
Set objRoot = objDom.createElement("projects")
this is the link that would go into projects:
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="semesters.xsd"
Im trying to create a string from checkboxes that have been checked, but for some reason its not working
strNumbers = ""
for each key in request.form("chkFacility")
strNumbers = strNumbers + "" & key & ","
intCount = intcount + 1
next
So I want to end up with a string like this '3,12,7.' Instead Im just getting a single number. Am I doing this the right way. Any help wud be just fantastic!!
I know how to use ASP to create and write into a .CSV file on the server, but I have a small problem. Every time I write to the file I am adding new lines each time. I don't know how to wipe the previous contents out, and I thought this is probably a no-brainer for you guys ...
So, I'm looking either to delete the file at the start of the process and start from scratch or
* open the file
* wipe all contents from file
* write to the newly cleaned file
How can i create a ZIP file from a folder (full of files) of the server.?
View Replies View RelatedI have an asp page where i created cookies-for admin and for user. The aspx page reads these cookies. Everything seems to work fine but now i have to create a new cookie if cookie has expired or if cookie is null. Also, i am having problems with the expire because if the username belongs to the admin for example and then i want to change
the username that belongs to a normal user the cookie recognises the first (admin) cookie. How do i solve this? .....
I want to create an order form for prints online... I will have up to 200 prints to be selected. What I am thinking is that I will have an HTML Form that has all the 200 thumbnails with a check box next to them. They select the ones they want and push next. Then I would like it to create a set of options for each one they selected.
That basically says the image name then has a check box for 5x7, 8x10 and a text box for the amount for each... I do I create the page what creates these selections and how to I incorporate that into a mail form going to the next page?... it seems like a simple enough idea. Am wondering how the reality of it will be.
I am trying to pass a form value and pull some values from an array. I am getting no errors but no values on this code. Any ideas? Code:
View Replies View RelatedI am using asp and access database. I need to create a menu according each member access. In other words, if member login I need to display the menu according to the services the member selected during registration. Each service contains diff type of products.
Service1
-produc1
-product2
Service2
-produc1
-product2
-product3
..more
Service3
-produc1
-product2
..more
What is the best way to this...
i have website which provide daily news. we store the news into sql database. i want to create a rssnewsfeed which i can provide to other websitemasters. can anyone tell me the asp code or other where i can create rssnewsfeed from my sql data.
View Replies View RelatedI have a problem. I have a database with 1000 e-mails that i use in my
mailinglist. And when i send them mails it takes kinda long since i attach a
..pdf file each time. so i was wondering if there is a way in asp to create a
task on the webserver using asp to trigger a script that sends the mails.
sure i could use server.scripttimeout but the thing is that i dont want to
wait 30 seconds for the page to finish loading. and if there will be 3000 in
near future i'll have to wait for a very loooooong time.
anyone know how to create a task using asp dynamically?
I'm doing a gallery and I need to make some thumbnails of the images, but yeah...I don't know how, especially since I can't access the server to install stuff. And to be honest I wouldn't know how to install them in the first place (linux server)
Now...the best solution I've come up with so far is to send a string to another webserver that runs on a decent platform and use asp.not to make the thumbnail and then link it from there...would be a pain in the butt though, so if anyone has some good advice then I'm all ears (even if the advice is to give up, tbh)
I'm pretty new to the whole concept of Server Side programming and am currently developing some important elements for a site I have made with Classic ASP programming. One of the things my employer wants me to develop is a Server Side script that will allow a report in PDF format to be generated online to customers who make use of the tools.
View Replies View RelatedI need to format each row being returned in a recordset as
a hyperlink. One of the fields being returned is the
subject of a message that my hyperlink will show. When
the hyperlink is clicked then the ASP page loads further
message details of that link. Does anyone know how to do
this?
I have the following graph (see atttached file) and was wondering if it would be possible to create this graph by using ASP and how easy it would be. If it is possible could someone give me a few links to sites where I could get some code to start me off.
View Replies View RelatedIs it possible to create a folder using a virtual path? This is for a site on a shared hosting server.
View Replies View RelatedFirst, how can I get asp to create a table in en existing DB that is an atuonumber. Meaning.. If say table 56 exists alrady, I want it to create 58 as the name. Along with this, I need to copy the fields from table temp, into the above DB. Can this be done?
View Replies View RelatedI get a "-2147467259" error (unspecified error) when I try to instantiate an
object on my web page. the object is in registered in the Component
Services and when I test the component manually by a VB app, it works fine.
My web site virtual directory security settings allows me to execute scripts
(if that helps).
I am currently pulling records from my database and exporting them to rtf.
My problem however lies in formatting the data in the rtf. More specifically with putting the data into a table.
Does anyone know how to control the width of a table when generating a rtf?
How do I create a recordset from another?
e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn
sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn