Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

hql cast in formula

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

snopims

Post subject: hql cast in formula

Posted: Tue May 12, 2009 11:26 am

Newbie

Joined: Tue May 12, 2009 5:54 am
Posts: 9

Code:

<property name="Chemin" type="String" formula="(case when (NIVEAU_PARENT_FK IS null) then 
               ID 
               else
              (case when ((select __NIVEAU.NIVEAU_PARENT_FK from NIVEAU as __NIVEAU where __NIVEAU.id=NIVEAU_PARENT_FK) is null) 
                    then (ID + '-' + NIVEAU_PARENT_FK)
                    else (select (ID + '-' +  NIVEAU_PARENT_FK + '-' + __NIVEAU.NIVEAU_PARENT_FK) from NIVEAU as __NIVEAU where __NIVEAU.id=NIVEAU_PARENT_FK) end)
               
                 end)" />

i've problem, beacause (ID + '-' + NIVEAU_PARENT_FK) result 3 and not "1-2". Why ? I try to convert but ....
I've tried Cast(ID as VARCHAR) but i've a error
Why ??

select cast(ID as ????

Top

thiagorosa

Post subject: Re: hql cast in formula

Posted: Wed May 27, 2009 9:39 am

Newbie

Joined: Wed May 27, 2009 9:37 am
Posts: 1

Try cast(ID as string).

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum