Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
<% 'Dimension variables Dim adoCon 'Holds the Database Connection Object Dim strSQL 'Holds the SQL query for the database Dim lngRecordNo 'Holds the record number to be deleted 'Read in the record number to be deleted lngRecordNo = CLng(Request.QueryString("ID")) 'Create an ADO connection odject Set adoCon = Server.CreateObject("ADODB.Connection") 'Set an active connection to the Connection object using a DSN-less connection adoCon.Open "Provider=sqloledb;SERVER=DASTVMSQLCX01;DATABASE=AcSec;UID=AcSecUser;PWD=acsec102611;" 'Initialise the strSQL variable with an SQL statement to query the database strSQL = "DELETE * FROM Results WHERE ID=" & lngRecordNo adoCon.Execute strSQL 'Reset server objects adoCon.Close Set adoCon = Nothing 'Return to the delete select page incase another record needs deleting Response.Redirect "All.asp" Response.End %>
|Help with stored procedure||30||44|
|Password Hashing vs Encryption for long term viability||3||71|
|How to speed up an ASP/MS SQL web application||6||59|
|Is there any Artificial Intelligence (AI) Software I can use with my database search engines?||1||25|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!