Delete all records with field=d

[Ted Ljong]

Hi
From a FPpage I will delete every records with field status=d. It´s no
problem to delete 1 record but when I try to delete several records I get
errormessage "To few parameters. Expected 1."
Ted Ljong

 

[Thomas A. Rowe]

Try:

SQL = "Delete * from tablename Where status = 'd' "

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Ted Ljong]

Thanks Thomas
It´s an access db so I modified the querie to
delete * FROM epost_send WHERE status = 'd'
It works fine now, thanks
Ted Ljong

 

[Ted Ljong]

Forget my answer it was a reading problem, I did not modifie the querie it
is used as you said.
Ted Ljong

 

[Bob Lehmann]

The * is uneccesary.

Bob Lehmann

Try:

SQL = "Delete * from tablename Where status = 'd' "

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================