Syntax for Sql inserts using FrontPage 2003

[rmuscarello]

Can someone tell me what the syntax is now for doing insterts into a
database? What has worked for me in the past was

Insert keycutter
(product_id)
VALUES
(':roduct_id::')

Now for some reason it nolonger works. When I click on the Verify Query
button it says "The custom query contains errors.".

On the server I'm using Windows 2000 with FrontPage 2002 Server Extensions.
I'm using FrontPage 2003 SP2 to edit the webpages. The value will be
something that I get from another webpage.

 

[Stefan B Rusynko]

See http://home.att.net/~codelibrary/FrontPage/drw.htm

INSERT INTO Tablename (fieldname1, fieldname2) VALUES ('::field1::', '::field2::')

PS
You need to set your delimiters depending in your datatype
If product_id is not text don't delimit it with '




| Can someone tell me what the syntax is now for doing insterts into a
| database? What has worked for me in the past was
|
| Insert keycutter
| (product_id)
| VALUES
| (':roduct_id::')
|
| Now for some reason it nolonger works. When I click on the Verify Query
| button it says "The custom query contains errors.".
|
| On the server I'm using Windows 2000 with FrontPage 2002 Server Extensions.
| I'm using FrontPage 2003 SP2 to edit the webpages. The value will be
| something that I get from another webpage.