Hey Nice Guy
try removing the *..
-----Original Message-----
From: nice guy [mailto:[EMAIL PROTECTED]
Sent: Wed 14/07/2004 12:14 PM
To: [EMAIL PROTECTED]
Cc:
Subject: [ASP] Still unable to delete
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
[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/
