I have a flow where I run a script, read the output file, and use that output as SQL to run. That works fine.
However, the output from the SQL is supposed to be formatted dokuwiki code (don't worry, I'm not just using SQL to format the output for me, it actually stores values as well), but in visualcron the output is only a fraction of what it is supposed to be. The same code run in SQL Management Studio produces the full output.
I checked the output both via "output" from the task, and mailed myself the output via the {TASK(PrevTask,StdOut)} variable. Same result.

Question: Is anyone else having problems with output from SQL queries? I understand that normally you just want to see something like "x rows affected", but I need my output :)

The SQL server is MSSQL.

/A

Run the query through the SQL explorer in VisualCron - same result?

---

Yes, same result.

The output starts with a */ which would be a "end of comment" for the dokuwiki output im expecting. Is there any parsing done on the output perhaps?

Yes, same result.

The output starts with a */ which would be a "end of comment" for the dokuwiki output im expecting. Is there any parsing done on the output perhaps?

No, but perhaps you are expecting some output that comes from the SQL Management studio that is not part of normal output?

I am not sure how to reproduce this in MSSQL Management studio but aren't your output there (that you are missing) marked differently?

---

It's not easy explaining this :)
I'll try with a few images instead.

I am available on Skype, same username as here, if you want to chat. Might be easier.

For other users: This problem was solved. Some output was produced by PRINT which isn't in the normal output. Using SELECT for this output solves the problem!

Thanks VC support 🙂

Solved on chat. End user was using PRINT which is not sent to normal output. Now replacing with SELECT statements.

---