Delete all records with field=d

  • Thread starter Thread starter Ted Ljong
  • Start date Start date
T

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
 
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.
==============================================
 
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
 
Forget my answer it was a reading problem, I did not modifie the querie it
is used as you said.
Ted Ljong
 
The * is uneccesary.

Bob Lehmann

Thomas A. Rowe said:
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.
==============================================
Click to expand...
 
Back
Top