you have too many #s - they are only needed within CFOUTPUT tags and within
""s
therefore line 11 should be
<CFSET TXTOUTPUT= TXTOUTPUT & chr(34) & GetJobs.ListElement & chr(34) %
",">
or if you insist on using #s
<CFSET TXTOUTPUT= TXTOUTPUT & '#chr(34)#' & '#GetJobs.ListElement#' &
'#chr(34)#, '>
Ricki
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 9:55 AM
Subject: Trying to ennumerate through fields in my table
> I'm attempting to create a routine to create a delimited ascci text file
from
> my table. I don't want to list every single field because there are so
many
> of them. I would like to be able to just loop through the fields,
> concatenate them into one string and write it. Assuming I can make this
work
> then I will be able to re-use this technique on any of my tables.
>
> If there is a way to reference the fields of a query by index that would
be
> best. Not knowing how to do that I have been attempting to use the list
of
> fields provided through ListElement and then to take the field name and
> reference the field that way. She's a not working.
>
> My code so far ...
> <CFLOOP QUERY="GetJobs">
> <CFIF #FileExists(OUTFILE)# is "No">
> <CFSET MyList=#GetJobs.ColumnList#>
> <!--- first line to contain field names--->
> <CFLOOP INDEX="ListElement" List="#MyList#">
> <CFSET TXTOUTPUT = TXTOUTPUT &
'#chr(34)##ListElement##chr(34)#,
> '>
> </CFLOOP>
> <CFFILE ACTION = "WRITE" FILE="#OUTFILE#" OUTPUT="#TXTOUTPUT#">
> <CFELSE>
> <CFLOOP INDEX="ListElement" List="#MyList#">
> <CFSET TXTOUTPUT= TXTOUTPUT & '#chr(34)#' &
> '#GetJobs.#ListElement##' & '#chr(34)#, '>
> </CFLOOP>
>
> <CFFILE ACTION = "APPEND" FILE="#OUTFILE#" OUTPUT="#TXTOUTPUT#">
> </CFIF>
> </CFLOOP>
>
> the code #GetJobs.#ListElement## in line 11 obviosuly doesn't work but I
have
> yet to figure out a way to substitute a variable as a field name .
>
> Help appreciated (It's a known fact that helping newbies gets you into
Heaven)
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
