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)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Ted Ljong" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>

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


"Thomas A. Rowe" <(E-Mail Removed)> skrev i meddelandet
news:u$(E-Mail Removed)...
> Try:
>
> SQL = "Delete * from tablename Where status = 'd' "
>
> --
>
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, Forums, WebCircle,
> MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Ted Ljong" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> >
>
>

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


"Ted Ljong" <(E-Mail Removed)> skrev i meddelandet
news:e6bh7G%(E-Mail Removed)...
> 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
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> skrev i meddelandet
> news:u$(E-Mail Removed)...
> > Try:
> >
> > SQL = "Delete * from tablename Where status = 'd' "
> >
> > --
> >
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, Forums, WebCircle,
> > MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Ted Ljong" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> > > 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
> > >
> > >
> >
> >
>
>

The * is uneccesary.

Bob Lehmann

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:u$(E-Mail Removed)...
> Try:
>
> SQL = "Delete * from tablename Where status = 'd' "
>
> --
>
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, Forums, WebCircle,
> MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Ted Ljong" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> >
>
>