469,090 Members | 1,086 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

SQL - Front Page

I have created a Database Editor with FrontPage using the Wizzard. I have a
database in SQL 2000 called Equipment with one table named Equipment.

When I bring up the editor, it displays a list of all records with a link to
the edit page. When I click on the link for the first record on the page,
The edit page come up correctly. I can edit the page and then submit it.
When I click on the link for the second record ( and all the rest of the
records) in the list I get the following message:

Database Results Error
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting the nvarchar value 'BF176' to a column of data type int.
Number: -2147217913 (0x80040E07)
Source: Microsoft OLE DB Provider for ODBC Drivers

When I click on the link for record BF176, which is about 20 records down
the page, I get the following message:
Database Results Error
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column
name 'BF176'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

I have gone in the SQL database and messed arounf with changing the column
type from nvchar to nchar and changing the length, but can not figure this
out. I cannot tell whether this is a Frontpage problem or a SQL problem.
Any help would be appreciated! Thanks!

Darren
MCP
Jul 20 '05 #1
1 2871
Hi

I am not a frontpage expert, but I guess you have used a wizard to produce
this UI?

It seems that it thinks that one of the columns should be an integer and it
contains a value that is not convertable to integer, or that the columns are
somehow being miss-aligned so that a column is being skipped somehow and
therefore a character column is being taken as an integer.

You may want to use profiler to see what statements are being run, when this
error occurs. You can them take the statement from the profile and run it in
query analyser ti see the output.

HTH

John
"Scrappy" <ce*****@lan-specialist.com> wrote in message
news:93*******************@twister.nyroc.rr.com...
I have created a Database Editor with FrontPage using the Wizzard. I have a database in SQL 2000 called Equipment with one table named Equipment.

When I bring up the editor, it displays a list of all records with a link to the edit page. When I click on the link for the first record on the page,
The edit page come up correctly. I can edit the page and then submit it.
When I click on the link for the second record ( and all the rest of the
records) in the list I get the following message:

Database Results Error
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting the nvarchar value 'BF176' to a column of data type int.
Number: -2147217913 (0x80040E07)
Source: Microsoft OLE DB Provider for ODBC Drivers

When I click on the link for record BF176, which is about 20 records down
the page, I get the following message:
Database Results Error
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column
name 'BF176'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

I have gone in the SQL database and messed arounf with changing the column
type from nvchar to nchar and changing the length, but can not figure this
out. I cannot tell whether this is a Frontpage problem or a SQL problem.
Any help would be appreciated! Thanks!

Darren
MCP

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by sam j | last post: by
2 posts views Thread by Alok Jain | last post: by
7 posts views Thread by Chris Davoli | last post: by
3 posts views Thread by John | last post: by
1 post views Thread by John Bailo | last post: by
5 posts views Thread by The alMIGHTY N | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.