ListQualify() can't be made to only affect certain elements, no.
And if setting them inline didn't work, hmm...
Some DB's will allow concatenation in the select: MySQL would be something
like:
SELECT Concat('"', employee, '"') as textEmployee, Concat('"', jobcode,
'"') as textJobcode
or maybe even just:
SELECT '"' + employee + '"' as textEmployee, '"' + jobcode + '"' as
textJobcode
and then change the cfoutput to use those fields instead. Those inner quote
marks may need to be escaped, I'm not in a position to test that out right
now, and can't recall for sure.
The simplest answer to me would still be doing it inline, maybe using
chr(34) in place of the ":
<cfset CONTENT = "#chr(34)##employee##chr(34)#,
#chr(34)##jobcode##chr(34)#,other fields here">
On Thu, Apr 10, 2008 at 3:19 PM, Tech Gate <[EMAIL PROTECTED]> wrote:
> >> surround each data column with quotes, either one at a time
> If I put the quotes at a time, I am getting the error below.
>
> Invalid CFML construct found on line 20 at column 44.ColdFusion was
> looking at the following text:<p>,</p><p>The CFML compiler was
> processing:<ul><li>a cfset tag beginning on line 20, column 18.</ul>
>
> If I put <cfset CONTENT = ListQualify(CONTENT,'"',",","all")>, the
> rest of columns with the data with spaces got shifted to right. I
> have some more columns for address, etc on the file.
>
> Is there a way to tweak <cfset CONTENT =
> ListQualify(CONTENT,'"',",","all")> for "#employee#","#jobcode#" only?
>
> thx much
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
