Simon Oldeboershuis wrote:
> Hi,
>
> I am trying to create a finder with a complex sql-statement, where I
> have to bind the same variable twice to a prepared statement. Is there
> any possibility to do that without passing the same argument twice to
> the finder-method?
>
I sent a patch to the list some time ago to do that, but I got no answer.
It was for version 1.6.1, using a syntax like:
WHERE (?0 like description OR ?0 like name OR ?0 like address) AND age <
?1 AND age > ?2
The variables are bound in order, using 0 for the first. Also if there are
no number after the "?", it uses the default behaviour.
An additional extension allowed to do conditional queries, like
WHERE {?0 != null}:{description LIKE ?0}:{description IS NULL}
The patch is in the list archives. I have not ported it yet to Jonas 2.0.
If you want to do it, please tell me and I'll send you the sources. It
involves changes in only one class, the generator.
>
> Thanks in advance!
> simon
>
> PS: I am sorry, I did a reply to an other message and forget to change
> the subject, please ignore that.
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
