<cfquery name="getSelectedPriorityList" datasource="#application.datasource#" username="#application.datasource_username#" password="#application.datasource_password#">
SELECT id, name
FROM lrp, p
WHERE lrp.id = p.id
AND lrp.ra_id = 123
AND lrp.id in (#form.assignedPriority#)
If I run above code the value of nickname_list = Send Certificate Invitation,View Certificate,Allow Key Recovery
I am in need the output as nickname_list = 'Send Certificate Invitation','View Certificate','Allow Key Recovery'
Kindly let me know what exactly I need to do to generate above output.Thanks in Advance
list attribute worked perfectly..Thanks a lot for the response
How are you using nickname_list later in your code? Why does it need to be single-quote delimited? You might also considering storing the value in an array rather than a list, depending on how you use it later.