Problems with a website...is it sql -- sql server new users

sql server new users : Problems with a website...is it sql

Jesse Kangas-Hanes
7/30/2006 4:57:10 PM

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

Arnie Rowland
7/30/2006 7:59:01 PM

It is very difficult to attempt to assist you without seeing the UPDATE
query that you used.

It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 )

The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

[quoted text, click to view]

Hari Prasad
7/31/2006 11:08:33 AM

Can you please paste the SQL or stored procedure used?

Thanks
Hari
SQL Server MVP

[quoted text, click to view]

Jesse Kangas-Hanes
7/31/2006 2:21:10 PM

[quoted text, click to view]
I am running the database off a website...

[quoted text, click to view]

Mike C#
8/1/2006 1:55:37 PM

He's asking for your database structure. Are you using third-party controls
(like ComponentArt or something) for your website?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn