1 Reply Latest reply on Sep 26, 2002 10:27 AM by davidjencks

    EJB-QL Question

      I have an existing app that I am changing to EJB.

      In the existing app I retrieve information from the database based on what the user requests.

      In my app the where clause is built dynamically for the query. At one point I can have (Name=? and Value=?) occur n number of times (i.e. It could occur an infinite amount of times.

      I cannot see a way to implement such an occurrance in EJB-QL. It appears to me that EJB-QL will only take very structured queries and is not capable of supporting dynamicly created ones.

      Is this a valid assumption? If not, how does one create dynamic queries?

      Thanks!