How to preserve blank cells when exporting database

[brendanparker]

Hi CF forum,

I am VERY new to CF and I am working with a script which exports a database to an .xls file. It all works fine, but what I noticed is that in SOME cells (not all), it seems to skip over some of the data so I get this effect:

DIET	SPECIAL_NEED	TICKET	COST	ID
none		Regular	50	2A19B7EF
none		Regular	50	392DDDDF
none		Regular	50	8C6F0EA1
none		Regular	50	94A9CF7D
none		Regular	50	94AB5198
none		Regular	50	94B987B8
none		Regular	dontemail	50	94C439D1
none		Regular	50	94C99CA9

As you can see, my "dontemail" field seems to have skewed my table. This is data which doesn'tappear in all fields, but has a table name of "dontemail"which doesn't come through. It looks fine in the database, so all the data is where it's supposed to be, but it doesn't show up right on the export.

Here's the code which generates this:

<cfoutput>DATE/TIME ENTERED<cfloop list="#rsdata.fieldList#" index="c">#DelimChar##c#</cfloop>#NewLine#</cfoutput><cfoutput query="rsData"><cfsilent><cfwddx action="wddx2cfml" input="#rsdata.data#" output="info"></cfsilent>#rsdata.entered#<cfloop list="#rsdata.fieldList#" index="f">#DelimChar##fixDelim(info['#f#'])#</cfloop>#NewLine#</cfoutput><cfabort>

Any ideas?

Thanks,

Brendan