i am running one query under mysql and trying to convert the columns to array but the issue is, it is taking concat and breaking it in wrong way, my query (what ia m using is ListToArray(k,","), now i want it to consider concat as one single list instead of breaking it in multiple arrays, how can i fix it, any clues

var k = tblviews.viewsID, concat('<a href=<http://localhost:11000/project1/views_view.cfm?849402E6-E905-790C-E0083357100F99CE=849402E7-01A6-D87F-EDF2EBE1F5ADCBF6&viewsID=2922J07C52B45E706494A8B8687C8CB864568AA8906490B09C7C6E48B6BC9E425088BE441&Task=color>>',tblviews.viewsTitle, '<small>(',tblviews.viewsID,')</small></a>') as viewsTitle, tblviews.viewsManager_ContactID, tblviews.EndDate_Scheduled, tblviews.viewsViews_Target, tblsection.sectionName, tblcontact.FirstName, tblcontact.LastName

are you trying to use mysql functions inside cf?

i managed to have it fixed, i used mysql set parameter to pipes and it all sorted now