Allan
Tue Nov 14 14:59:02 CST 2006
I should have said Form.asp not Form.htm.
I get the error when I attempt to insert the query in the Insert.asp page.
DRW
Step 1 Select Database
Step 2 Select custom query - when I insert the query:
INSERT INTO Shpmt (FirstName, LastName)
VALUES ('::FirstName::' ,'::LastName::')
and select OK, FrontPage throws the error "The custom query contains erros."
Thanks for your help.
Allan Browning
"Thomas A. Rowe" wrote:
> When using the FP database component, the form page would also require the .asp extensions, plus FP
> will create the required pages, etc.
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
>
http://www.Ecom-Data.com
> ==============================================
>
>
> "Allan" <Allan@discussions.microsoft.com> wrote in message
> news:C1FC801B-7CD9-4C61-A624-89856FD8D0D1@microsoft.com...
> >I am trying to do a simple insert and must be missing something.
> >
> > Page 1 = Form.htm
> > Page 2 = Insert.asp
> >
> > On Form.htm I have two fields:
> >
> > FirstName
> > LastName
> >
> > On Insert.asp I want to use the DRW to create an insert query as:
> >
> > INSERT INTO Shpmt (FirstName, LastName)
> > VALUES ('::FirstName::' ,'::LastName::')
> >
> > However I keep getting the following:
> >
> > Custom Query Contains Errors
> >
> > Help please.
> >
> > This seems so simple.
> >
> >
> >
>
>
>