Prev: contextual advertising engine
Next: How to use Java threads in ColdFusion
From: kwaybe on 9 Apr 2008 08:47
Hello,

I have un very strange problem.

I have created un site with values of products in all European languages. The
user can select an language and the system export the result in Excel in the
selected language.

For informations, the Data's are saved in a Oracle Database.

Until last friday morning, all functions very well.
Since Friday afternoon, it is not more possible to export the data.

What happens:
If the user select Bulgarian, French, Greek, Italian, Lituanian, Latvia,
Maltese, Netherlands, Portugese, Slovakia, tcheck republic, : The system
doesn't export the result but it stay on the screen
http://hiboox.com/lang-fr/image.php?img=gfl6speu.jpg#

But, for the English, Dannish, Deutch, spannish, estonian, finnish, hungrian
and slovenian: The system export realy in Excel
http://hiboox.com/lang-fr/image.php?img=9veowx4p.jpg

Why ??? I don't known ! I don't understand.

Friday, I added some numbers only, no text in the data base.
I don't modify the site itself.

The most complicated of the situation, I have another page that displays the
same data but difently and there; all functions very well.

I'm lost ....

Any one can help me ????

I give you the code used:

Last point: The version of ColdFusion is 6.1

Question: For you: Where come from the problem?
a) from Oracle?
b) server ColdFusion?
c) application itself?
d) Excel?
e) other? ---> from where?

Thank you for advance

Andr�



<cfset session.bViewHeader = 0>
<cfset session.bViewFooter = 0>

<CFSETTING ENABLECFOUTPUTONLY="yes">
<CFSET TAB=CHR(9)>
<CFHEADER NAME="Content-Disposition" VALUE="inline; filename=pesticide.xls">

<cfswitch expression="#session.lg#">
<cfcase value="PT;SK" delimiters=";">
<CFCONTENT TYPE="application/msexcel;charset=utf-8">
</cfcase>
<cfcase value="BG;CS;EL;IT;FR;LT;LV;MT;NL;PL;RO;SL" delimiters=";">
<CFCONTENT TYPE="application/msexcel;charset=utf-16">
</cfcase>
<cfdefaultcase>
<CFCONTENT TYPE="application/msexcel">
</cfdefaultcase>
</cfswitch>

<cfoutput>
<table border="1">
<tr>
<th colspan="2" style="text-align:left
"><strong>#request.listeSusbtance.produit#</strong></th>
</tr>
<cfloop query="request.listeSusbtance">
<tr>
<td width="75%" style="width:70% ">#nom_substance#</td>
<td width="25%" style="width:10% ">#valeur#</td>
</tr>
</cfloop>
</table>
</cfoutput>

 | 
Pages: 1
Prev: contextual advertising engine
Next: How to use Java threads in ColdFusion