I am using the File System Object to create server side cookies and part of the Function that I am writing deletes a file but I am getting a permissions denied error on that line of code.
I am using Integrated security only on this site but how do I get the IUSER_Machinename account to work with Integrated Security?
On my webpage users can upload files and also delete those files. Everything seems to work, but when they upload a file that contains spaces, I am having problems getting the file deleted, for example: "This is my file.txt"
Is there a way I can delete this file. I have tried to take out the spaces, but the file still doesn't delete: <%=Replace(Request("MyFile")," ","+")%>
I can easily upload images, add to db etc etc... but is there a way of actually dynamically removing image files from the server? At the moment I have clients uploading banner adverts to the server, but if they decide to delete the image, it removes the record from the database.
I need to go one step further and remove these 'old files' from the server instead of simply taking up space etc. anyone have any great applications or scripts I can use with a delete statement?
I have a tbl.pictures on my website, several of the columns have refferal links to images. Having read through another link on this site, apparently it's the best way to do it. (Keeping the images in file rather than on/in the database)
My problem is that when a photographer deletes a photograph from my database the image files remain on my server. For the moment its ok but long term when they delete the record I would also like the images to removed from my server.
It worked fine with access db's but now it's giving me this error...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM releases WHERE title = 'Cabela's Big Game Hunter 2005 Ad
I am trying to write a sub that will delete a spreadsheet file created by the web user. THis is the code I have inserted into the global.asa file, but it is not working.
sub Session_OnEnd 'delete the temporary excel spreadsheet Set objFSO = Server.CreateObject("Scripting.FileSystemObject") objFSO.DeleteFile(Server.mappath("temp/<%=session.sessionid%>.xls")) Set objFSO = Nothing end sub
I have made sure that the temp folder has permissions set for the IUSR_machinename account to be able to delete files. I am running IIS 5 on a windows 2000 server.
I have a text file being create with the FileSystemObject. It's being built based on results from a SQL query. All this is working fine, but so that I have a carriage return VBCRLF at the end of each row, I have an empty row at the end of my text file. How do I delete this last line?
After looking all over the place and finding codes in vb and in php I even had asked several people on other boards but none of them knew how to do it I say the best way to learn this .asp .aspx junk is to DO IT yourself although Ive scripted in the past with the mIRC client which is why I know programming and html but if anyone is looking for the code this is how its done Code:
This code works fine, it deletes the record that already exist in the database and displays a message to the user the record has being deleted.... but it also it has a problem, if you enter a record to delete from the database and this record does not exist it displays the message that the record has being deleted, while instead it should display an error that this record does not exist in the database.
Ive run into a little trouble. I am sure all of you have used hotmail. Well you know when you select all items to delete, i would like to do something like that, however not delete, but update a field from no to yes.
I would like to add checkboxes to an asp table. So if the user selects say three items they then click on a button, say marked and for each item, it will go to the table and find each record in turn and update the corresponding field from a no to a yes.
Updating is no problem. The problem is, how do i add checkboxes to corresponding asp table. So that particular checkbox corresponds to that particular record. I don't know how to link them together.
I have a form that contains many pages. If someone clicks on delete, the application takes the user back to page 1 instead back on page in the breadcrumb trail. It is fine when the user is on page 2 but they could be on page 10 and click delete and then they are back to page one. I want to have the application go back on page at a time each time they click on delete. Here is what I have for code:
If LEN(page & " ")=0 Then page = 1 End If page = CInt(page) If i = page Then response.write "<font color=""#CC0000""><strong>[page " & cstr(i) & "]</strong></font> "
I have a script which allows a user to upload and delete files from the server.Is it possible (and if so how) to do a check to see if the folder is empty (ie if the last file in a particular folder is deleted by a user) and if it is empty, delete the folder?
I'm trying to delete 2 files using fso. The mail file name is stored in an access db.
using the code below I can delete the main file but not the thumbnail.
The thumbnail has the same file name plus the suffix "_small" so if the main file is called "mypicture.jpg" the thumbnail is called "mypicture_small.jpg"
The main file is being deleted but no matter how I try I cannot get the thumbnail deleted. They are both in the same folder with the same permissions.
I am using ASP with SQL for my database.The problem I have is that even after I have ordered certain items from the shopping cart table on the webpage, I cannot remove them - that is the entire list shows up the next time the table is opened.
is there any way I can delete the items once ordered so as to not let them show in my table?
How can I delete the files using ASP?Following is th code :
var objFso = Server.CreateObject("Scripting.FileSystemObject") var strFileName = Server.MapPath(".") + ""+ "SubmittedDoc.xml" if (objFso.FileExists(strFileName)) objFso.DeleteFile(strFileName)
i have a site that has several joins. I need a function that will go out to see if the master table is using a value from a dependant table before it allows the value in the dependant table to be deleted. nothing more than that.it could be a a simple js function that basically does?
rs = recordset
if count(rs) = 0 then delete field else if count(rs) is > 0 then "You can't delete this record"
i would like to delete a specific line of a text file. for instance, if the line i'm looking for is "abc", then i'd like to delete that line only (all the lines are unique).
is it possible to do this? or would it be easier/better to read all the lines into an array, delete the file, recreate the file with the lines from the array, skipping over the line i don't want?
I have a problem of deleting old version of files. This is wat happens: Client side sends a few files to the server side via http and are saved into a folder. I need to delete these files when another batch of files are send next time. Any suggestions to solve this problem.
Timestamp is out of question because it is not reliable to use time to differentiate between files within the same batch and other batch. Sometimes the sending might be delay by server. Therefore i need to come up with some sort of detection for new batch.
i'm using the following code to delete a file but when i execute the script it just freezes until timeout. any idea of the problem?
'///DELETE ORGINAL FILE Dim objFSO Set objFSO = Server.CreateObject("Scripting.FileSystemObject") objFSO.DeleteFile "C:Documents and SettingsGavMy DocumentsDateWebsitewwwuser_images" & filename Set objFSO = Nothing
What functions are possible to delete rows, tables, entire database from the URL when displaying records from a database. I want to be able to stop all of these possibilities from happening.
I am not sure if this is the right place to ask. but... I need to delete records where two fields in the same record are equal. I am not sure how to go about this.will this work?
strQ ="DELETE FROM Request_Notify WHERE Field1 = Field2"