Micro Focus QTP (UFT) Forums
How to give comma seprator when RS is returned multiple results? - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to give comma seprator when RS is returned multiple results? (/Thread-How-to-give-comma-seprator-when-RS-is-returned-multiple-results)



How to give comma seprator when RS is returned multiple results? - prasannadr - 03-29-2012

Friends,

I am beginner for QTP. please help me and guide me to reach my goal.

Code:
My RS - ' Test1 = Connect.Execute ("select EMPID from EMPTBL")'
datatable.value("ABC",dtlocalsheet)

Question: i am getting multiple results for the EMPID column. i want to give comma seprator for each result and write in Datatable . How can i script it?
guide me if my way of scripting is wrong to get the multiple results.

Result: i am getting the result and dttable value like 101102103104105 but i want the value like 101,102,103,104,105


Thanks in advance
Prasanna