为什么我这句删除语句总是出错

[paradjanov]

sql = "delete * from orders where comp='未完成' and DateDiff(d,ordertime,'"&now()&"')>10 order by ordertime desc"
conn.close
set conn=nothing

ordertime是表名
错误提示：

Microsoft JET Database Engine 错误 '80040e14'

SQL 语句的结束位置缺少分号 (;)。

order/del-comp-is-no.asp，行11

[scoutlin]

DateDiff(""d"",ordertime,'"&now()&"')>10

[paradjanov]

还是不行啊

[eyun]

删除为什么要排序啊

[wzhiyuan]

sql = "delete * from orders where comp='未完成' and DateDiff(d,ordertime,'"&now()&"')>10 order by ordertime desc"
去掉*试试。

[wzhiyuan]

删除为什么要排序啊

[paradjanov]

删除order by就一切正常了

[Iamnomad]

sql = "delete from orders where comp='未完成' and DateDiff('d',ordertime,'"&now()&"')>10 "