cfsavecontent Situation

[apocalipsis19]

Hello Community!

I am writing an export and I am using cfsavecontent to save the values of my main query in a variable.

Let's say that I have first_name|last_name|address <This is where I need to break and move to the next line>

I am using #chr(13)#&#chr(10)# inside the cfsavecontent but the enter is being ignored!

Any thoughts?

P.S: Ian and Adam helped out a lot when I was first creating this export file.

Thanks!

Ysais.

[Newsgroup_User]

apocalipsis19 wrote:

>
> Any thoughts?
>
Show some code.

I've never had #chr(13)#&#chr(10)# ignored when they where not supposed
to be ignored.

So without seeing your code, I don't have time to imagine what you could
possible be doing that is so different then the expected way things are
done.

[apocalipsis19]

Here you go:

<cfsavecontent variable="fileContent">
<cfloop index="idx" from="1" to="#getFields.recordcount#">
<cfoutput> #Trim(getFields.email[idx])#|#Trim(getFields.firstname[idx])#|#Trim(getFields.lastname[idx])#|#Trim(getFields.postalcode[idx])#|#Trim(getFields.campaign[idx])#|#DateFormat(getFields.firstordd[idx],'MM/DD/YYYY')#|#getFields.firstordamt[idx]#|#DateFormat(getFields.lastordd[idx],'MM/DD/YYYY')#|#getFields.lastordamt[idx]#|#getFields.htdordcnt[idx]#|#getFields.htdordtot[idx]#|#getFields.annualordcnt[idx]#|#getFields.annualordtot[idx]##Chr(13)##Chr(10)#
</cfoutput>
</cfloop>
</cfsavecontent>

[Newsgroup_User]

apocalipsis19 wrote:
> Here you go:
>

Nothing *obviously* out of place there, before I go digging hard, define
'ignored'. How are you experiencing these returns being ignored?

[apocalipsis19]

Well, simple, I want my data to be put into the file in the format:

field1|field2|field3
field1|field2|field3
field1|field2|field3
field1|field2|field3

But my code is generating my data like this:
field1|field2|field3field1|field2|field3field1|field2|field3field1|field2|field3field1|field2|field3

As you can see the line is not braking.

Thank a lot Ian!

Ysais.

[JR__Bob__Dobbs-qSBHQ2]

What application are you using to view the generated file?

[Newsgroup_User]

apocalipsis19 wrote:
> But my code is generating my data like this:
>
> field1|field2|field3field1|field2|field3field1|field2|field3field1|field2|field3
> field1|field2|field3
>

JR Bob Dobbs wrote:
> What application are you using to view the generated file?

To leap forward a bit on where I was trying to lead you and JR caught on
to, *IF* you are looking at your data in a browser as HTML that is what
you are going to see.

HTML - by definition - ignores line feeds and carriage returns and most
other white space characters. So if that is the case, your output is
probably exactly correct and is behaving as it should for the way you
are viewing it.

*IF* that is what you are seeing in the file once it is written and you
view it with some simple text editor or in some manner that does not
ignore white space, then yes, you have some strange behavior going on.

[JR__Bob__Dobbs-qSBHQ2]

Please post your code.

[apocalipsis19]

I just dumped my variable into the browser, you know the variable that contains the data.

[JR__Bob__Dobbs-qSBHQ2]

A web browser will usually not display a line break as a line break, it expects a <br> tag instead.

If you save your fileContent variable to a text file using CFFILE and open this file in a text editor does your content look as expected?

[apocalipsis19]

You are so right JR! I got it!

Thanks Ian and JR!

[Newsgroup_User]

apocalipsis19 wrote:
> I just dumped my variable into the browser, you know the variable that contains the data.

I just replied that if you do this, that is how your data is going to
look. HTML by definition ignores line feed and carriage returns.

You need to dump your variable between a set of <pre>...</pre> tags that
tell HTML to *not* ignore these characters OR write the file out and
look at it that way.

[apocalipsis19]

Ok, guys, so let met change the question.

The generated file is 30 megabytes, 300,000 lines.

I need to ftp it and I got the exception:

'putFile operation exceeded timeout'

Have you run into something similar? I already have this: <cfsetting requesttimeout="532000">

[apocalipsis19 · Accepted solution]

I found something useful in here:
http://www.bennadel.com/index.cfm?dax=blog:1337.view

[JR__Bob__Dobbs-qSBHQ2]

I'd use the export tools designed for my database rather then CF for creating large files or doing other work with large numbers of records.

For example Microsoft SQL Server includes the "Integration Services" feature for this kind of use.
http://www.microsoft.com/sqlserver/2008/en/us/integration.aspx

[apocalipsis19]

Thank you JR and Ian!

I appreciate your time and kindness!

Ysais.