How do i pass a named parameter to a UDF?

I have a UDF which I got from

The UDF = QueryToCSV2(query [, headers] [, cols])

My Question:

How do i pass these params to the UDF


How would I write the code:

This does not work any ideas?

Who is Participating?
azadisaryevConnect With a Mentor Commented:
just do it like this:

<cfquery name="myQuery" ...>
<cfset headers = "FirstName,LastName,Phone">
<cfset cols = "First_Name,Last_name,phonenumber">
<cfset myCSV = QueryToCSV2(myQuery, headers, cols)>

Kevin CrossChief Technology OfficerCommented:
If I am understanding correctly, you want to pass in a parameter instead of literals for column headings / name you can try like this.

I don't have CF on this machine to test, but can also try EVAL(
<cfset test = QueryToCSV2(MyQuery, FirstName & "," & LastName & "," & Phone, First_Name & "," & Last_name & "," & phonenumber)>
<!--- don't believe it is needed on right side of cfset, but can add ## --->
<cfset test = QueryToCSV2(MyQuery, #FirstName# & "," & #LastName# & "," & #Phone#, #First_Name# & "," & #Last_name# & "," & #phonenumber#)>

Open in new window

Kevin CrossChief Technology OfficerCommented:
Please ignore this part *I don't have CF on this machine to test, but can also try EVAL(
That is what the second was showing using the #variablename# as I read your question to mean that FirstName was a named parameter, etc.
LeadCoAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.