May 27, 2008, 10:00 PM
Tomswebcode unique characters in WHERE statement
I have coded a where statement like this:
DFINE FILE PMTRACKING
CORRECT/I5 = IF INDCODE EQ 'ETCrelatecx' AND ANSWER EQ 'Y' THEN 1
ELSE IF INDCODE EQ 'H&Pcompletew/in2w' AND ANSWER EQ 'Y' THEN 1
ELSE 0;
END
When I run the FEX, I get an html page prompting for input
To get around this error, I have coded
ELSE IF INDCODE CONTAINS 'Pcompletew/in2w' AND ANSWER EQ 'Y' THEN 1...
Any ideas for how I can use escape characters to test for the
'H&Pcompletew/in2w'?
Thanks!
May 28, 2008, 02:29 AM
Tony ATom,
For the ampersand character you should separate it from the following character by using a single "pipe" - soft concat - character as in 'H&|Pcompletew/in2w'. The same method may work if you are having trouble with the slash, but I am not so sure.
T