what's wrone in there delete statment ???

[xray]

peace be with you

dear friend's :
i write this code to delete in database :

dim del_str,del_w_id

del_str = "delete * from won_tab where w_id = '4'"

db.execute(del_str)

where the :
w_id = is a autonumber
won_tab = the name of table

Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/islam/admin_w_ok.asp, line 52

thanks

[GaryMazzone]

Don't place qoutes around the number 4. It is a number not a string.

[sevenhalo]

Also, you don't need an asterisk, all columns are assumed.