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:
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.
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.
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.
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.
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.
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?
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?
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:
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?
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
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.
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
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.
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?
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
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.
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.
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.
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?
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?
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.