473,399 Members | 2,478 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

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 2955
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: sam j | last post by:
Anyone know the best way to get page created in front page 2002 in an ebay listing. I've created a page but a lot of the format and graphics are missing when viewed in ebay Thanks Sam
2
by: Peter | last post by:
(I've tried this Q in the ms forums without response. See how it goes here.) Using A2003 but I guess this is not version-specific... If I want to implement row/record level locking on a split...
7
by: tom | last post by:
Hi, I want a listbox below a hidden calendar control. The problem is that the listbox will shadow the calendar when the calendar is visible. How can I bring the calendar from back to front? ...
1
by: NGM | last post by:
Hello All When implementing FrontController sample MSDN I am facing a lot of problems try implementing the front controller patterm sample provided by microsoft:...
2
by: Alok Jain | last post by:
Hi, We are using Front Controller implementation in our DotNet application. I am trying to hide URL in my application. This is based on Front Controller model. I am able to achieve if I do...
7
by: Chris Davoli | last post by:
I need just opionions. I'm VB.NET programmer and I work with another front end HTML guy who doesn't know .Net and how to use the .Net controls. So far he has been unwilling or unable to learn .Net...
2
by: lmlaster | last post by:
I have 2 webs under my default web running win2003 1. A front-page intranet 2. A asp (not .net) web is fine Both allow anonomous access. My front page web always gets a BLANK...
3
by: John | last post by:
What is the easiest way to make the contact form show on the front page. Meaning on want to keep the front html page and when someone clicks on the contact us link the front page remains the same,...
1
by: John Bailo | last post by:
I'm trying to get Front Page extensions to work with VS.NET 2005. I just installed them on my 2003 server. My login is part of the Administrators group. However, when I bring up...
5
by: The alMIGHTY N | last post by:
Hi all, Let's say I have a simple math formula: sum (x * y / 1000) / (sum z / 1000) I have to do this across 50 items, each with an x, y and z value, when the page first loads AND when a...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.