Hi Nice Guy, > SQL SERVER... i am havind probelm deleting the > records from database.
> SQLApp = "DELETE * " > SQLApp = SQLApp & "FROM APPLICATION " > SQLApp = SQLApp & "WHERE App_Name = '" & App_Name & "' " > > Set rsDeleteEntry = Connection.Execute(SQLApp) > rsDeleteEntry.Delete 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 ------------------------ 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/
