Re: WebServices and LIKE qualifications

2007-03-09 Thread Stephen Earl
DOH! After actually having some time away from my screen it turns out I was being a dufus! Going through my logs it appears that for some reason the webservice hadn't refreshed in the mid-tier cache and was still running the '=' qual instead of the 'LIKE' qual... very odd. Restarted tomcat on t

Re: WebServices and LIKE qualifications

2007-03-08 Thread Stephen Earl
Carey, What do you think is the functional difference between the following: (They look like they would produce the same thing to me.) > So in theory this would expand to: > > ('Account Name' LIKE "ACCOUNT NAME"+"%") > > Whch isn't really what I want, what I really want is: > > ('Account Name'

Re: WebServices and LIKE qualifications

2007-03-08 Thread Carey Matthew Black
Stephen, What do you think is the functional difference between the following: (They look like they would produce the same thing to me.) So in theory this would expand to: ('Account Name' LIKE "ACCOUNT NAME"+"%") Whch isn't really what I want, what I really want is: ('Account Name' LIKE "ACC

WebServices and LIKE qualifications

2007-03-08 Thread Stephen Earl
Hi All, I'm sure I've missed something really simple but I'm trying to get the following scenario to work but for the life of me I can't, so here goes: I have a webservice which is querying an underlying form based on data being provided by the WS client, the webservice is configured with the fo