Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

assigning single quotes to a recordset

I run a query and get the following output:  A,B,C
How do I use cfset to assign the recordset above to a variable with single quotes around each letter?
Outcome I am looking for is

<cfset mytext = ('A', 'B', 'C)'>  Is this possible?
0
jramos74
Asked:
jramos74
1 Solution
 
Scott BennettManager TechnologyCommented:
Use the quotedValueList() function

#QuotedValueList(query.column)#
0
 
jramos74Author Commented:
THANK YOU!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now