Re: Expression returning always 0 rows...

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Mar 30 2006 - 02:49:26 EST

Next message: Pirola Davide: "Hsqldb - Shutdown"

Previous message: I. Venuti: "Expression returning always 0 rows..."
In reply to: I. Venuti: "Expression returning always 0 rows..."
Next in thread: I. Venuti: "Re: Custom select string for Expressions?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Ivan,

On Mar 30, 2006, at 11:39 AM, I. Venuti wrote:

> [bind: '', '', '', '', '', '', '']

This is the cause of the problem. You are using empty strings ("")
for parameters. For a parameter to be excluded from processing it has
to be absent from parameter map (null or "" are both considered valid
parameters).

To achieve the desired result you'll have manually preprocess
parameter map before passing it to Cayenne, removing all empty string
values.

Andrus

Next message: Pirola Davide: "Hsqldb - Shutdown"
Previous message: I. Venuti: "Expression returning always 0 rows..."
In reply to: I. Venuti: "Expression returning always 0 rows..."
Next in thread: I. Venuti: "Re: Custom select string for Expressions?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Mar 30 2006 - 02:49:54 EST