Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 349
	Members: 0
	Total: 349

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

SQL QUERY NODE outputData

4 Replies

0 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Magus

Basic Member

Posts: 6

4/19/2016 8:55 AM

Hello All,

Am using a SQL QUERY NODE to query a table..But, the SQL QUERY NODE _ outputData is blank..

Please anyone guide me to fetch the results of that query and send them to a directory..

Lawson_Kid

Basic Member

Posts: 13

4/19/2016 7:55 PM

Would you mind posting the SQL?

Magus

Basic Member

Posts: 6

4/20/2016 4:04 AM

Have no issues with Query..Its working fine and can see the results in log..

my concern here is with , "SQLQuery2440_outputData = " ..
Its blank here but i can see the results in log.

SQLQuery2440_errorCode = 0
SQLQuery2440_informationCode = 0
SQLQuery2440_returnMessage = SQL query SQLQuery2440: Execution complete.
SQLQuery2440_outputData =
Activity completed: SQLQuery2440
SQLQuery2440_RETURN_MSG = Success
SQLQuery2440_RETURN_CODE = 0
SQLQuery2440_errorCode = 0
SQLQuery2440_informationCode = 0
SQLQuery2440_returnMessage = SQL query SQLQuery2440: Execution complete.
SQLQuery2440_outputData =
SQLQuery2440_RECORD_COUNT = 66

Basically i want to export the results in log , using msgbuilder or file access to a directory..when i used "SQLQuery2440_outputData = " in msgbuilder its getting errored out.

Any way to export entire results without specifying individual variables in "SQLQuery2440_outputData = " ..?

JimY

Veteran Member

Posts: 510

4/21/2016 4:42 PM

Did you check the box to Enable Sql result values outside the loop?

Magus

Basic Member

Posts: 6

4/22/2016 7:31 AM

Yes Jimy..But still no luck :crazy::cry: