Hi everyone!!:

This is my first discussion topic but i've been searching for a while through Focal Point and Google to find any answer for my problem, but i haven't found any solution to this.

I've got a fex file that runs an htmlform passing various parameters without any problem.

This parameters contains SQL Sentences that appears at text boxes in the html file

In this way:

Textbox1 has in his default value !IBI.AMP.SQL_Sentence_01; as in fex it is &SQL_Sentence_01

The problem is:

If this &SQL_Sentence_01 has characters like '<' or '>' the html created with Composer seems not to deal with it. If the parameter doesn´t contains any of those characters, everything goes fine...

If we exit from the fex file just before the htmlform it shows the parameters without problem, so the problem must be related with the html source generated by Composer.

Does anyone knows how to deal with those special characters in the html file?

Thanks in advance, and sorry if this question has been answered previously, but as I've told you... I didn't find anything like this.

This message has been edited. Last edited by: <Kathryn Henning>,

Have you tried changing the < to <|

But I dont want to change those characters as I said, this are sql sentences and I like to see those sentences as they are written in the table.

Those sentences are used in Batch Processes (not through WF) and we'd like to be able to know what sql sentences are used in a Batch Process choosen by the user.

If the user plans to change the sentence... he paste the new sentence in the text box and it will be replaced in the table.

Or if he wants to know the result of any sentence that has been executed for this task, he only need to copy the sentence in the text box and execute it in the BBDD engine, so if we change those characters the task will fail as <| isn's works in the BBDD engine.

Any other idea?

Thanks in advance

For valid HTML, text in textarea's (or between any other HTML tags) needs to be escaped to not conflict with the HTML markup. Changing your strings when they're placed between HTML tags is mandatory. You can't avoid that when using HTML.

That said, the browser translates those strings back for the user as well, as long as you use HTML entities to escape your strings. In your case, you need to replace "<" and ">" with "&lt;" and "&gt;" respectively.

As Web5622 alluded, change the characters in the program, not the source.

While I post my problem here...I also asked to Spain Tech Support Team for a solution for this issue.

They answered me yesterday, and as usually, they were Superbbbb.

This was the solution they gave me and it was a real stupid thing for me not to think about this before

This was the source just before calling the htmlform

-SET &SQL_Sentence_01 = &SQL_Sentence_1;

If we change this to the new sentence:

-SET &SQL_Sentence_01 = '"' | &SQL_Sentence_1 | '"';

everyting goes as it was supossed to be... fine!!!

It was only a matter of telling the htmlform that this parameter was literally a string!!!

Obvious.... isnt it?

Sometimes we look for a solution everywhere but the solution is right in front of us!!!

Thanks a lot Wazz and Wep5622