Skip to main content
Participating Frequently
Feb 8, 2016 1:52 PM UTC
Question

How to put values in list with single quotation

<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 is closed to new replies. Start a new post to keep the conversation going.

    4 replies

    Carl Von Stetten
    Legend
    Feb 8, 2016 4:05 PM UTC

    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.

    Translate
    Participating Frequently
    Feb 9, 2016 12:38 PM UTC

    Thanks a lot

    Carl Von Stetten

    Translate
    WolfShade
    Legend
    Feb 8, 2016 3:27 PM UTC

    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,

    ^_^

    Translate
    Participating Frequently
    Feb 9, 2016 12:37 PM UTC

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

    Translate