Skip to main content
Participating Frequently
February 8, 2016
Question

How to put values in list with single quotation

  • February 8, 2016
  • 2 replies
  • 458 views

<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

    This topic has been closed for replies.

    2 replies

    Carl Von Stetten
    Legend
    February 8, 2016

    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.

    Participating Frequently
    February 9, 2016

    Thanks a lot

    Carl Von Stetten

    WolfShade
    Legend
    February 8, 2016

    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,

    ^_^

    Participating Frequently
    February 9, 2016

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