aspose file tools*
The moose likes Websphere and the fly likes How to write SQL query with multiple search condition in IBM WACs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "How to write SQL query with multiple search condition in IBM WACs" Watch "How to write SQL query with multiple search condition in IBM WACs" New topic
Author

How to write SQL query with multiple search condition in IBM WACs

Thirumurugan Sivaji
Greenhorn

Joined: Mar 03, 2009
Posts: 20
Hi,
I have a search condition with multiple searches based on input. If I give employee number records to be fetched by emloyee number only and if I give employee no, designation and name starts with some string(like s,sar etc.,). How to write a single query in sql.properties file of IBM WACs framework to do multiple searches. Like I can use :_WHERE_AND(condition1,condition2,condition3 etc). How to write like condition1 and condition2 or name like 'sa%' of '%s%',

Thanks in advance


Warm Regards,

Thirumurugan Sivaji

saiprasad prasad
Greenhorn

Joined: Dec 14, 2012
Posts: 1
Hi Thiru,

I am very new to this IBM WACs and Ireally want to learn and work on this framework very badly, I have googled a lot for this framework but nothing good material i found, thought to reply your blog by asking a help about IBM WACs framework, I really want to know how to kick start with IBM WACs. I really appreciated if you provide me any good material for IBM WACs framework or any urls if you have,.

Awaiting for your reply with thousands of eyes opend.

Thanks in Advance

Warm Regards,
Sai
 
 
subject: How to write SQL query with multiple search condition in IBM WACs