Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, June 20, 2025 
 slxdeveloper.com
 Community
 Members
 General
 Architect
 External
 Web
 Downloads
 Resources
6/20/2025 5:35:35 AM







 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Scripting & Customization | New ThreadView:  Search:  
 Author  Thread: SLX Template - Mergefield limitation
Thomas Aussem
Posts: 57
 
SLX Template - Mergefield limitationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Apr 07 5:13 AM
fiogf49gjkf0d
Does anyone know wether the mergefields in a SalesLogix template have a length limitation.

I have inserted a SLX field (database field type: Memo) into a SalesLogix letter template and that field contains some comments about the contact. But if I print out the template, the content of that SLX mergefield is truncated after 254 characters.

We are using SLX 6.2.3.

Regards,
Thomas
[Reply][Quote]
Carla Tillman
Posts: 290
 
Re: SLX Template - Mergefield limitationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Apr 07 10:22 AM
Have you tried casting it to text field?

c
[Reply][Quote]
Thomas Aussem
Posts: 57
 
Re: SLX Template - Mergefield limitationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 26 Apr 07 2:36 PM
fiogf49gjkf0d
Thanks Carla.

Yes, I have tried to cast it to text field, but it doesn't works.

It seems that the mergefields in SalesLogix are limitated to show not more than 255 characters.

Regards,
Thomas
[Reply][Quote]
Carla Tillman
Posts: 290
 
Re: SLX Template - Mergefield limitationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 26 Apr 07 4:07 PM
fiogf49gjkf0d
Not sure I am of any assistance here, but I do have one other thought on troubleshooting. Are you sure the issue is in the SLX export? Could it possibly be that the field in the MailMerge template can not receive more than 254? Are there any properties you can manipulate at that level?

When (and If! ) I get a moment I'll try it on my environment and see what I can or can not manipulate.

c
[Reply][Quote]
John Bennett
Posts: 34
 
Re: SLX Template - Mergefield limitationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Aug 07 10:01 AM
an update to this posting.....

I am experiencing the same problem...has anyone found a solution or at least confirmed that this is the case and we are not doing something incorrect
[Reply][Quote]
John Bennett
Posts: 34
 
Re: SLX Template - Mergefield limitationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Aug 07 12:27 PM
found the answer from another forum but will post here also...

Instead of using the inserted field, change that and use a SQL field instead and write SQL that returns the memo data back to the field. Just make sure that the Where clause equals the contactID that your merge record includes...

select "memo field" from 'xxxxxx'
where contactid = :ContactId

John
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.
code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed   
 
page cache (param): 6/20/2025 6:18:52 AM