hello guys, i'm a student doing practical training in this company. i am doing this
project with ASP and SQL SERVER. i am havind probelm deleting the records from
database. below is my code:
<%
Dim Connection, SQLApp
Dim rsDeleteEntry
App_Name = Request.QueryString("App_Name")
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "Provider=SQLOLEDB; Database=ASFTS; Server=mkzsa018.ap.infineon.com;
User ID=asfts; Password=!asfts!"
Set rsDeleteEntry = Server.CreateObject("ADODB.Recordset")
SQLApp = "DELETE * "
SQLApp = SQLApp & "FROM APPLICATION "
SQLApp = SQLApp & "WHERE App_Name = '" & App_Name & "' "
Set rsDeleteEntry = Connection.Execute(SQLApp)
rsDeleteEntry.Delete
rsDeleteEntry.Close
Set rsDeleteEntry = Nothing
Connection.Close
Set Connection = Nothing
Response.Write "Successfully Deleted"
%>
thank you.
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
