Go Premium for a chance to win a PS4. Enter to Win

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

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

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
LeadCo
Asked:
LeadCo
1 Solution
 
SidFishesCommented:
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
 
LeadCoAuthor Commented:
Thanks!
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