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

Delete Files

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

How Do You Read XML, AUTO Recordset In ASP?

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

Uplode And Delete Files

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

How Can I Delete All Files On Server?

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

Delete Files Off The Server

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

Delete Files In Server

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

Concerning Delete A Directory With Files

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

Delete Files In Folder

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

Delete Files In Directory!

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

Delete Temporary Files

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

Read Backward Start From The Last Recordset

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

ASP To Read The IIS Log Files

I am wanting to use ASP to read the IIS log files on our web server. Can anyone help?

View Replies View Related

Read ASP Files

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

Read A .wav Files

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

Read .doc Files

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

Multiple Delete Of Files With FSO Error

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

FileSystemObject Delete 'Week Old' Files

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

Read A Recordset Into A Variable So I Can Disconnect From DB And Use Results?

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

ASP Read/Write .TXT Files

How can I use ASP to both read and write to a TXT file?

View Replies View Related

Read Text Files

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

Write/read Txt Files

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

Read / Write Ini Files

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

Read Excel Files

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

Deleting Files From Server... ObjFso Delete

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

Unable To Read Files In Directory

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

FileSystemObject To Read Text Files

Can I use FileSystemObjects to Read Text Files on my server rather than just on my local drive?

View Replies View Related

Read/write DBase IV Files

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

How To Read An SQL Server Into A ASP Page And Then Change, Add, Delete And Write It Back To SQL Server

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?

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

Learning How To "read" IISState Log Files

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

Error Type: ADODB.Recordset (0x800A0BADODB.Recordset (0x800A0BCD)

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

Displaying Image From Database Saves Files To Temporary Internet Files

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







Copyrights 2005-15 www.BigResource.com, All rights reserved