Emmanuel
Master Tech
- Local time
- Today, 05:21
- Joined
- Sep 4, 2002
- Messages
- 88
Good day to all,
I am new to coldfusion programming, but I have done some web development with it in the past 6 months or so. Here is my issue.
I build online queries so that users in other departments can run their reports without the need to use any applications like Acces or Crystal. One problem I find is that when the copy and paste the values into Excel. Regardless of the formatting they do in Excel, they always get the "8.22E+15" instead of "82231300005548" which is the correct account number. One thing they can do is use the paste special and then convert text to columns, but when you are working with monkeys, you really want to give them something easy.
Here is my question... Is there a format commend to force text into a field even if the value is all number? Below you can find my code. Thanks in advance for your help.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>DVR Cleanup</title>
</head>
<body>
<cfquery datasource="division" name="DVR_Cleanup">
<cfinclude template="Assets/SQL/dvr_cleanup_SQL.cfm">
</cfquery>
<CENTER>
<TABLE BORDER>
<TR>
<TH ALIGN="CENTER" BGCOLOR="Silver">Account:</TH>
<TH BGCOLOR="Silver">Qty:</TH>
<TH BGCOLOR="Silver">Effect:</TH>
</TR>
<cfset txtColor= 'style="color:black"'>
<CFOUTPUT QUERY = "DVR_Cleanup">
<TR>
<--! The line below is the one I need to force to text... -->
<TD #txtColor#> #Accnt# </TD>
<TD #txtColor#> #qty# </TD>
<TD #txtColor#> #Effect# </TD> </TR>
</CFOUTPUT>
</TABLE>
</CENTER>
</body>
</html>
Best Regards,
Emmanuel
WebManny.com
I am new to coldfusion programming, but I have done some web development with it in the past 6 months or so. Here is my issue.
I build online queries so that users in other departments can run their reports without the need to use any applications like Acces or Crystal. One problem I find is that when the copy and paste the values into Excel. Regardless of the formatting they do in Excel, they always get the "8.22E+15" instead of "82231300005548" which is the correct account number. One thing they can do is use the paste special and then convert text to columns, but when you are working with monkeys, you really want to give them something easy.
Here is my question... Is there a format commend to force text into a field even if the value is all number? Below you can find my code. Thanks in advance for your help.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>DVR Cleanup</title>
</head>
<body>
<cfquery datasource="division" name="DVR_Cleanup">
<cfinclude template="Assets/SQL/dvr_cleanup_SQL.cfm">
</cfquery>
<CENTER>
<TABLE BORDER>
<TR>
<TH ALIGN="CENTER" BGCOLOR="Silver">Account:</TH>
<TH BGCOLOR="Silver">Qty:</TH>
<TH BGCOLOR="Silver">Effect:</TH>
</TR>
<cfset txtColor= 'style="color:black"'>
<CFOUTPUT QUERY = "DVR_Cleanup">
<TR>
<--! The line below is the one I need to force to text... -->
<TD #txtColor#> #Accnt# </TD>
<TD #txtColor#> #qty# </TD>
<TD #txtColor#> #Effect# </TD> </TR>
</CFOUTPUT>
</TABLE>
</CENTER>
</body>
</html>
Best Regards,
Emmanuel
WebManny.com
