on 12/17/03 5:34 PM, Martin Kloss at martin.kloss AT gmx DO.T de wrote:
> At 15:41 17.12.2003, you wrote: >> I recommend try to build correct query by visQL first of all. > > how? I know what the correct query is supposed to look like: > > LIKE '(?i)m?ller\'s \(data\)' > > But if the input is: > > m?ller's data > > I need to parse the string and escape the characters that need escaping. > > IF I use the ValentinaEscapeString function with TRUE, the output is: > > LIKE '(?i)m\?ller\'s \(data\)' > > IF I use the ValentinaEscapeString function with FALSE, the output is: > > LIKE '(?i)m?ller\'s (data)' > > BOTH results are NOT correct, it SHOULD BE: > > LIKE '(?i)m?ller\'s \(data\)' > > Right? So I would need to escape all the characters manually, > but then why do we have the ValentinaEscapeString function?
Martin,
Let's go step by step!
USER do input 'm?ller's (data)' Yes?
You need escape this USER INPUT only And you get
'm\?ller's \(data\)'
Aha, I see problem...
Hmm, then really, it is USER must give you input
'm?ller's \(data\)'
I.e. He self must specify that in this pattern symbols () Must be used as CHARS.
Is this answer ?
-- Best regards, Ruslan Zasukhin [ I feel the need...the need for speed ] ------------------------------------------------------------- e-mail: ruslan@paradigmasoft.com web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to: http://lists.macserve.net/mailman/listinfo/valentina -------------------------------------------------------------
_______________________________________________ Valentina mailing list Valentina AT lists DO.T macserve.net http://lists.macserve.net/mailman/listinfo/valentina
©2003 Ruslan Zasukhin |