HQL query and databinding problems

hsr555 · **Joined:** Wed Sep 28, 2005 3:44 pm **Posts:** 5

I need to search the table using HQL. I need to specify the '%" constraint for selection of other matching records.

I am trying:

Code:

session.Find ( "Select st.Id from Store as st Where st.Name like " + strSearchCriteria +" OR st.Zipcode=" + strSearchCriteria +"" );

Also when I bind the arraylist to my datagrid, I can see just the Id column. If I take one more field in my query, the grid distorts and some properties are displayed ??

Can anyone guide me on this. Where am I going wrong ??

KPixel · **Posted:** Fri Sep 30, 2005 12:09 pm

For your HQL, try:

Code:

session.Find ( "Select st.Id from Store as st Where st.Name like %" + strSearchCriteria +"% OR st.Zipcode=" + strSearchCriteria );

Note that you should really use parameters here! (read IDataParameters vs plain text queries)

SimonH · **Joined:** Thu Sep 08, 2005 12:15 pm **Posts:** 17

If you want more than one column you may try something like this

Code:

session.Find ( "Select st from Store as st Where st.Name like %" + strSearchCriteria +"% OR st.Zipcode=" + strSearchCriteria );