Hibernate Community • View topic - CreateSqlQuery(..) and AddScalar

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

CreateSqlQuery(..) and AddScalar

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ikajel

Post subject: CreateSqlQuery(..) and AddScalar

Posted: Thu Sep 27, 2007 5:32 am

Newbie

Joined: Wed Mar 14, 2007 8:40 am
Posts: 2

Hey all,

I'm trying to create a native sql query to get a summary of all hits for a company in a specified month. The table has the columns (ID, Company, Date).

I'm trying the following:

Code:

IList list = _session.CreateSQLQuery(
                    String.Format(
                            "SELECT Company, count(*) " +
                            "FROM History" +
                            "WHERE     (DATENAME(m, [Date]) = '{0}') AND (DATENAME(yy, [Date]) = '{1}') " +
                            "GROUP BY Company "
                           , month, year))
                    .AddScalar("Company", NHibernateUtil.String)
                    .AddScalar("Hits", NHibernateUtil.Int32)
                    .List();

I'm getting the exception "IndexOutOfRangeException: Hits". That means that somehow the scalar for hits cannot be resolved. The query works fine when I leave the second AddScalar("Hits", ..) out.

Does anyone know how I can get hold of the count(*)? Any help is greatly appreciated!

Top

ikajel

Post subject:

Posted: Fri Sep 28, 2007 5:27 am