Re: passing select column list as string

2016-02-18 Thread ram
To: "[email protected]" Sent: Monday, February 15, 2016 1:12 PM Subject: passing select column list as string   Hello,      i was trying to write a namedquery , but would like to pass the select columns as arguments .  @NamedQuery(name="emp.findAll", query="SE

Re: passing select column list as string

2016-02-16 Thread Roberto Cortez
Hi ram, As far as i know, is not possible to set the select columns as parameters. If you want to make it dynamic, you can try the Criteria API. Cheers,Roberto From: ram To: "[email protected]" Sent: Monday, February 15, 2016 1:12 PM Subject: passing select column list

passing select column list as string

2016-02-15 Thread ram
Hello,      i was trying to write a namedquery , but would like to pass the select columns as arguments .  @NamedQuery(name="emp.findAll", query="SELECT s.id.name,s.id.phone,s.address FROM emp where s.id.name=:na and s.id.phone=:ph").  I would like to pass "s.id.name,s.id.phone,s.address " it a