[hibernate] HQL concat

Bonjour,
j'ai le problème suivant:
Je désire concaténer deux champs séparé par un espace vide dans une requête HQL:

Cette requête sans espace fonctionne:

Code:

---

select concat(m.ordergiver.userLastname , m.ordergiver.userFirstname), count(m) from MandatDTO as m group by m.ordergiver.userLastname , m.ordergiver.userFirstname where (m.dateMandat between :fromDate and :toDate) and (m.service = :service)

---

Si je mets un espace, ça foire !

Code:

---

select concat(m.ordergiver.userLastname ,' ' , m.ordergiver.userFirstname), count(m) from MandatDTO as m group by m.ordergiver.userLastname , m.ordergiver.userFirstname where (m.dateMandat between :fromDate and :toDate) and (m.service = :service)

---

Avez-vous une idée ?

Merci

J'ai la solution. Il faut faire un concat dans le concat:

Code:

---

1 2	select concat(concat(m.ordergiver.userLastname,' '), m.ordergiver.userFirstname), count(m) from MandatDTO as m group by m.ordergiver.userLastname , m.ordergiver.userFirstname where (m.dateMandat between :fromDate and :toDate) and (m.service = :service)

---