Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » scout » Lookupservice (How to combine fixed sql with lookup)
Lookupservice [message #783235] Wed, 25 January 2012 05:30 Go to previous message
Bertin Kiekebosch is currently offline Bertin Kiekebosch
Messages: 223
Registered: August 2011
Senior Member
Hi,

I have a sql lookUpService like below that works fine

  @Override
  public String getConfiguredSqlSelect() {
    return "SELECT bestandsnaam, bestandsnaam " +
        " FROM geluid " +
        " <key>where bestandsnaam = :key</key>  " +
        " <text>where upper(bestandsnaam) LIKE CONCAT(UPPER(:text), '%')</text>";
  }


but now I want to combine this with some fixed SQL like "where obsolete = 0". Whatever I do I always get an SQL error.

So can I combine a fixed sql part with a lookup service and if yes, how should I do it.

Regards Bertin

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:CalenderField
Next Topic:Server /process HTML page
Goto Forum:
  


Current Time: Fri May 24 19:54:50 EDT 2013

Powered by FUDForum. Page generated in 0.01703 seconds