Hi Sven,
The field names should be the "name", not the "persistence-name". So you
should use "$1 = $_fantasia". You can check this by viewing the generated
SQL after deployment.
I'm not sure about the LIKE construction - but it sounds reasonable.
Nick
At 10:23 AM 9/19/00 -0300, you wrote:
>I have a couple of doubts concerning the <finder-method > tag.
>specifically, I would like to implement a query like "select * from
>table where field LIKE '%value'"
>
>Considering I have:
> <cmp-field-mapping name="_fantasia"
>persistence-name="FANTASIA" />
>in my orion-ejb-jar.xml.
>and the docs tell me:
> <finder-method partial="true|false" query="$1 = $myField AND
>$myOtherField > 5">
>I suppose (not really clear in the docs) that $1 is the value passed to
>the finder method and $MyField is the persistence name, in the above
>example FANTASIA and not _fantasia. Is that correct?
>
>in this case can I create a query like:
> <finder-method query="$1 LIKE '%' + $FANTASIA + '%'">
>
>Sven
>--
>============================================================================
>==========
>Sven E. van 't Veer
>http://www.cachoeiro.net
>Java Developer [EMAIL PROTECTED]
>============================================================================
>==========
