WHY CAN'T THE CLOWN -HOLES WHO WROTE ASP.NET PROVIDE AN ERROR LINE
NUMBER???
HONEST TO SH@THOLE PETE
Server Error in '/New Folder (7)' Application.
--------------------------------------------------------------------------------
The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: The text, ntext, and
image data types cannot be compared or sorted, except when using IS NULL or
LIKE operator.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): The text, ntext, and image data types cannot be
compared or sorted, except when using IS NULL or LIKE operator.]
System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection ) +177
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +68
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +199
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet
bulkCopyHandler , TdsParserStateO bject stateObj) +2300
System.Data.Sql Client.SqlDataR eader.ConsumeMe taData() +31
System.Data.Sql Client.SqlDataR eader.get_MetaD ata() +62
System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader ds,
RunBehavior runBehavior, String resetOptionsStr ing) +294
System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
+1021
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result) +314
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
+20
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior,
String method) +107
System.Data.Sql Client.SqlComma nd.ExecuteDbDat aReader(Command Behavior
behavior) +10
System.Data.Com mon.DbCommand.S ystem.Data.IDbC ommand.ExecuteR eader(CommandBe havior
behavior) +7
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +140
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
+83
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments
arguments) +1657
System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s arguments,
DataSourceViewS electCallback callback) +13
System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect() +140
System.Web.UI.W ebControls.Base DataBoundContro l.DataBind() +68
System.Web.UI.W ebControls.Grid View.DataBind() +4
System.Web.UI.W ebControls.Base DataBoundContro l.EnsureDataBou nd() +61
System.Web.UI.W ebControls.Comp ositeDataBoundC ontrol.CreateCh ildControls()
+67
System.Web.UI.C ontrol.EnsureCh ildControls() +97
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +50
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +171
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +171
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +5729
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.507 27.42; ASP.NET
Version:2.0.507 27.210
5  1951 
Do you know which page that caused this error?
From your stack trace it seems your DB has thrown a exception, Do you
use declarative data binding? If so there is no specific line of code to
reference. Have a look at the SQL statement you are using to populate
the Grid view, (hopefully you only have one Grid view on the page) test
this command using the SQL Server mgt Studio (or Query Analyzer) if ok
then run the SQL Server Profiler to see what statement is being passed
by the code, then run that, if still ok post back with more details of
your code.
Mr. SweatyFinger wrote:
WHY CAN'T THE CLOWN -HOLES WHO WROTE ASP.NET PROVIDE AN ERROR LINE
NUMBER???
HONEST TO SH@THOLE PETE
Server Error in '/New Folder (7)' Application.
--------------------------------------------------------------------------------
The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: The text, ntext, and
image data types cannot be compared or sorted, except when using IS NULL or
LIKE operator.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): The text, ntext, and image data types cannot be
compared or sorted, except when using IS NULL or LIKE operator.]
System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection ) +177
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +68
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +199
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet
bulkCopyHandler , TdsParserStateO bject stateObj) +2300
System.Data.Sql Client.SqlDataR eader.ConsumeMe taData() +31
System.Data.Sql Client.SqlDataR eader.get_MetaD ata() +62
System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader ds,
RunBehavior runBehavior, String resetOptionsStr ing) +294
System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
+1021
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result) +314
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
+20
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior,
String method) +107
System.Data.Sql Client.SqlComma nd.ExecuteDbDat aReader(Command Behavior
behavior) +10
System.Data.Com mon.DbCommand.S ystem.Data.IDbC ommand.ExecuteR eader(CommandBe havior
behavior) +7
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +140
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
+83
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments
arguments) +1657
System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s arguments,
DataSourceViewS electCallback callback) +13
System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect() +140
System.Web.UI.W ebControls.Base DataBoundContro l.DataBind() +68
System.Web.UI.W ebControls.Grid View.DataBind() +4
System.Web.UI.W ebControls.Base DataBoundContro l.EnsureDataBou nd() +61
System.Web.UI.W ebControls.Comp ositeDataBoundC ontrol.CreateCh ildControls()
+67
System.Web.UI.C ontrol.EnsureCh ildControls() +97
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +50
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +171
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +171
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +5729
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.507 27.42; ASP.NET
Version:2.0.507 27.210
"Mr. SweatyFinger" <sw@sw1finger.c omwrote in message
news:ec******** ******@TK2MSFTN GP02.phx.gbl...
WHY CAN'T THE CLOWN -HOLES WHO WROTE ASP.NET PROVIDE AN ERROR LINE
NUMBER??? HONEST TO SH@THOLE PETE
Server Error in '/New Folder (7)' Application.
Description: An unhandled exception occurred
Why don't you do yourself (any everyone else) a huge favour and get a
beginner's guide to ASP.NET and read it from cover to cover?
Then, just maybe, you'd learn how to make your code not quite so utterly
abysmal that it doesn't even have any exception handling.
Then you would know *precisely* which line of your abysmal code caused this
obvious error...
This course of action has already been suggested to you at least once...
if you are not going to properly handle errors in your code, then deploy
the debug version which will have line number code (which is removed on
the release version).
-- bruce (sqlwork.com)
Mr. SweatyFinger wrote:
WHY CAN'T THE CLOWN -HOLES WHO WROTE ASP.NET PROVIDE AN ERROR LINE
NUMBER???
HONEST TO SH@THOLE PETE
Server Error in '/New Folder (7)' Application.
--------------------------------------------------------------------------------
The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: The text, ntext, and
image data types cannot be compared or sorted, except when using IS NULL or
LIKE operator.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): The text, ntext, and image data types cannot be
compared or sorted, except when using IS NULL or LIKE operator.]
System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection ) +177
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +68
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +199
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet
bulkCopyHandler , TdsParserStateO bject stateObj) +2300
System.Data.Sql Client.SqlDataR eader.ConsumeMe taData() +31
System.Data.Sql Client.SqlDataR eader.get_MetaD ata() +62
System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader ds,
RunBehavior runBehavior, String resetOptionsStr ing) +294
System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
+1021
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result) +314
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
+20
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior,
String method) +107
System.Data.Sql Client.SqlComma nd.ExecuteDbDat aReader(Command Behavior
behavior) +10
System.Data.Com mon.DbCommand.S ystem.Data.IDbC ommand.ExecuteR eader(CommandBe havior
behavior) +7
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +140
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
+83
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments
arguments) +1657
System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s arguments,
DataSourceViewS electCallback callback) +13
System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect() +140
System.Web.UI.W ebControls.Base DataBoundContro l.DataBind() +68
System.Web.UI.W ebControls.Grid View.DataBind() +4
System.Web.UI.W ebControls.Base DataBoundContro l.EnsureDataBou nd() +61
System.Web.UI.W ebControls.Comp ositeDataBoundC ontrol.CreateCh ildControls()
+67
System.Web.UI.C ontrol.EnsureCh ildControls() +97
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +50
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +171
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +171
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +5729
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.507 27.42; ASP.NET
Version:2.0.507 27.210
this is the debug version, and so i use the term clown-holes.
>;-)
"Mark Rae" <ma**@markNOSPA Mrae.comwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..
"Mr. SweatyFinger" <sw@sw1finger.c omwrote in message
news:ec******** ******@TK2MSFTN GP02.phx.gbl...
>WHY CAN'T THE CLOWN -HOLES WHO WROTE ASP.NET PROVIDE AN ERROR LINE
NUMBER??? HONEST TO SH@THOLE PETE
Server Error in '/New Folder (7)' Application.
Description: An unhandled exception occurred
Why don't you do yourself (any everyone else) a huge favour and get a
beginner's guide to ASP.NET and read it from cover to cover?
Then, just maybe, you'd learn how to make your code not quite so utterly
abysmal that it doesn't even have any exception handling.
Then you would know *precisely* which line of your abysmal code caused
this
obvious error...
This course of action has already been suggested to you at least once...
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Asker |
last post by:
I heard PHP hard coded useragent in several places. It sucks, unlike Perl
which you can enter anything. It is even worse than Wget.
I wonder if PHP5 allows User Agent changes now, because it seems to add many
header related functions. But I still did not see one yet.
|
by: jerrygarciuh |
last post by:
Hello,
If you have the whole server path for a file is there a canonical way to get
the path from document root for that file so that you can present the file
ina browser or for download? Check $_SERVER and parse the
path?
My thought is that given OS diversity and individual server differences (eg
www vs public_html vs htdocs) that there may be no one-size-fits-all
solution but I thought I would throw this out there any way.
|
by: Colin Steadman |
last post by:
My ASP page allows user to enter comments into a form. To avoid
errors I'm having to strip out double quotes before saving to the
database. Is there anyway to encode these so that I can store them
instead, in the way was an URLEncode works?
TIA,
Col
|
by: jsnX |
last post by:
say i have a function object silly that takes a const ref to clowns
class silly : public std::unary_function<const clown&, bool>
{
...
}
and then i decide to feed it a bunch of pointers to clowns:
for_each(clown_pointers.begin(), clown_pointers.end(), silly());
|
by: Jerry Negrelli |
last post by:
I'm trying to define a custom class indexer to take the
place of an underlying Hashtable member so that values
can be referred to as Class1 instead of
Class1.someVar.
The following code does not work & I believe I understand
why (a value is returned by my indexer, not a reference).
I have a feeling I'm just using this indexer horribly
wrong, but any insight would be much appreciated!
| | |
by: Bob Bedford |
last post by:
Hello there,
I need help: I've a string that is used to write down a phone number that
comes from a form and would like to keep it as clean as possible. For
avoiding people to create twice an account using a different syntax.
For this the only char I'd like to allow are number 0-9, '/','.' and spaces.
I'd like to replace everything other by a "space".
|
by: ryanhokanson |
last post by:
I was just trying to get a list of all my reports along with their
widths.
I can't use the "Reports" collection because it only works on open
reports. So I tried looking into the "AllReports" collection and it
doesn't seem any more useful... only allows you to find out the name of
each report.
|
by: Jeremy |
last post by:
Does anyone have a clever algorithm for generating an outline of the
current document from (client-side) javascript using DOM methods?
For example, let's say I predictably have a document structured
hierarchically with <h1>...<h6tags. I want to generate an outline of
the document wherein I have nested lists of the contents of the headers.
Take for example the following snippet of a fictional legal document:
------------
<h1>Main...
|
by: Sean McIlroy |
last post by:
hi all
is there a way to do this ...
class clown:
def __init__(self):
self.x = 0
self.y = ALIAS(self.x) ## FEASIBLE ?
.... so that you get results like this ...
|
by: BoogieWithStu22 |
last post by:
I am running into a problem with a web page I have created when
viewing it in IE6 on some machines. The page has a database lookup.
The user enters an account name or number and clicks a lookup button.
This hits an AS400 database looks for matches and returns a dataset
that is used to populate a datagrid. The user then selects one of the
entries from the list, this entry is used to populate a couple of
textboxes on the page and a couple...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
