关于sql的delete问题

[yswwei]

请问我下面的代码哪写错了，为什么在执行时告诉我"cn.Execute strDel"那不行？谢谢
<%
set cn=Server.CreateObject ("ADODB.Connection")
cn.Open "DSN=login;UID=sa;PWD="
set rs=Server.CreateObject ("ADODB.Recordset")
strDel="DELETE * FROM login WHERE name='aa'"
cn.Execute strDel
%>

[nononono]

DELETE FROM login WHERE name='aa'

[minmin127]

delete的完整语法是这样的:
delete [from]{tablename} [where clause]
例如:delete mytable where first_column="aa"