Having a problem...is it a frontpage issue or not

[Jesse Kangas-Hanes]

I am trying to create a database website for a company that I work for. When
i do the database editor I can connect to the sql server and my submission
form works but if I try to edit data I get this error on the web page...

Database Results Wizard Error
Description: Incorrect syntax near the keyword 'DEFAULT'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for SQL Server

I own and administer the webserver and the sql server

 

[Kathleen Anderson [MVP - FrontPage]]

Can you post your SQL?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Jesse Kangas-Hanes]

message how do I post my sql?

Can you post your SQL?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Kathleen Anderson [MVP - FrontPage]]

Copy it from your 'edit' web page and paste it here into your reply.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Jesse Kangas-Hanes]

message This is what I get from my edit page...

Database Results Wizard Error
Description: Incorrect syntax near the keyword 'DEFAULT'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for SQL Server

 

[Kathleen Anderson [MVP - FrontPage]]

Jesse:
Your SQL can be found in Code View of your 'edit' page; it would start with
UPDATE.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Jesse Kangas-Hanes]

message Ok I don't have an edit page...I am using asp.net so it doesn't use the
seperate pages...where do I find it on the asp.net pages?

 

[Kathleen Anderson [MVP - FrontPage]]

I don't know, but I'm sure someone else here does.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/