I have a text input box in my html page and the users enter either lowercase or the uppercase. I need to pass this parameter in to WHERE statement in my FEX.
I am having trouble doing that. UPCASE is not working.
November 17, 2004, 05:39 PM
George Brown
Can you post the upcase code and the error message? That will help us figure it out.
November 17, 2004, 09:45 PM
RB
Here you go...
DEFINE FILE CAR COUNTRY1/A8 = UPCASE(8, &COUNTRY, COUNTRY1); END
TABLE FILE CAR .... ..... ... ... WHERE COUNTRY EQ COUNTRY1 END
when I enter country value as "england" for the amper variable, it takes the value in define, but gives me an error telling that "field name or computational element not recognised:england"
November 17, 2004, 09:54 PM
Leah
Didn't run this but try putting quote marks around the & variable. DEFINE FILE CAR COUNTRY1/A8 = UPCASE(8, '&COUNTRY', COUNTRY1); END
TABLE FILE CAR .... ..... ... ... WHERE COUNTRY EQ COUNTRY1 END Leah C.
November 18, 2004, 02:30 PM
RB
Hi Leah,
The report does not work if we give the quotes. It gives the same error as before.
-*THIS WOULD CONVERT &COUNTRY PARAMETER TO UPPERCASE AND PASS IT TO &COUNTRY1. this way we could use it in the where statement
TABLE FILE ..
... .. WHERE COUNTRY EQ '&COUNTRY1' END
January 04, 2005, 06:39 PM
<NorthNone>
RB, thanks for the post. What you did worked fine for my FEX. Appreciate it :-)
January 06, 2005, 12:51 PM
Tom Walker
You can also force the case conversion at the HTML level. Assuming you are using TEXT INPUT ...
name="TEXT1" size="6" maxlength="6" onChange="javascript:this.value=this.value.toUpperCase();">[/code]This message has been edited. Last edited by: <Mabel>,