Are there any unusable characters?

[sohashi]

Hi

Do you know the characters that cannot be used when sending an email using LANSA Integrator?
If you use half-width parentheses in the subject, you cannot use it.
* (→ [
Does anyone know if it's not available as a general rule or if it's a LANSA issue?

[Dino]

the parenthesis works fine in integrator if you control the concatenation like this:

Code: Select all

#u_jsmcmd := 'send subject(' + "((((" + #W_Subject + "((((" + ')'
Use Builtin(jsmx_command) With_Args(#jsmxhdle1 #u_jsmcmd) To_Get(#u_jsmsts #u_jsmmsg #message)

but if you try to send that character inputting it in the w_subject field, it gets tricky because you are using the content of w_subject as part of building an expression (the jsm command) that also contains parenthesis that need to be (carefully) open and closed.

by the way, dont forget to upgrade your fields in integrator for special characters...
viewtopic.php?f=3&t=2462&p=7129&hilit=unicode#p7129

[sohashi]

Hi　Dino

Thank you for your reply.
Although the half-width parentheses are described in the coding,
The same thing cannot be done if you send by entering half-width parentheses in the subject line.
Do you know how to avoid it?

[sohashi]

Hi　Dino

Thank you for your reply
The method that taught me was to specify half-width parentheses at the beginning and end of the sentence.
If there are half-width parentheses in the characters, the characters will be garbled.
Is there a way around this?

example
happy Ne)w Year→happy Ne]w Year

[BrendanB]

you could try the following:

Code: Select all

#u_jsmcmd := 'send subject("' + #W_Subject + '")'
Use Builtin(jsmx_command) With_Args(#jsmxhdle1 #u_jsmcmd) To_Get(#u_jsmsts #u_jsmmsg #message)

note the insertion of double-quotes AFTER the opening bracket for subject, and BEFORE the closing bracket for subject.

This *may* allow escape of whatever characters are in the #W_Subject.

[Dino]

It works! Thank you!

itworks.jpg (104.67 KiB) Viewed 19987 times

[BrendanB]

Thanks for confirming Dino.

FWIW -- if you define the JSM fields as *NVARCHAR, then you will get the subject showing as 'HAPPY NE)W YEAR→HAPPY NE]W YEAR' in your email window -- the ? appears because it is a unicode character in a non-unicode field....

Code: Select all

Define Field(#jsmcmd) Type(*NVARCHAR) Length(1024)
Define Field(#jsmsts) Type(*NVARCHAR) Length(512)
Define Field(#jsmmsg) Type(*NVARCHAR) Length(512)