How to put values in list with single quotation

[Lakshmikanth_S_13]

<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#)

</cfquery>

<cfset nickname_list=Valuelist('getSelectedPriorityList.name')>

If I run above code the value of nickname_list =  Send Certificate Invitation,View Certificate,Allow Key Recovery

but

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

[WolfShade]

You _should_ be using CFQUERYPARAM for the values, just for security.  However, the CFQUERYPARAM has an attribute "list" that might fix it.  If not by itself, you might be able to use QuotedValueList().

HTH,

^_^

[Lakshmikanth_S_13]

list attribute worked perfectly..Thanks a lot for the response

[Carl Von Stetten]

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.

[Lakshmikanth_S_13]

Thanks a lot

Carl Von Stetten