Re: want literal * in like EOQualifier problem

Hi,

have you tried to subclass an EOQualifier to implement your required 
behaviour?

I am still using WO 4.5.1, but we have plenty of custom qualifiers used 
everywhere; they are not always trivial to set up, but definitely 
doable.

Giulio Cesare Solaroli

On 6 May 2004, at 02:02, Ty Shipman, CIO/CTO, Kagi wrote:

> Hello,
>
> Thanks for any help that might be rendered here.
>
> I am using 5.2.1, but this happens also in 4.5.1, not sure about 5.3.x
>
> I want to product the following SQL code using an EOQualifier like 
> statement
> 	select * from table where column like text*text2%
>
> 	When I pass the "text*text2%" to EOQualifier it comes out as:
> 		"...text%text2%"
>
> I have tried various exscape sequences:
> 	text**text2%
> 	text\*text2%
> 	text%*text2%
> 	text[*]text2%
>
> 	But all end up with the replace of * with %
>
> The docs do not tell me how to escape an * in the like qualifier to 
> get it passed through as a literal, any more suggestions? Any tricks, 
> any bugs #?
>
> Thanks
> ty
> -- 
> I am trying to become obsolete.   But I can not because I am 
> autodidactic.
>
> That is why I put lots of comments into the code, so I could forget.
> _______________________________________________
> EOF mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/eof