Hi,

I get an exception while calling a named query :


  <sql-query name="sp_NH_GetCuttings">
    <return class="DataTransfer.Cutting, DataTransfer" >
      <return-property name="Cuttingid" column="CuttingID" />
      <return-property name="Headline" column="Headline" />
  </return>
   exec sp_NH_GetCuttings
  </sql-query>


    public IList<Cutting> getCuttings()
    {
      return _session.GetNamedQuery("sp_NH_GetCuttings").List<Cutting>
();
    }

The exception inner message is not helpful :

could not execute query
[ exec sp_NH_GetCuttings ]
[SQL: exec sp_NH_GetCuttings]

and if I go deeper :

column2_0_0_


The second one is even more useless...

Here's the stored procedure :

CREATE PROCEDURE sp_NH_GetCuttings

AS
BEGIN
        SELECT TOP 3 CuttingID, Headline FROM cutting
END

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to