.SetProjection(
Projections.SqlProjection("sum(datalength(Data)) dl",
new[] {"dl"},
new[] {NHibernateUtil.Int64}))
Diego
On Wed, Jun 23, 2010 at 14:54, Kminoru <[email protected]> wrote:
> i did
> this:
> .SetProjection(Projections.Alias(Projections.SqlProjection("sum(cast(datalength(imagem.Imagem)
> as bigInt))", New String() {"imagem.Imagem"}, types), "total")) and
> got this exception mensage:"O identificador de várias partes
> "imagem.Imagem" não pôde ser associado."
>
> Translated by google: "The handle multi-part "imagem.Imagem" could not
> be associated"
> What´s wrong?
>
> On 23 jun, 11:21, Diego Mijelshon <[email protected]> wrote:
> > You can use Projections.SqlProjection or .SqlGroupProjection to access
> > arbitrary functions.
> >
> > Diego
> >
> >
> >
> > On Wed, Jun 23, 2010 at 09:37, Kminoru <[email protected]> wrote:
> > > Hello, in my application, i need select de sum of length of some
> > > objects. These objects are varbinary type. I found that SQL SERVER has
> > > the function datalength that return it. How can i do this using
> > > criteria?
> > > Thanks for all.
> >
> > > --
> > > 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]<nhusers%[email protected]>
> <nhusers%[email protected]<nhusers%[email protected]>
> >
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/nhusers?hl=en.- Ocultar texto das
> mensagens anteriores -
> >
> > - Mostrar texto das mensagens anteriores -
>
> --
> 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]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>
--
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.
