In your query, you can do: from Blog b where (b.Title = :title or (:title is null and b.Title is null))
On Mon, Apr 19, 2010 at 11:32 AM, Sybaris <[email protected]> wrote: > Hi Ayende, > > I already wrote that a few posts before... (Post #7 of this thread) > > I'll try again: > > That's the way we build our query: > > ISession session = > > ActiveRecordMediator.GetSessionFactoryHolder().GetSessionFactory(typeof(ActiveRecordBase)).OpenSession(); > IQuery query = session.CreateQuery(HQL); // HQL contains a > HQL query string > int pos=0; > foreach (object o in Parameter) // Parameter is an array > of parameters > { > query.SetParameter(pos, o); // I also tried with > SetString() in case that the object o is a string > ++pos; > } > > IList L; > L = query.List(); > > When the "Parameter" array contains NULL strings then the final HQL > query string always contains EMPTY strings ('' that is). I found no > way to get a "NULL" in the final query string. > > G. > > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Users" group. > To post to this group, send email to [email protected] > . > To unsubscribe from this group, send email to > [email protected]<castle-project-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
