ASP insert into database.

[Allan]

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.

 

[Thomas A. Rowe]

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]

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