i am still unable to delete the record. thank u for the earlier help
SQLApp = "DELETE * " SQLApp = SQLApp & "FROM APPLICATION " SQLApp = SQLApp & "WHERE App_Name = '" & App_Name & "' " Set rsDeleteEntry = Connection.Execute(SQLApp) -->line18 Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) Line 1: Incorrect syntax near '*'. /ASFTS/project/delete2.asp, line 18 Using a DELETE sql statement you have already deleted the records, assuming that the WHERE clause is valid. You do not need the .Delete method call there, and will do well to either change your SQL to a select and use the .Delete, or remove the call to .Delete. Also... > Connection.Open "Provider=SQLOLEDB; Database=ASFTS; > Server=mkzsa018.ap.infineon.com; User ID=asfts; > Password=!asfts!" Having provided your login information to a public forum of about 800 people, you might want to change the password on your SQL Server account. If these are the same login/password for your server, I'd highly suggest changing those as well. :) Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== "The only way to avoid being miserable is not to have enough leisure to wonder whether you are happy or not." -- George Bernard Shaw --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups SponsorADVERTISEMENT --------------------------------- 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 the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/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/
