Hi,
I allways thought the
> <finder>
> <name>findByNameLike</name>
> <query>name LIKE '%{0}%'</query>
> </finder>
should do it. What is the SQL generated? or is there a stack-trace?
Regards,
Burkhard
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 9:52 AM
Subject: [JBoss-user] Jaws -- How can I force Jaws to generate SQL which is
SELECT * FROM TEST WHERE name = '%NAME%' ??
> Hi there,
> As the subject says, how can I force Jaws to generate SQL which is
> [SELECT * FROM test WHERE name = '%NAME%' ] ??
> Actually, it deosn't matter from SELECT to WHERE. What I have to know is
> '%NAME%' part.
> I've tried a couple of combinations below...
> <finder>
> <name>findByNameLike</name>
> <query>name LIKE '%{0}%'</query>
> </finder>
> and
> <finder>
> <name>findByNameLike</name>
> <query>name Like {0} || '%'</query>
> </finder>
> and
> <finder>
> <name>findByNameLike</name>
> <query>name LIKE {'%0%'}</query>
> </finder>
>
> BUT all failed...
>
> Anyone knows how to make it ??
> Thank you.
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
