Oh! This is closer sql style. I tried to use o.Id.ToString() :))

Thank you very much!

On Jul 20, 1:26 am, Diego Mijelshon <[email protected]> wrote:
> Use cast(o.Id as string).
> You can also use AnsiString, etc, depending on your needs.
>
>     Diego
>
> On Mon, Jul 19, 2010 at 03:05, alexey_baranov <[email protected]> wrote:
> > hi!
>
> > I'm trying to get all object's parents doing this query:
>
> > from Obj o where :path like o.Path + o.Id+'/%' order by o.Path
>
> > And get an error about this expression because o.Path is String '/%'
> > is String, but o.Id is Int32? (nullable)
>
> > o.Path + o.Id + '/%'
>
> > What database independent function has NHibernate to convert o.id to
> > string type? Some like this
>
> > o.Path + NHConvert(o.Id, String) + '/%'
>
> > thanks!
>
> > --
> > 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.

Reply via email to