Hapus Record dengan SQL Statement menggunakan ASP

Source Code Pemrograman menghapus Record menggunakan SQL Statement

Delete Record with SQL statement
dbdeletemany.asp



<%
On Error Resume Next
myDSN = “DSN=Student;uid=student;pwd=magic”
mySQL = “DELETE FROM authors WHERE au_id=200″
Set Conn = Server.CreateObject(“ADODB.Connection”)
conn.open myDSN
Conn.Execute mySQL,howmany
Response.Write “The statement ” & mySQL & “ deleted ” & howmany & ” records

Call ErrorVBScriptReport(“Deleting…”)
Call ErrorADOReport(mySQL,conn)
Conn.Close
Set conn=Nothing
%>
Lebih Lengkapnya Dibawah ini :
Visit : http://www.text-upload.com/read,t11185
Share this article :

Posting Komentar

 
Contact : Creating Website | Email : agendoza404@gmail.com
Copyright © 2016. Erwin Eshan Firas - All Rights Reserved
Template Created by Creating Website Published by Travis
Powered by Erwin Eshan Firas