Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


ifeguy
2017-09-14T18:53:26Z
I have an SQL task that returns a string value of "name 1, name 2, name 3" as a single string. However, the VC SQL task output will put each value on its own line regardless of the output settings (field separator, line break).

Any ideas on how to keep this value in tact on a single line?
Sponsor
Forum information
Support
2017-09-15T08:31:25Z
Please add screenshot of SQL result in SQL Management tool and screenshot from VC. It sounds like you have only one column. Then it will use the Line break specified.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
ifeguy
2017-09-19T02:10:52Z
Unfortunately, I cannot provide a screen shot. I have introduced a temporary workaround,and also its sensitive data.

Yes, there is only one column of data that has multiple rows in the VC ouptut. The string that I am referring to is definitely a single string, and was confirmed in MS SQL manager. My issue is that VC is adding line breaks, regardless of the line break setting I specify.
Scroll to Top