[nhusers] Re: Possible SQL Server bug

2009-03-03 Thread Fabio Maulo
Try to fix it hahahaha.If your boss want use SQL he should say something to you because you are using "SELECT *" instead a SELECT with all field explicitly. NH give you the facility to do the work for you writing {alias.*}... As last... your boss want you write SQL ? well do it, and don't use NH f

[nhusers] Re: Possible SQL Server bug

2009-03-03 Thread Bill Barry
Pointy Haired Boss Robin Nadeau wrote: > I can't quite remember what PHB means, but it's from Dilbert. > > On Tue, Mar 3, 2009 at 3:53 PM, Tuna Toksoz > wrote: > > doh! what's phb anyway? > --~--~-~--~~~---~--~~ You received this mes

[nhusers] Re: Possible SQL Server bug

2009-03-03 Thread Robin Nadeau
I can't quite remember what PHB means, but it's from Dilbert. On Tue, Mar 3, 2009 at 3:53 PM, Tuna Toksoz wrote: > doh! what's phb anyway? > > > Tuna Toksöz > http://tunatoksoz.com > http://turkiyealt.net > http://twitter.com/tehlike > > Typos included to enhance the readers attention! > > > > O

[nhusers] Re: Possible SQL Server bug

2009-03-03 Thread Tuna Toksoz
doh! what's phb anyway? Tuna Toksöz http://tunatoksoz.com http://turkiyealt.net http://twitter.com/tehlike Typos included to enhance the readers attention! On Tue, Mar 3, 2009 at 10:50 PM, Robin Nadeau wrote: > I want to use HQL or criteria API, but PHBs insist we stick with native > SQL. H

[nhusers] Re: Possible SQL Server bug

2009-03-03 Thread Robin Nadeau
I want to use HQL or criteria API, but PHBs insist we stick with native SQL. How difficult would this be to fix in the provider for sql server? Thanks for your response. On Tue, Mar 3, 2009 at 3:36 PM, Fabio Maulo wrote: > I mean... If you want a pure SQL don't use SetMaxResults or SetFirstResul

[nhusers] Re: Possible SQL Server bug

2009-03-03 Thread Fabio Maulo
I mean... If you want a pure SQL don't use SetMaxResults or SetFirstResult, write the full SQL by your self. If you want NH doing something, write the SQL in a way NH can understand how work with it. 2009/3/3 Fabio Maulo > sure it fail.You should use H-SQL if you want that NH do something with >

[nhusers] Re: Possible SQL Server bug

2009-03-03 Thread Fabio Maulo
sure it fail.You should use H-SQL if you want that NH do something with your SQL or you should use HQL or Criteria. SELECT {u.*} FROM USER {u} ORDER BY id desc") For H-SQL : http://nhforge.org/doc/nh/en/index.html#manipulatingdata-nativesql 2009/3/3 Robin Nadeau > In NHibernate 2.0 using SQL S