Forum Discussion
alibaba82
17 years agoSuper Contributor
Please ignore the post. Just need some help with the SQL
I have the following groovy code
String query = "WITH Ordered AS (SELECT ROW_NUMBER() OVER (ORDER BY Email) AS RowNumber, email FROM aspnet_Membership) SELECT email FROM Ordered WHERE RowNumber between 0 and 10 "
List myList = sql.rows(query)
log.info(myList)
This give me out in the format.
{email=ARAZA-LT7823504795@ARAZA-LT7823504795.com}, {email=ARAZA-LT78235142339@ARAZA-LT78235142339.com}, {email=ARAZA-LT79105027214@ARAZA-LT79105027214.com}, {email=cpsadmin@tvguide.com}, {email=CPSLOAD1_0_713113251753@CPSLOAD10713113251753.com}, {email=cpsuser015@tvguide.com}, {email=cpsuser016@tvguide.com}, {email=cpsuser022@tvguide.com}, {email=cpsuser023@tvguide.com}
How can I construct the SQL such that I get only comma delimited emails with 'email='. so something like
23504795@ARAZ3504795.com, ARAZA-LT7ARAZA-LT7823504795.com, ARAZA-LT795@ARAZA-LT78235.com
Thanks
Ali
I have the following groovy code
String query = "WITH Ordered AS (SELECT ROW_NUMBER() OVER (ORDER BY Email) AS RowNumber, email FROM aspnet_Membership) SELECT email FROM Ordered WHERE RowNumber between 0 and 10 "
List myList = sql.rows(query)
log.info(myList)
This give me out in the format.
{email=ARAZA-LT7823504795@ARAZA-LT7823504795.com}, {email=ARAZA-LT78235142339@ARAZA-LT78235142339.com}, {email=ARAZA-LT79105027214@ARAZA-LT79105027214.com}, {email=cpsadmin@tvguide.com}, {email=CPSLOAD1_0_713113251753@CPSLOAD10713113251753.com}, {email=cpsuser015@tvguide.com}, {email=cpsuser016@tvguide.com}, {email=cpsuser022@tvguide.com}, {email=cpsuser023@tvguide.com}
How can I construct the SQL such that I get only comma delimited emails with 'email='. so something like
23504795@ARAZ3504795.com, ARAZA-LT7ARAZA-LT7823504795.com, ARAZA-LT795@ARAZA-LT78235.com
Thanks
Ali
Related Content
- 2 months agoStoplight
- 2 months agoStoplight
- 3 years agogeneticmaterial
Recent Discussions
- 4 days agominhng