Re: Export to Excel Asian locale
looks fine in tbird 3.0 using utf-8. HoF's list archive doesn't seem to support unicode though. Yes, I was surprised when it did not display correctly on the list. -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
cfprocessingdirective pageencoding=utf-8 Thanks for that. I forgot to paste the directive. -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
Thank you both for sticking with this. Using your examples and playing around with the code i managed to get it going. Thanks again Victor On Sun, Dec 20, 2009 at 9:07 AM, Leigh cfsearch...@yahoo.com wrote: cfprocessingdirective pageencoding=utf-8 Thanks for that. I forgot to paste the directive. -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
On 12/20/2009 9:07 PM, Leigh wrote: cfprocessingdirective pageencoding=utf-8 Thanks for that. I forgot to paste the directive. in *this* case it wasn't actually required, basic knee-jerk reaction on my part. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
in *this* case it wasn't actually required, basic knee-jerk reaction on my part. Better safe that sorry. It did not actually work for me in Eclipse without the directive ;-) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
Hi Paul, I was hoping you will chime in as the coldfusion international guru. Unfortunately I had that font already and even tried different variations still the same result. I have tried with no font also hoping that will default to something that will display it properly with no luck. Just to recap: the web page shows double byte characters fine, using cfcontent to force excel to open it doesn't display them, but manually copying from the web form and pasting in Excel is fine. Have you tried to do this? I'm hoping is not a bug in cfcontent. Thanks On Fri, Dec 18, 2009 at 10:04 PM, Paul Hastings p...@sustainablegis.com wrote: On 12/19/2009 1:15 AM, Victor Moore wrote: I can't figure out how to do it. All the double byte characters show as squares (or funny characters if I remove squares (empty ones) usually mean that the app can't render those glyphs. either a small encoding error or it doesn't have the right font. try another font that contains those glyphs first (off the top of me head, i know of only arial unicode ms that contains both chinese korean, and pretty much everything else). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
Have you tried specifying the charset via meta tags (within the content)? cfcontent type=application/vnd.ms-excel; charset=utf-8 cfheader name=Content-Disposition charset=utf-8 value=inline; filename=inv.xls html meta http-equiv=Content-Type content=text/html; charset=utf-8 body æ¥æ¬èª: Java ãã©ãããã©ã¼ã ã«ãããè£å©æåã®ãµãã¼ã ä¸æ: Java å¹³å°ä¸çå¢è¡¥å符 /body /html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
æ¥æ¬èª: Java ãã©ãããã©ã¼ã ã«ãããè£å©æåã®ãµãã¼ã ä¸æ: Java å¹³å°ä¸çå¢è¡¥å符 Apparently those characters (snagged from sun's site) did not show up to well ... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
On 12/20/2009 2:17 AM, Victor Moore wrote: Unfortunately I had that font already and even tried different variations still the same result. if arial unicode ms is rendering as empty squares then it's probably an encoding issue. Just to recap: the web page shows double byte characters fine, using and what encoding is that page using? any chance you're using cffile along the way forgot to set the charset? double check your encoding from the db outwards. Have you tried to do this? I'm hoping is not a bug in cfcontent. don't do much work w/spreadsheets (well not in a long while anyway) but it should work fineplaying around w/your cfsearching's snippets it seems the key (provided the encoding is correct and note that i'm testing w/open office) is the meta http-equiv=Content-Type content=text/html; charset=utf-8 tag from leigh's snippet. removing/altering it's encoding, blows up the spreadsheet pretty good. following snippet is unicode (utf-8). cfprocessingdirective pageencoding=utf-8 cfcontent type=application/vnd.ms-excel; charset=utf-8 cfheader name=Content-Disposition charset=utf-8 value=inline; filename=inv.xls html meta http-equiv=Content-Type content=text/html; charset=utf-8 body table trtdConfirm Cash Deposit/tdtdç°éå款/td/tr trtdAccessing this function requires you to have an account./tdtdéä¸é è¦ä¸ä¸ªäº¤ææ·å£æè½ä½¿ç¨æ¤åè½ã/td/tr trtdAccount ID/tdtdè´¦æ·å·ç /td/tr trtdAccount Inaccessible/tdtdæ·å£ä¸è½ä½¿ç¨/td/tr /table /body /html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
On 12/20/2009 5:08 AM, Leigh wrote: æ¥æ¬èª: Java ãã©ãããã©ã¼ã ã«ãããè£å©æåã®ãµãã¼ã ä¸æ: Java å¹³å°ä¸çå¢è¡¥å符 looks fine in tbird 3.0 using utf-8. HoF's list archive doesn't seem to support unicode though. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Export to Excel Asian locale
Hi, Is it possible to export a form containing Chinese, Korean words to excel? I can't figure out how to do it. All the double byte characters show as squares (or funny characters if I remove ?xml version=1.0 encoding=UTF-8? !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN xhtml1/xhtml1-transitional.dtd html xmlns=http://www.w3.org/1999/xhtml; ) This is what I have: cfheader name=Content-Type charset=utf-8 value=application/vnd.ms-excel cfheader name=Content-Disposition charset=utf-8 value=inline; filename=inv.xls Any ideas? Thanks Victor ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel Asian locale
Does your OS that opens the excel file have the support for double byte characters? In windows I think it is under regions and languages. You should google support for double byte characters on your OS. I found this real quick: http://mandarin.about.com/od/characters/ss/display_chars.htm -Original Message- From: Victor Moore [mailto:victor.mo...@gmail.com] Sent: Friday, December 18, 2009 1:15 PM To: cf-talk Subject: Export to Excel Asian locale Hi, Is it possible to export a form containing Chinese, Korean words to excel? I can't figure out how to do it. All the double byte characters show as squares (or funny characters if I remove ?xml version=1.0 encoding=UTF-8? !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN xhtml1/xhtml1-transitional.dtd html xmlns=http://www.w3.org/1999/xhtml; ) This is what I have: cfheader name=Content-Type charset=utf-8 value=application/vnd.ms-excel cfheader name=Content-Disposition charset=utf-8 value=inline; filename=inv.xls Any ideas? Thanks Victor ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Export to Excel Asian locale
Data is displayed OK on the page. it's just in the excel file that is not showing properly, but if I cut and paste manually in the excel file then it shows OK. Thanks On Fri, Dec 18, 2009 at 1:51 PM, Chad Gray cg...@careyweb.com wrote: Does your OS that opens the excel file have the support for double byte characters? In windows I think it is under regions and languages. You should google support for double byte characters on your OS. I found this real quick: http://mandarin.about.com/od/characters/ss/display_chars.htm -Original Message- From: Victor Moore [mailto:victor.mo...@gmail.com] Sent: Friday, December 18, 2009 1:15 PM To: cf-talk Subject: Export to Excel Asian locale Hi, Is it possible to export a form containing Chinese, Korean words to excel? I can't figure out how to do it. All the double byte characters show as squares (or funny characters if I remove ?xml version=1.0 encoding=UTF-8? !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN xhtml1/xhtml1-transitional.dtd html xmlns=http://www.w3.org/1999/xhtml; ) This is what I have: cfheader name=Content-Type charset=utf-8 value=application/vnd.ms-excel cfheader name=Content-Disposition charset=utf-8 value=inline; filename=inv.xls Any ideas? Thanks Victor ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Excel Asian locale
On 12/19/2009 1:15 AM, Victor Moore wrote: I can't figure out how to do it. All the double byte characters show as squares (or funny characters if I remove squares (empty ones) usually mean that the app can't render those glyphs. either a small encoding error or it doesn't have the right font. try another font that contains those glyphs first (off the top of me head, i know of only arial unicode ms that contains both chinese korean, and pretty much everything else). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Best method for Export to Excel...
Hey all, I've got lots of ideas. done this a million times. but wanted to just check in with the crowd to see if maybe I've missed something new etc. I've got about 20k records in a sql 2005 DB table which i need to dump to an excel file on demand for users. Basically inside a cfthread tag I'm grabbing the 20k records from a web service, dumping them into a table, and then need to go from that table to an excel file and email / provide a download link for the end user. Best practices? super duper suggestions? thanks in advance! jonese http://www.jonese.us http://twitter.com/jonese ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best method for Export to Excel...
IMHO: Ben Nadel's POI utility: http://www.bennadel.com/projects/poi-utility.htm Is the best choice, it has saved me a hundred times. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best method for Export to Excel...
With 20,000 records, do you actually need to create it on-demand for each user? Can you have a scheduled task rebuild the .xls file every so often? If that would work, then you could just have SSIS dump the .xls file on your web server. This would take CF completely out of the process. m!ke -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 10:09 AM To: CF-Talk Subject: Best method for Export to Excel... Hey all, I've got lots of ideas. done this a million times. but wanted to just check in with the crowd to see if maybe I've missed something new etc. I've got about 20k records in a sql 2005 DB table which i need to dump to an excel file on demand for users. Basically inside a cfthread tag I'm grabbing the 20k records from a web service, dumping them into a table, and then need to go from that table to an excel file and email / provide a download link for the end user. Best practices? super duper suggestions? thanks in advance! jonese http://www.jonese.us http://twitter.com/jonese ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best method for Export to Excel...
+1 to POI. jXLS is also nice if you need templating. But +2 to SSIS (or similar). CF as a data pump just does not scale. Jaime -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, 19 August 2008 1:56 AM To: CF-Talk Subject: RE: Best method for Export to Excel... With 20,000 records, do you actually need to create it on-demand for each user? Can you have a scheduled task rebuild the .xls file every so often? If that would work, then you could just have SSIS dump the .xls file on your web server. This would take CF completely out of the process. m!ke -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 10:09 AM To: CF-Talk Subject: Best method for Export to Excel... Hey all, I've got lots of ideas. done this a million times. but wanted to just check in with the crowd to see if maybe I've missed something new etc. I've got about 20k records in a sql 2005 DB table which i need to dump to an excel file on demand for users. Basically inside a cfthread tag I'm grabbing the 20k records from a web service, dumping them into a table, and then need to go from that table to an excel file and email / provide a download link for the end user. Best practices? super duper suggestions? thanks in advance! jonese http://www.jonese.us http://twitter.com/jonese ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Export to Excel and PDF from the Spry Filtered Data Set??
Is there a way to go about exporting to PDF and Excel from the Spry Filtered Data Set? I am not sure how to go about doing that from my Search output, which is Spry filtered XML Data Set Thanks. Elena. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
export to Excel
I need to export query results and graph objects to excel. the spreadsheet is no big deal, however, I've never created a graph from coldFusion to Excel. I would like to know what all of you advise. Also what is the best custom tag (if any) for this? Thanks KES ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF5 / SQL 2000 Export to Excel
I have exported the data that I need using the SQL export tool but what I am trying to accomplish is an Excel file for Froogle I need one field as a URL. Is there a way to have SQL or CF version 5 - or combination of both - export my productid field as a URL instead of just the productid alone? Any help or suggestions would be appreciated. TIA, -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF5 / SQL 2000 Export to Excel
Do you mean the productid should be part of a standard URL? If so: SELECT 'http://www.domain.com/page.cfm?id=' + id AS myURL FROM TableName Depending on your database, you may need a different operator, other than the plus (+) sign. Some DBs use pipes (|), some use functions (Concat()). M!ke -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 2:22 PM To: CF-Talk Subject: CF5 / SQL 2000 Export to Excel I have exported the data that I need using the SQL export tool but what I am trying to accomplish is an Excel file for Froogle I need one field as a URL. Is there a way to have SQL or CF version 5 - or combination of both - export my productid field as a URL instead of just the productid alone? Any help or suggestions would be appreciated. TIA, -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF5 / SQL 2000 Export to Excel
Yes, the productid should be part of a standard URL. I'm using SQL 2000 and getting an error message saying it can't convert the var of the URL to an int. Any pointers? Thank you! ~ Donna Do you mean the productid should be part of a standard URL? If so: SELECT 'http://www.domain.com/page.cfm?id=' + id AS myURL FROM TableName Depending on your database, you may need a different operator, other than the plus (+) sign. Some DBs use pipes (|), some use functions (Concat()). M!ke -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 2:22 PM To: CF-Talk Subject: CF5 / SQL 2000 Export to Excel I have exported the data that I need using the SQL export tool but what I am trying to accomplish is an Excel file for Froogle I need one field as a URL. Is there a way to have SQL or CF version 5 - or combination of both - export my productid field as a URL instead of just the productid alone? Any help or suggestions would be appreciated. TIA, -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF5 / SQL 2000 Export to Excel
It seems that your destination field is expecting an INT. But, if you are using Excel as the destination, it shouldn't matter. Then, maybe it has to do with your concatenation. You may need to CAST/CONVERT your productID to a char value before you concatenate it to the URL. Something like: SELECT 'http://www.domain.com/page.cfm?id=' + CAST(productID AS char(10)) AS myURL FROM TableName This will get the productID to work as a character value. It is possible that SQL Server was trying to add the URL to your product ID rather than just append the product ID to the URL. M!ke -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 1:45 PM To: CF-Talk Subject: Re: CF5 / SQL 2000 Export to Excel Yes, the productid should be part of a standard URL. I'm using SQL 2000 and getting an error message saying it can't convert the var of the URL to an int. Any pointers? Thank you! ~ Donna Do you mean the productid should be part of a standard URL? If so: SELECT 'http://www.domain.com/page.cfm?id=' + id AS myURL FROM TableName Depending on your database, you may need a different operator, other than the plus (+) sign. Some DBs use pipes (|), some use functions (Concat()). M!ke -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 2:22 PM To: CF-Talk Subject: CF5 / SQL 2000 Export to Excel I have exported the data that I need using the SQL export tool but what I am trying to accomplish is an Excel file for Froogle I need one field as a URL. Is there a way to have SQL or CF version 5 - or combination of both - export my productid field as a URL instead of just the productid alone? Any help or suggestions would be appreciated. TIA, -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Export to Excel
Any recomanded tag to export the html result to excel sheet? preferably free tag. thanks PS: Second attempt. I post this message yesterday from the website, didn't showed up, tried again from website didn't comes up either. now sending through email. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191814 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Export to Excel
I you are on MX then use this... http://jakarta.apache.org/poi/index.html its free and is the mutts nuts -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 15:29 To: CF-Talk Subject: Export to Excel Any recomanded tag to export the html result to excel sheet? preferably free tag. thanks PS: Second attempt. I post this message yesterday from the website, didn't showed up, tried again from website didn't comes up either. now sending through email. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191816 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Export to Excel
I generally just generate an HTML page and place the data in a HTML table. Give it a .xsl extention and hand it back with a content disposition header: cfheader name=Content-Type value=application/x-msexcel; charset=UTF-8 cfheader name=Content-Disposition value=myExcelFile.xls That works in Excel 98 and up, I believe. There's also a custom tag in the OpenXCF project. The custom tag is called cfx_excelquery. I haven't used it, but I believe quite a few people have: http://openxcf.sourceforge.net/ Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 10:29 AM To: CF-Talk Subject: Export to Excel Any recomanded tag to export the html result to excel sheet? preferably free tag. thanks PS: Second attempt. I post this message yesterday from the website, didn't showed up, tried again from website didn't comes up either. now sending through email. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Export to Excel
I just need the simple excel output. This is what I am using and no error and no excel file. meta http-equiv=pragma content=no-cache cfheader name=Content-Type value=application/x-msexcel; charset=UTF-8 cfheader name=Content-Disposition value=MyExcel.xls thanks PS: Again no result if I post from website, I am again using my email to post the message. On Wed, 26 Jan 2005 10:28:56 -0500, Asim Manzur [EMAIL PROTECTED] wrote: Any recomanded tag to export the html result to excel sheet? preferably free tag. thanks PS: Second attempt. I post this message yesterday from the website, didn't showed up, tried again from website didn't comes up either. now sending through email. -- Regards, Asim Manzur http://www.LogikZone.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191835 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Export to Excel
This is very cool, but it lacks the ability to lock cells which I needed for a recent project. I also needed conditional formatting to quickly show where information needed to be entered. I wish the API would have had this functionality, but it didn't. Therefore, I created the spreadsheet as I needed for the final output. Then, I saved as HTML and found everything I needed. However, either method is great. Each has their own quirks. M!ke -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 9:28 AM To: CF-Talk Subject: RE: Export to Excel I you are on MX then use this... http://jakarta.apache.org/poi/index.html its free and is the mutts nuts -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 15:29 To: CF-Talk Subject: Export to Excel Any recomanded tag to export the html result to excel sheet? preferably free tag. thanks PS: Second attempt. I post this message yesterday from the website, didn't showed up, tried again from website didn't comes up either. now sending through email. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191839 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Export to Excel ok, PDF not ok
Sorry, the msg were not clear enough, following is my editing. It seems strange, the following code would work to export current page to Excel format but not PDF format (though a pdf doc is generated, its format seems incorrect for PDF reader failed to open it). Code for exporting to Excel: cfheader name=Content-Disposition value=attachment;filename=file123.xls cfcontent type=application/msexcel Code for exporting to PDF: cfheader name=Content-Disposition value=attachment;filename=file123.pdf cfcontent type=application/pdf (content to be exported or included in the desired format) dynamic page data in HTML table format. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Export to Excel ok, PDF not ok
This isn't going to work... You code for exporting to excel only works because Excel knows how to deal with HTML data; the PDF viewer does not know how to deal with HTML and it fails.To the best of my knowledge, changing headers, etc won't make a difference. -Original Message- From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 10:35 AM To: CF-Talk Subject: Re: Export to Excel ok, PDF not ok Sorry, the msg were not clear enough, following is my editing. It seems strange, the following code would work to export current page to Excel format but not PDF format (though a pdf doc is generated, its format seems incorrect for PDF reader failed to open it). Code for exporting to Excel: cfheader name=Content-Disposition value=attachment;filename=file123.xls cfcontent type=application/msexcel Code for exporting to PDF: cfheader name=Content-Disposition value=attachment;filename=file123.pdf cfcontent type=application/pdf (content to be exported or included in the desired format) dynamic page data in HTML table format. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to Excel ok, PDF not ok
Try this site http://www.school-for-champions.com/coldfusion/cftopdf.htm Or use a program like CFXPDF by http://www.easel2.com, DynamicPDF byhttp://gilgamesh-solutions.com/products.cfm#p1 (Must have cfExecute turned on to use this product.) or ActivePDF http://www.activepdf.com/Pricy This isn't going to work... You code for exporting to excel only works because Excel knows how to deal with HTML data; the PDF viewer does not know how to deal with HTML and it fails.To the best of my knowledge, changing headers, etc won't make a difference. -Original Message- From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 10:35 AM To: CF-Talk Subject: Re: Export to Excel ok, PDF not ok Sorry, the msg were not clear enough, following is my editing. It seems strange, the following code would work to export current page to Excel format but not PDF format (though a pdf doc is generated, its format seems incorrect for PDF reader failed to open it). Code for exporting to Excel: cfheader name=Content-Disposition value=attachment;filename=file123.xls cfcontent type=application/msexcel Code for exporting to PDF: cfheader name=Content-Disposition value=attachment;filename=file123.pdf cfcontent type=application/pdf (content to be exported or included in the desired format) dynamic page data in HTML table format. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to Excel ok, PDF not ok
This isn't going to work... You code for exporting to excel only works because Excel knows how to deal with HTML data; the PDF viewer does not know how to deal with HTML and it fails.To the best of my knowledge, changing headers, etc won't make a difference. Thanks, good to know. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to Excel ok, PDF not ok
Try this site http://www.school-for-champions.com/coldfusion/cftopdf.htm Thanks, will revisit it when I got time to work on the conversion. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Export to Excel ok, PDF not ok
It seems strange, the following code would work to export current page to Excel format but not PDF format (though a pdf doc is generated, its format seems incorrect for PDF reader failed to open it). Code: cfheader name=Content-Disposition value=attachment;filename=file123.xls cfcontent type=application/msexcel dynamic page data in HTML table format. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Why Will this not export to Excel
When i run this page it just pulls up the page as though cfcontent was not even there. What have I done wrong? ... !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN ... html head titleUntitled/title link rel=STYLESHEET type=text/css href=""> /head body cfcontent type=application/x-msexcel If you include HTML tags, or any other undesired stuff, before your CFCONTENT tag, it's not going to work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[EMAIL PROTECTED]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Export to Excel - only alternate rows exported WHy?...
I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Can you view the output before passing it to the custom tag? If not can you replicate the code in the custom tag which creates the table and view the html generated? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:39 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Can view the output before passing it to the custom tag. The query which generates the data is an include file as below.When I view the include file the data is all correct. But when I view the output using the tag it only returns every second row. cf_html2Excel sheetname=report Directory=#thedirectory#\exceltemp\ CFSET EXCEL=1 -- cfinclude template=high_grade_excel.cfm /CF_HTML2Excel CFHEADER NAME=Content-Disposition VALUE=inline;filename=customsearch.xls CFCONTENT TYPE=application/unknown FILE=#ExcelFile# DELETEFILE=Yes -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 01:12 PM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Can you view the output before passing it to the custom tag? If not can you replicate the code in the custom tag which creates the table and view the html generated? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:39 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Declan try it with another query and see if you get the same result. Also can you look at the source of the html generated and see if its formatted correctly (i.e. no missing tr tags etc.) . Finally is there any styling applied to the table? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 15:10 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Can view the output before passing it to the custom tag. The query which generates the data is an include file as below.When I view the include file the data is all correct. But when I view the output using the tag it only returns every second row. cf_html2Excel sheetname=report Directory=#thedirectory#\exceltemp\ CFSET EXCEL=1 -- cfinclude template=high_grade_excel.cfm /CF_HTML2Excel CFHEADER NAME=Content-Disposition VALUE=inline;filename=customsearch.xls CFCONTENT TYPE=application/unknown FILE=#ExcelFile# DELETEFILE=Yes -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 01:12 PM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Can you view the output before passing it to the custom tag? If not can you replicate the code in the custom tag which creates the table and view the html generated? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:39 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export To excel
Try something like this instead: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=yourfile.xls CFCONTENT TYPE=application/excel Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Export To excel
I am running cf 5 and when I use the following cf content around my code all that is returned is a page formatted for excel. Why does it not ask me to download the file or open the file in excel on my machine? Josh cfcontent type=application/msexcel __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Why Will this not export to Excel
When i run this page it just pulls up the page as though cfcontent was not even there. What have I done wrong? ... !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN ... html head titleUntitled/title link rel=STYLESHEET type=text/css href=css/vacation.css /head body cfcontent type=application/x-msexcel If you include HTML tags, or any other undesired stuff, before your CFCONTENT tag, it's not going to work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Why Will this not export to Excel
When i run this page it just pulls up the page as though cfcontent was not
even there. What have I done wrong?
Josh
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
cfquery name=qryGETMTHS
datasource=0424_SQL_REGION_VACATION
dbtype=ODBC
username=
password=
SELECT month, rtrim(colspan) as col, bgcolor
from tblMONTHS
/cfquery
cfquery name=qryGETSUPS
datasource=0424_SQL_REGION_VACATION
dbtype=ODBC
username=
password=
SELECT supid, supname, rr, dd, supemail, dept
from tblSUPS
where supid = '#supid#'
/cfquery
cfquery name=qryGETUSERS
datasource=0424_SQL_REGION_VACATION
dbtype=ODBC
username=
password=
SELECT distinct tblusers.fname, tblusers.lname, rtrim(tblUSERS.fname+ ' '
+ tblUSERS.lname) as name, tblusers.id, dateofhire, wksvac, ssno
FROM tblusers
wheretblusers.supgroup = '#supid#' and active = '1'
order by dateofhire
/cfquery
cfquery name=qryGETVACATIONS
datasource=0424_SQL_REGION_VACATION
dbtype=ODBC
username=
password=
SELECT distinct tblVACATIONS.we_date, tblvacations.tblusersid, approved
FROM {oj dbo.tblUSERS RIGHT OUTER JOIN dbo.tblVACATIONS ON
dbo.tblUSERS.id = dbo.tblVACATIONS.tblusersid}
WHEREtblvacations.we_date is not NULL and active = '1' and
datepart(, tblvacations.we_date) = '#year#'
/cfquery
html
head
titleUntitled/title
link rel=STYLESHEET type=text/css href=css/vacation.css
/head
body
cfcontent type=application/x-msexcel
cfset vari = dateformat(now(), )
cfset year = vari + 1
cfset NewYears = DayOfWeek(01/01/#year#)
cfset FirstWeekEnd = (7 - NewYears)
cfset NewYears1 = DayOfWeek(1/1/#Year#)
cfset FirstWeekEnd1 = (6 - NewYears1)
cfset listFirstHalf =
cfset listSecondHalf =
cfloop index=saturday from=#firstWeekEnd1# to=#DaysInYear(Year)#
step=7
cfset thisDate1 = DateAdd(d,saturday,1/1/2001)
cfif month(thisDate1) lt 7
cfset listFirstHalf = listAppend(listFirstHalf, thisDate1)
cfelse
cfset listSecondHalf = listAppend(listSecondHalf, thisDate1)
/cfif
/cfloop
table align=center
tr
td align=center class=tdheader0cfoutput
query=qryGETSUPS#supname# / #rr##dd# / #dept#/cfoutput/td
/table
/tr
table border=1 cellspacing=0 align=center
tr td rowspan=2
align=centercfoutput#year#/cfoutput/td
td rowspan=2 align=centerSocial/td
cfoutput query=qryGETMTHS
td colspan=#col# align=center bgcolor=#bgcolor#
class=tdheader#month#/td
/cfoutput
td rowspan=2Wks. Allowed/td
/tr
tr
cfloop index=saturday from=#firstWeekEnd# to=#DaysInYear(year)#
step=7
cfset thisDate = DateAdd(d,saturday,1/1/#year#)
cfoutputtd align=center class=tdheader1#dateformat(thisdate,
dd)#/td/cfoutput/cfloop
/tr
cfoutput
cfLOOP query=qryGETUSERS
cfset curid = #id#
tr
cfif client.user_level eq 5
td align=center class=tdheader5a
href=update.cfm?empid=#curid##name#br#dateformat(dateofhire,
mm/dd/yy)#/a/td
cfelse
td align=center
class=tdheader5#name#br#dateformat(dateofhire,
mm/dd/yy)#/td
td align=center class=tdheader5#qryGETUSERS.ssno#/td
/cfif
cfloop index=saturday from=#firstWeekEnd#
to=#DaysInYear(year)#
step=7
cfset thisDate = DateAdd(d,saturday,1/1/#year#)
cfloop query=qryGETVACATIONS
CFIF (#thisdate# eq
#qryGETVACATIONS.we_date#) and
(#qrygetvacations.tblusersid# eq #curid#)
CFSET box = font
size=2strongX/strong/font
CFSET ischecked=checked
cfif approved eq 'Yes'
CFSET cellcolor=Orange
cfelse
cfset cellcolor=red
/cfif
CFBREAK
cfelse
cfset box = nbsp;
cfset ischecked=
CFSET cellcolor=Gray
/CFIF
/cfloop
cfif isdefined(cellcolor)
cfelse
cfset
