• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Named Query need help

 
Philip Zac
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello to all,

in mysql command, I enter the query like this ......



+----+----------+----------------+----+----------------+--------------+----+----------+----------+---------+------------+------------+-----------------+-------------+-----------+---------+---------+
| id | username | hotel_group_id | id | hotel_group_id | web_agent_id | id | added_by | added_on | address | deleted_by | deleted_on | email_id | name | telephone | version | website |
+----+----------+----------------+----+----------------+--------------+----+----------+----------+---------+------------+------------+-----------------+-------------+-----------+---------+---------+
| 1 | user | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | pop@eye.com | Pop Eye | 789456321 | 1 | NULL |
+----+----------+----------------+----+----------------+--------------+----+----------+----------+---------+------------+------------+-----------------+-------------+-----------+---------+---------+

I get a good result.

But when I implement this in named query as given below






Is the above query correct? On which class should it be on ?? I get a null result from it?? What is wrong with it???



Thanks ..
Philip
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic