I have created a table view of some from an access db. There is a link on the table which calls another page to Delete a record from the db.I would like to know if it is possible to have a button pop up on screen when a link is pressed to confirm that the user wishes to take the action.
Or perhaps a confirm page which details the record and whether the user wants to delete it?
I'm trying to add a Javascript OnClick feature so that when the end-user clicks the delete option, he/she will see a pop-up window that says, "Are you sure you want to delete this document?". I have something like this in other parts of my site, but just copying and pasting the code doesn't work.
And although I've read tutorials and googled for answers, I'm such a newbie, and can't figure out how to plug a Javascript alert into my code. So many quotation marks and apostrophes, parenthesees ... all I'm getting are syntax errors! Code:
I have a webform with 3 text boxes and a submit button Based on the first textbox data I'm filling up the remaining two. If the first box data is not found in the database I want to display a confirm dialog box. I need to know the return value from this confirm dialog as I have to clear the other fields in the form, if the user hits yes the I should retain the values in the other fields. I have tried hours on it by using hidden variables...but still couldnt get it to work.
I'm populating some records by using DataGrid and i have put delete option as item template. now on click of delete i want to popup confirm message box.
I think we have a corrupt IIS metabase on our web cluster. The controller is replicating the problem to the members. What steps can we take to confirm our IIS metabase is intact? I would prefer not to do ADSI calls. Isn't there a command to interate thru the metabase?
Basically I cannot get this baby to work other than to allow the GUEST ACCESS and the ADMIN ACCESS the MEMBER ACCESS I am not even sure if it is even connecting to the databse.
Here is the code for the CONFIRMLOGIN page and also the LIBRARY.INC page. When Logging in as a MEMBER it simply redirects to the mainview page but as a GUEST. Ishn't dat vierd? Code:
I'm trying to make a confirm window for my site, the confirmation ask user a question with yes or no answer then if the response is yes redirects the user to a page and if its no redirects to another page.The problem is that i need the two pages to carry a different querystring; also i need this to act as a link and not as a form.
i have a recordset that displayed all the infos about a record and a delete herf or button i want whenever i wanna delete a record a dialog box to appear with YES/NO/CANCEL button.
yes to confirm delete no to disagree and return to the previous page Cancel to cancel the action and remain in the same page !!
I have the following ASP code which displays a confirmation message when a particular form is successfully submitted. What i need to do is open the message in a blank (_self) browser window. Can this be done using ASP or would it have to be done using Javascript?
I check to see if a certain submission button is asking for removal. If the removal is true, I update a recordset's delete column. This has been tested and it works. However, now I'd like to prompt the user to make sure that he/she wants to remove the record. Here's the code: ....
<A HREF="http://SomeWebSite" OnClick="return confirm('Are you sure?')">Click me</A>
or
<A HREF="http://SomeWebSite" OnClick="return confirm('Are you sure?');return false;">Click me</A>
Everything fine in XP and 2000, but in all WindowsMe Stations, it redirects the link even the users click no, I check all the computers, they have installed IE6 Sp1 and js enabled. What wrong ?
I am trying to delete all the records from one table and insert a few in the same table. When I run the asp it gives me the error message
"Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables."
Before opening the connection to the database, I tried setting the mode to 3 as follows:
Set Conn = Server.CreateObject("ADODB.Connection") conn.Mode= 3
Then I open the connection. But it still gives me the same error.
i would like to be able to delete a record from a database this is the code i have atm but it is not working:
if request.querystring("action") = "delete" then strSQL = "DELETE * FROM DVDDescription WHERE DVDDesc_ID=" & request.querystring("DVDDesc_ID") & ";" objRS.open strSQL,conn,1,2 'objRS.close
I'm getting an error from something that seems too easy to cause trouble. Here's the scenario. User fills out a form. User saves. On submit, an asp script attempts to save the data. it deletes all of existing child records, and then re-inserts new child records.
Heres the chunk of code thats bombing out with a 'Microsoft OLE DB Provider for SQL Server error '80040e31' ':
'delete all children for this Parent record strSQL = "DELETE FROM qcspec_is_tasks WHERE parentID = " & nRecID debugPrint strSQL cn.Execute strSQL
The print statement yeilds the following, before the Execute statement dies:
DELETE FROM qcspec_is_tasks WHERE parentID = 20
If I run the above in query analyzer, it executes instantly.
Incidentally, at this point in time, the table is tiny. Its only 50 rows or so, at the moment.
strsql = "Delete FROM College_List WHERE STDID = (Select ID from Students where StudentID='" & getstdid & "')"
i get this error
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
but i want to delete all the records in the child table that have the ID in the parent table which is students.
During the development, I need to test cookies (ASP and ASP.net).
For the first time I test (First username), it writes the cookies into my computer using the First username, and when I want to test second time, using another user name (Second username), it wont't show up the login page, but instead it automatically let me access the protected page (using the first test username).
Question: I want to delete this cookies! How?
I have searched:
Temporary folder, and can't find it. Document and settings (W2000 Professional), and can't find it as well.
The easiest way to describe my situation is by using the 'email' example. I retrieve my email messages and place a 'delete' checkbox by each message. I select the messages I want to delete and then click the delete button. They magically disappear.
I'm using ASP-->COM-->Stored Proc. I've envisioned creating a recordset to hand to the COM, then for each record fire the stored proc (although I'm unfamiliar with modifying a recordset before a form submit).
I have this code where I can check mark the items I want to delete and hit the submit key and it will delete the records, but the problem is that when I hit submit it opens another window for the same page and I can see that the records are the deleted, but the page where I checked marked the boxes to delete the records is still there and its still showing the records.
I dont want to open another window, I want all this process to happen in the same page and when I click on the delete button it should delete the records and the same page should refresh. Code:
I been working on this code for a long time, code doesn't work and It also doesn't show any error. All I am trying to do is delete record. I click on id number from first page that brings me to this page. 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.
Basically I'm trying to combine an SQL inner join with a delete statement, like:Code:
var cnn = Server.CreateObject('ADODB.Connection'); cnn.Open(Application('cnn')); cnn.Execute('delete * from editors_sections inner join editors on editors_sections.editor_id = editors.editor_id where editor_id='+intEditorId+' and editor.isSectionOne=0 or editor.isSectionTwo=0 or editor.isSectionThree=0'); cnn.Close(); But it gives me the following error:
Incorrect syntax near '*'.
Can this be done, and if so, can anyone see where I'm going wrong (I'm using JScript if that makes any difference?)
can someone help me. I'm writing an onlineshop in asp and for the shopping cart i use an array. If someone wants to delete some articles from the cart, i have to delete them from the array. How i delete only one article (on line) from the array.
I am trying to delete a chosen record out of my Access database using the ID field as the parameter. I can get the script to output the record so I know it has the record, it just won't delete! Code:
I'm simply trying to check if the categoryid is currently being used by any catalogue/product items.
Ok, I've created a mini site content management system and I'm stuck on this function that will ensure data integrity...
I'm trying to check if the categoryid I'm trying to delete has any related 'catalogue' items (products); and if so display a message 'Sorry, there are items currently listed under this category. Move the items before trying to delete'. Basically disallow the delete function if any catalogue items share the categoryid. That's it! Simple... right???
i want to do a response.write so that it will know what is the pk to delete from? can anyone help me on this?after that how can i execute a delete sql statement? like <td ><a href="custorder_edit.asp?ID=<% response.write rs2("ExecNo")%>"><img src="../asp/jpeg/delete.jpg" alt="Delete" border="0" width="20" height="20" onclick="document.edit_custorder.action.value = 'delete_edit_orderdelivery'"></td>