wrong list dude :)
-igor
On Wed, Mar 23, 2011 at 5:22 PM, Russell Morrisey
<russell.morri...@missionse.com> wrote:
> How can I construct a criteria query (or even HQL) with a restriction like
> the following?
>
> select *
> from item
> inner join program on program.unique_id = item.program_id
> where item.name + ' (' + program.name + ')' like ?
>
> I would like to use Restrictions.sqlRestriction() for the where clause, but I
> can't figure out how to get the correct SQL alias for the "program" entity.
>
> Thanks,
> ________________________________
>
> RUSSELL E. MORRISEY
> Programmer Analyst Professional
> Mission Solutions Engineering, LLC
>
> | russell.morri...@missionse.com |
> www.missionse.com<http://www.missionse.com/>
> 304 West Route 38, Moorestown, NJ 08057-3212
>
>
> ________________________________
> This is a PRIVATE message. If you are not the intended recipient, please
> delete without copying and kindly advise us by e-mail of the mistake in
> delivery.
> NOTE: Regardless of content, this e-mail shall not operate to bind MSE to any
> order or other contract unless pursuant to explicit written agreement or
> government initiative expressly permitting the use of e-mail for such purpose.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
