Hi all,
I just managed it by myself.
I left the jdbc-where-clause in it's standard form
<jdbc-where-clause>
where namePrefix1 like ? and location like ?
</jdbc-where-clause>
but I appended the SQL-Wildcard % to the substring, for
which i am searching in the Java-Code, so
that the parameters of the finder-Method have the % in them.
Bye,
Stephan
Stephan Bauer schrieb:
>
> Hello Jonas-people,
>
> has anyone managed to have a like statement
> in his jdbc-where-clause ?
>
> I want to search for all records, where a certain
> column starts with a certain letter.
>
> in SQL I'd write:
>
> select * from Address where street like 'A%';
>
> I tried it with:
>
> <jdbc-where-clause>
> <![CDATA[where namePrefix1 like ?% and location like ?%]]>
> </jdbc-where-clause>
>
> How do i use the sql-wildcard %
>
> Many thanks in advance,
>
> Stephan
>
> --
> _________________________________________________________________________
>
> Stephan Bauer, Dipl. Inform. (FH) IT-Freelancer
> Siemensstr. 46 Tel.: +49 9421 9749549
> D-94315 Straubing Fax: +49 9421 9749550
> E-Mail: [EMAIL PROTECTED] Mobil: +49 172 9795002
>
> http://www.sportmaschine.de
> Sportmaschine.de - das neue, grosse Portal f�r Sportvereine
> _________________________________________________________________________
> ----
> 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".
--
_________________________________________________________________________
Stephan Bauer, Dipl. Inform. (FH) IT-Freelancer
Siemensstr. 46 Tel.: +49 9421 9749549
D-94315 Straubing Fax: +49 9421 9749550
E-Mail: [EMAIL PROTECTED] Mobil: +49 172 9795002
http://www.sportmaschine.de
Sportmaschine.de - das neue, grosse Portal f�r Sportvereine
_________________________________________________________________________
----
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".
