SQL - Front Page

[Scrappy]

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

[John Bell]

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