too few parameters expect 2 - error

[Flokke]

Hi

Can anyone help me out of this:

id2 = request.form("f_email_n")

sSQL = "DELETE * FROM newsletter WHERE e-mail='" & id2 & "'"
Set oRS = oConn.Execute(sSQL)

Gives me error: to few parameters. Expect 2....

Thank you

Flokke

[Aaron Bertrand [MVP]]

Why do you have a dash in your column name?

Either change it to email without the dash (recommended) or surround the
column name with [square brackets].

The error indicates that the database is trying to find columns e and mail,
subtract them, and compare the result to the string id2.

Also, you don't say DELETE *, just DELETE table WHERE. You're deleting
rows, not columns, so you don't need to specify columns...



"Flokke" <Mathieu.vanneste@flockdesignNOSPAM.be> wrote in message
news:3f67097d$0$1303$ba620e4c@reader2.news.skynet. be...

> Hi
>
> Can anyone help me out of this:
>
> id2 = request.form("f_email_n")
>
> sSQL = "DELETE * FROM newsletter WHERE e-mail='" & id2 & "'"
> Set oRS = oConn.Execute(sSQL)
>
> Gives me error: to few parameters. Expect 2....
>
> Thank you
>
> Flokke
>
>