FSO Delete Files As Read From Recordset
I have client who has database full of crap. One field in the "property" table is imageurl. I have been able to successfully extract only the file name from the string, such as "2030323.jpg". All images are stored in a directory called "listings". What I am trying to do is to loop through the recordset, and read each imageurl.
If there is an image file in the "listings" directory, then delete the file. It appears that some fields contain imageurls that no longer exist in the listing directory. Here is the code I have so far, I almost had it, as it told me at one point the file didn't exist. Then I screwed up the code and this is where I am at: Code:
View Replies
ADVERTISEMENT
Is it possible after i run my process i delete text files from server.
I run a process to read from text files after that i want to delete
these text files so that no one again run the process.I am using ASP.
View Replies
View Related
I have an ASP page that is reading records from a SQL database and passing them as a string to a DIV. I would like to do that using XML. SQL 2000 has this great XML, AUTO feature that I would like to utilize. My retrieval code goes something like this:
set objSQL = CreateObject("adodb.connection")
set objRS = CreateObject("adodb.recordset")
objSQL.Open "Provider=sqloledb; Data Source=MYDB; Initial Catalog=MYTABLE;"
objRS.Open "SELECT * FROM MYTABLE XML AUTO, ELEMENTS", objSQL
So, now I have a recordset with the XML code in there. How do I get at it? Let's say I want to Response.Write it.
View Replies
View Related
Could anybody show me an example of code to upload files from a local drive, and delete files from the website. of course the easiest way to do that is to use any FTP client.
View Replies
View Related
i want to delete all files from a dir off the server any suggestions?I know how to delete specific files but i dont know how to delete all files.
View Replies
View Related
Linux Server with Chillisoft ASP.
How would I get an ASP page to delete an image file, probably a .jpg off the server.
Basically, what I want to do, is that when the user deletes a product item from the database, it will also delete the corresponding image file from the images folder. So that the server space doesn't just fill up with redundant image files over time.
If it makes any difference the image files are uploaded using a PHP script, I've no idea how it works, but it does.
View Replies
View Related
I have a Product and that product contains some documents.The documents are uploaded to server and can be viewed in my asp application.
In admin module i have given option to edit or delete that product.In the event of edit just the records in the database get changed.But in the case of delete i have to do 2 things
1. Delete all the data related to that product.
2. Delete all the related documents for that product in the server.
So can anybody help me figure out how to delete a file using asp in ftp server.
View Replies
View Related
I understand how to delete files within a directory using the Scripting.FileSystemObject.
However, how can I delete a directory using ASP 2.0 on an older IIS 4.0 server? Do I need to:
1. Delete all the files within the directory.
2. Change the directory's permissions.
3. Delete the directory.
Am I able to delete a directory without changing the permissions? Can I delete a directory with files inside the directory or does the directory need to be empty?
View Replies
View Related
I need to create a script that deletes all pdf files in a folder that are over 1 day old. I know I need to use the file system object and datediff but can't for the life of me work it out. I am a bit of a newb when it comes to more complicated asp .
Does anyone have a script that does this or know of a tutorial that will teach me how to do it?
View Replies
View Related
I am wanting to delete all files contained in a directory.
I won't have the name of the file...
Can i do this somehow??
View Replies
View Related
Is it possible to delete internet temporary files using ASP code? And maybe specify the extension of the files to delete?
View Replies
View Related
I have a problem in my project to read backward start from the last record in my database. I need to display the graph using asp and SQL server as my database.
How can i set in asp coding to read from the last record then go to the previous record before i can display the graph... Code:
View Replies
View Related
I am wanting to use ASP to read the IIS log files on our web server. Can anyone help?
View Replies
View Related
I need some help because I don't know much about ASP files and I have some on my computer but am unable to read them. What program do I need to install to do that?
View Replies
View Related
I am having a few .wav files and want to read some contenet out the .wav files do i need any componenet to read this file , or it can be done via asp using file system objects or any other possibilites.
if you open any .wav files in any text editor you can see it shows some information garbled and then some text which is useful for tracking the wave files if stored in database i want to do that same.
this is what i see in the last row of my wav file from which i hv
06908 08282006 121408 23 8038 21 0314476 000000000 20 03 0
View Replies
View Related
does anyone know of a ASP script that opens .doc files , read its contents and displays them on browser. please i need this script urgently, i know its read binary and not text but i want someone to help me with the script.
View Replies
View Related
I try to do a multiple delete of files through FileSystemObject, but after deleting the first file, ASP gives me a "Permission denied" error. Below you see my code:
Set fso = CreateObject("Scripting.FileSystemObject")
For Each Item in Request.Form("filename")
delFile = path2 & "files" & Item
fso.DeleteFile delFile
Next
View Replies
View Related
I know this is going to be blindingly simple but I've had one of those days where the more I search and try, the further away from finding the solution I am!
What I'm trying to do is really simple, but the last part of it I can't seem to get right... hopefully someone will spot it straight away.
<%
fPath = Server.MapPath(".")
qDate = DateAdd("d", -7, Now())
Response.write qDate
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set Folder = objFSO.GetFolder(fPath)
For Each i In Folder.Files
If i.DateCreated <= qDate Then
'objFSO.DeleteFile(i.Name)
Response.Write i.Name & "<br>"
End If
Next
Set i = nothing
Set Folder = nothing
%>
As you can see, I've got down to selecting all the week old files no problem, but when I come to execute the 'objFSO.DeleteFile(i.Name)' line - I either get file not found or nothing at all.
Something to do with the ServerPath?
View Replies
View Related
This seem to be a simple question, but I'm having no luck with Google
keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.
Is there a method that I can use to copy the recordset into an array
(collection, etc), the close my DB connnection and finally process the data
I copied from the recordset?
View Replies
View Related
How can I use ASP to both read and write to a TXT file?
View Replies
View Related
I want to read textfiles with ASP. But I want to do this in a special way.
I want to set a variable, for each line.
So for example:
Dim line1, line2, line3, line4, line5
line1 = Line 1 of the text file
line2 = Line 2 of the text file
line3 = Line 3 of the text file
line4 = Line 4 of the text file
line5 = Line 5 of the text file
How do I have to do this? .....
View Replies
View Related
I need to do something very basic in asp. What I want to do is have one page that has a text box, and a button... the user can type whatever in the text box, and click submit, and it will create a txt file. Every time the button is pushed it overwites the file...
Then on a seperate page, whenever the page is loaded, it reads from the file and posts it on the page..I think this is very basic, but I'm very new.... I need to write it in standard ASP. One other thing that would be helpful is to have a limit on the amount that the text box will hold.
View Replies
View Related
im making a proj. that would read ini or txt files.. and would display the content of that file in a combo box..
ex.
aaa
bbb
ccc
im currently using this "<!--#include virtual="//path/filename.ini"-->" but the problem is, it would display all the text on that file..
is it possible to retrieve the content and display it in a combo box per line?
ex.
line 1 : aaa = list.index(0)
line 2 : bbb = list.index(1)
line 3 : ccc = list.index(2)
View Replies
View Related
i was wondering if it is possible to read an excel file from the client side and for example, print the cells info in a <table> using ASP of course
I have one that makes this but, i have to indicate the fisical location of the file (C:inetpubwwwrootexcelfileexmpl.xls), wich means, my machine.
View Replies
View Related
I'm trying to delete files from the server and its not working. Can any one help please?
It says the file doesn't exist... where as the file exists...
I did a response.write for my delFile to make sure its there but it doesn't see the file... Code:
View Replies
View Related
IIS cannot read files in a directory reporting that :
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Fso.GetFolder'
This has to do with Scripting.FileSystemObject.
I make sure the scrrun.dll is properly registered with regsvr32.
Still the problem persists.
Previously I do not know what I did right once in permission setting and
managed to display the said files but it went away after tweaking the
permission for make other functions available.
I scoured the web and this problem is a perrenial one. Many many suggestions
have been made even in expertsexchange site but no real solution. I don't
understand why it is so difficult to have this file system service up and
running.
View Replies
View Related
Can I use FileSystemObjects to Read Text Files on my server rather than just on my local drive?
View Replies
View Related
I've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View Replies
View Related
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
View Replies
View Related
How can use ASP to read in the ms-word document files the content, then copy
the content to access?
I attempt ("word.application") have opened with CreateObject to word
document only. Can I use "Find" function to search ms-word content in ASP?
View Replies
View Related
I'm trying to debug an application that causes ASP to stop responding
while the other IIS services continue to run and the server continues
to serve static HTML pages. I've captured a set of log files using
the IISState utility but I'm not sure what I should be looking for.
Would you be able to point me to some resources to help me to learn
how to interpret these files?
View Replies
View Related
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
View Replies
View Related
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
View Replies
View Related