want literal * in like EOQualifier problem
"Ty Shipman, CIO/CTO, Kagi" <[email protected]> Wed, 5 May 2004 17:02:26 -0700
| Newsgroups | gmane.comp.web.webobjects.devel,gmane.comp.web.webobjects.eof |
|---|---|
| Message-ID | <p0610054fbcbf310bb24b@[157.22.137.101]> |
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.