dcsimg
Please help! How can I specify a SQL LIKE query in an CMP Entity Bean using Inprise AppServer
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   John_Heart
Posted On:   Wednesday, May 9, 2001 11:46 AM

What is the exact syntax for specifying a SQL LIKE query using wildcards (i'd like to add the wildcards in the actual query).

I'm thinking of something like: " WHERE FIRSTNAME LIKE :firstname% "

where :firstname is the parameter for my finder method and the % will be applied to the string, so that for firstname="John" the resulting query will be

"SELECT ... WHERE FIRSTNAME LIKE 'John%'"

I'm using Borland/Inprise AppServer 4.5.

About | Sitemap | Contact