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.
Code: ...
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.
Can someone help me out please?
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 having trouble creating a one record recordset then deleting it. I've never done this before. The code below returns: "Type mismatch: objRS".
Code:
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")," ","+")%>
this is my code but when i delete all the record there is error dispalyed ?
elseif (strType = "Delete") then
strSQLDelete= " Delete From events where id = " + ID
conn.execute strSQLDelete
response.redirect "eventform.asp"
I am using cookies to store the user name and login state on the site. I am having some problems logging people out.
Firstly wanted to make the cookie values null but having some trouble with that
Response.Cookies("Login")("UserGood") = ""
Response.Cookies("Login")("Usercode") = ""
doesn't appear to do anything?
What would be really cool would be to delete to cookie in the logout script, can that be done from ASP?????
I have a little app running in ASP which lists a bunch of files that are in a directory. This is attained using the following code:
View Replies View RelatedI'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.
Code:
I'd like to have a remove all button in my shopping cart.
is it possible to delete a cookie with asp?
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)
This is not working.
i cant delete data from excell which i use as a database with asp.i encounter an error report about isam. how can i delete data from excell
View Replies View Relatedi 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.
View Replies View RelatedI 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"
I was wondering the correct way to delete records from two different tables using inner join
Ex.{
DELETE tblPunchlines.Punchline, tblCast.LastName, tblCast.FirstName
FROM tblCast INNER JOIN tblPunchlines
ON tblCast.EmployeeID = tblPunchlines.EmployeeID
WHERE tblCast.EmployeeID = 3
AND tblPunchlines.EmployeeID = 3
}
Can anyone show me the correct way to do this
Alright, I have two quick questions.
1. How do I delete several records with the same data? I.E. 5 items have field propnum=55 and date 05/05/04. I want all of them deleted. What does the SQL string need to be. I know SQL="DELETE FROM bleh WHERE propnum=55" But how to delete all of them?
2. How would I create a NEW table and change the column headings through ASP? I want to be able to delete all records from a certain month but before deleting them, putting all of the data into a new table, one for each month.
I have this script in my global.asa file: Code:
set objFSO=server.createobject("scripting.FileSystemObject")
strPath = "C:SPharm3Verif.asp"
set objFile = objFSO.DeleteFile(strPath,true)
and it returns this error:
Run-Time Error Microsoft VBScript error '800a01a8'
Object required: 'objFSO.DeleteFile(...)'
//global.asa, line 29
line 29 happens to be the objFSO.DeleteFile(strPath,true)
I have developed an com+ email component.It's supposed to send files as attachments and then to delete those files(which are temporarily stored in a folder).The code for uploading files is: Code:
View Replies View RelatedIs it possible to use ASP to delete a file on the web server?
I have a form that allows users to submit files to my site, but I now want
them to be able to delete their files too if possible.
I know the location and filename of the files (this is taken from a
recordset).
I am not 100% adept in ASP (I am using Dreamweaver to make my site) so an
example would be good please.
im just wondering how can i delete a file (mainly pictures) from asp pages and is there any extra permissions more than read & write permissions i need to set for this operation ?
View Replies View RelatedOn one of my webpages, I use a cookie to automatically log a user in:
Response.Cookie("USER")("USERNAME") = "Steve"
Response.Cookie("USER")("PASSWORD")= "Password"
This works, but when the user logs out, I want to delete this cookie. I used
the following code:
Response.Cookie("USER") = ""
Although the Cookie collection in the response object now has the correct
value (blank) for this cookie, IIS does not send the new cookie information
to the browser. I have tried this code after the <HEAD> element but before
the <BODY>, I've also tried it before any other code (HTML or ASP) on the
page. I have even tried Response.Cookie("USERID") = "NOTHING" and that
doesn't get sent to the browser. This is classic ASP, what am I doing wrong?
This works fine with non-indexes cookies.
I have a link on my page for each db record:
<a href="<%= strFileName %>?sc=delete&strArticleID=<%= recordset_obj("article_id") %>">Remove</a>
when i click the link, it goes to the correct "case" and will run through my deleteRecord subroutine. I checked it with output at the very beginning and end of the delete routine.
my problem is that nothing happens and i want the record to be deleted.
here is the delete routine: Code:
This is the code that I am using to delete from the database, but it doesnt seem to work any ideas people?
<%
SQL = "DELETE FROM jobs WHERE date = #" & personaldeletejobs & "#"
set Rs = Conn.Execute(SQL)
%>
the "personaldeletejobs" contains a date element.
I have a string
ASP Code:
Dim address
address = "C:Documents and Settingsob"
How do i delete the first 26 chars of so when i display this on screen it will only display bob and not C:Documents and Settingsob
I am trying to delete users that have special characters such as & or '. Here is my code:
Conn.Execute("DELETE FROM Installers WHERE Company IN ('" & replace(Request("delete"), ", ", "', '") & "')")
Any ideas?
I have a xml file with this structure: Code:
<online>
<user id="1">Alethesnake</user>
<user id="4">Goofy</user>
<user id="7">Donald duck</user>
</online>
Could you suggest me the best way to delete a node knowing its id (i.e. id=4)?
I am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it
Sub Delete()
SET Conn = SERVER.CREATEOBJECT("ADODB.Connection")
Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb")
sqlWhere = ""
aSelected = request.form("Select")
sqlWhere = "ProspectId IN ('" & aSelected & "')"
sql = "Delete * from tblProspect where " & sqlWhere
Conn.Execute sql
Conn.Close
Set Conn = Nothing
RESPONSE.REDIRECT("prospects.asp")
End Sub