Hi,
thanks for the fast reply and yes I am interested in the sources, but I
am not sure if I can convice my project to use the patch.
Question to everyone
Is there any reason why the patch was not included into JOnAS?
So long!
simon
Santiago Gala wrote:
>
> 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".
----
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".
