Cecil
19+ years progress programming and still learning.
dynamic query - Forum - OpenEdge General - Progress Community
Following on from the above thread.
Has this been resolved?
I tried to replace a single quote mark ' with ~', did not work.
I tried to replace the ' with ~047, that too did not work.
Basically, how do you handle query strings which might contain a single or double quote?
i.e.
Following on from the above thread.
Has this been resolved?
I tried to replace a single quote mark ' with ~', did not work.
I tried to replace the ' with ~047, that too did not work.
Basically, how do you handle query strings which might contain a single or double quote?
i.e.
orFish 'n Chips
Mitre10 "MEGA" Store
Code:
searchTerm = 'Mitre10 "MEGA" Store'.
searchString = SUBSTIUTE("name eq &1", QUOTER(searchTerm) ).
queryStringWhere = SUBSTITUTE("where &1", searchString ).