Solved

How to correctly format the info for   CSVFormat(query [, qualifer] [, columns]) UDF to get a output

Posted on 2009-07-09
2
214 Views
Last Modified: 2013-12-24
Expert Needed.
This UDF is CSVFormat(query [, qualifer] [, columns])
How do I transalte that to my
query=MyQ  - no qualifier, [ headernames],[collumns])
<cfoutput>#CSVFormat(MyQ,"",[FirstName,LastNAme],[FirstName,LastNAme])#</cfoutput>

I get this:
Missing argument name.  
When using named parameters to a function, every parameter must have a name.
The CFML compiler was processing:

An expression beginning with CSVFormat, on line 100, column 12.This message is usually caused by a problem in the expressions structure.
The body of a cfoutput tag beginning on line 100, column 2.
The body of a cfoutput tag beginning on line 100, column 2.
The body of a cfoutput tag beginning on line 100, column 2.
 

<cfoutput>#CSVFormat(MyQ,"",[FirstName,LastNAme],[FirstName,LastNAme])#</cfoutput>

Open in new window

0
Comment
Question by:LeadCo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 36

Accepted Solution

by:
SidFishes earned 500 total points
ID: 24817074
just a guess as not used that udf but trying leaving off the "" for qualifier the udf probably handles a default

you also might try

#CSVFormat(MyQ,"FirstName,LastNAme")#

0
 

Author Closing Comment

by:LeadCo
ID: 31601704
Thanks!
0

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question