Solved

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

Posted on 2009-07-09
2
184 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
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

Scale it in WD Gold

With up to ten times the workload capacity of desktop drives, WD Gold hard drives employ advanced technology to deliver among the best in reliability, capacity, power efficiency and performance.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
<cffile cannot delete a file 4 44
Strange space issue in Chrome browser 8 98
coldfusion, javascript onclick url update 4 46
Coldfusion Complex Structure Reference 4 25
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now