You're digging your hole deeper... :) And you're forgetting that Frans as also helped him too, but without the arrogance and demeaning attitude.
--- Patrick Steele ([EMAIL PROTECTED]) Lead Software Architect Image Process Design > -----Original Message----- > From: Thomas Tomiczek [mailto:[EMAIL PROTECTED] > Sent: Monday, July 26, 2004 10:52 AM > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and > SQL Server > > > So what? > > The original poster actually misrepresented his case totally. > > Not my fault, really, you know. > > HE had the guts to stand up and excuse himself for this. > > Everyone else acctually, despite this, seems to think that I do > something wrong? > > Do you guys eat arrogance for breakfast or what? > > In the OP's answer to my post he actually made an explanation of his > problem that was totally different than his original post. > > So much for his "telling a bit from a byte". > > Thomas > > > -----Original Message----- > > From: Unmoderated discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of > Kamen Lilov > > Sent: Montag, 26. Juli 2004 16:45 > > To: [EMAIL PROTECTED] > > Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and > > SQL Server > > > > Thomas, in this particular case Clemens is completely right. > > You are being obnoxious. Got a need to vent your anger at > > someone? Try some of the jerks on less advanced forums who > > ask for help (or, more like, handholding) without bothering > > to even read the documentation first. This is a serious > > forum, and the original poster explained the issue well > > enough so that we don't need to automatically assume he can't > > tell a bit from a byte. > > > > -----Original Message----- > > From: Unmoderated discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Thomas Tomiczek > > Sent: Monday, July 26, 2004 5:05 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and > > SQL Server > > > > > > And in return I will refrain from telling you loudly what I > > think of people making posts such as yours. > > > > Very nicely, clemens. One of the most arrogant posts I read > > in the last weeks here. > > > > I was not insulting at all. All I did point oout is that > > someone had not done his homework (but came to an advanced > > forum) based on what turned out to be a total bad decsription > > of the error. > > > > What terms you associate with this I do not know. I consider > > incompetence not acceptable. Maybe in your ocmpany it IS > > acceptable. Your decision. That simple. > > > > Thomas > > > > > -----Original Message----- > > > From: Unmoderated discussion of advanced .NET topics. > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Clemens F. > > > Vasters > > > Sent: Montag, 26. Juli 2004 16:00 > > > To: [EMAIL PROTECTED] > > > Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and SQL > > > Server > > > > > > It's a puzzle to me what sort of mental state would > trigger anyone > > > being so arrogant (and insulting) just because someone else > > has a bit > > > of a misconception about how things work and is therefore > > asking for > > > help. > > > > > > I can think of a few terms I usually associate with folks > > having such > > > an attitude, but I think I will rather skip the enumeration > > given that > > > this is a public forum. > > > > > > -cv > > > > > > > > > -----Original Message----- > > > From: Unmoderated discussion of advanced .NET topics. > > > [mailto:[EMAIL PROTECTED] On Behalf Of Thomas > > > Tomiczek > > > Sent: Monday, July 26, 2004 3:30 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and SQL > > > Server > > > > > > Ok, let's go. > > > > > > > -----Original Message----- > > > > From: Unmoderated discussion of advanced .NET topics. > > > > [mailto:[EMAIL PROTECTED] On Behalf Of Jon > > > > Stonecash > > > > Sent: Montag, 26. Juli 2004 14:13 > > > > To: [EMAIL PROTECTED] > > > > Subject: [ADVANCED-DOTNET] Common Sort Order for .NET and > > SQL Server > > > > > > > > I am having a problem getting SQL Server and .NET to agree > > > on the sort > > > > order for some data. > > > > > > Really? > > > > > > > My sort column in SQL Server is character data ([varchar] > > > > (255) COLLATE SQL_Latin1_General_CP1_CI_AS). As I > > understand this, > > > > the data sorts in dictionary order. Thus, a value of > > "F-SA" sorts > > > > between "FR" and "FT". > > > > > > Tip: you seem to haves kipped reading the beginner section > > of your SQL > > > documentation. Your understanding is totally unsubstantiated. > > > > > > > The problem is that .NET seems to think that the data is not > > > > in order. I > > > > > > And guess what, .NET is right with this. > > > > > > Beginner SQL: unless you explicitly sort the data, it is > > unsorted in > > > the returned data set. > > > > > > > have tried all of the CultureInfo settings that I can > think of to > > > > convince .NET to see this as ordered. I have a need to > > > > > > Why not fix your bugs regarding any basick nowledge how > SQL works, > > > instead of trying to get .NET agreeing? > > > > > > > process these rows and compare them to another sorted > > > stream of data > > > > and the comparison is going nuts when it gets to these "special > > > > cases". > > > > > > Then why do you not sort the data? > > > > > > > Is there a way to get SQL Server and .NET on the same > (code) page > > > > without sorting the data internally after reading it from > > > SQL Server? > > > > > > No. SQL 101. Unless the SQL statement specifies a sort > order, sort > > > order is random. > > > > > > That said - why do you not just specify a sort order in > your query? > > > This is pretty simple, and you do not have to resort on > the client > > > then. It just is not automatic. > > > > > > Note: SQL is SET ORIENTED. Sets do not have an intrinsic > sort order. > > > > > > Thomas Tomiczek > > > THONA Software & Consulting Ltd. > > > (Microsoft MVP C#/.NET) > > > (CTO PowerNodes Ltd.) > > > > > > > > > > > Jon Stonecash > > > > > > > > =================================== > > > > This list is hosted by DevelopMentor(r) > > > http://www.develop.com Some > > > > .NET courses you may be interested in: > > > > > > > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > > > > http://www.develop.com/courses/gaspdotnetls > > > > > > > > View archives and manage your subscription(s) at > > > > http://discuss.develop.com > > > > > > > > > > =================================== > > > This list is hosted by DevelopMentor(r) > http://www.develop.com Some > > > .NET courses you may be interested in: > > > > > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > > > http://www.develop.com/courses/gaspdotnetls > > > > > > View archives and manage your subscription(s) at > > > http://discuss.develop.com > > > > > > =================================== > > > This list is hosted by DevelopMentor(r) > > http://www.develop.com Some > > > .NET courses you may be interested in: > > > > > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > > > http://www.develop.com/courses/gaspdotnetls > > > > > > View archives and manage your subscription(s) at > > > http://discuss.develop.com > > > > > > > =================================== > > This list is hosted by DevelopMentorR http://www.develop.com > > Some .NET courses you may be interested in: > > > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > > http://www.develop.com/courses/gaspdotnetls > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > =================================== > > This list is hosted by DevelopMentor(r) http://www.develop.com > > Some .NET courses you may be interested in: > > > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > > http://www.develop.com/courses/gaspdotnetls > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > Some .NET courses you may be interested in: > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > http://www.develop.com/courses/gaspdotnetls > > View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentorŪ http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com
