RE: Exporting from ColdFuion to a Excel file
You can write it into a table format and then save the file to the server as an '.xls' file. Then create a dynamic link to download that file from the server. Ben's method, if it works for you, is better though. -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 7:51 PM To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file William, Sorry for not being more descriptive. I just need to export a really basic query from SQL to Excel. It only has like for fields and no formulas. Thanks __ Steve Sequenzia Thinksys Incorporated 1613 E Livingston St Orlando, FL 32803 866.633.3000 x305 407.459.1305 Direct 866.892.3000 Help Desk 407.895.3338 Fax -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 10:29 PM To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file Steve, Like skinning a cat, there are several ways to have a web document end up in Excel. Can you describe your scenario? What are you trying to accomplish? William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 7:11 PM To: CF-Talk Subject: Exporting from ColdFuion to a Excel file Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 Issue with CFFTP
you can use http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform I guess! anyways i have logged the bug for you . Fix should be available in updater ~chandan ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Making advanced search options for a database using CF8
Hi: I am working on a project which its main idea is, making a dynamic website contanins the basic information about certain companies and gives the users advanced search option through the database. The basic options will be free (all companies can add their info) but when a company pays the price it will appear at the top of the result page. It will be made by CF8 and MSSQL 2000. Now my questions are: Is there any example out there that I can modfy my idea with. Free/Trial. What do you suggest as the search method? I use the basic SQL filtering? Or you suggest something new? And finally, is there any tutorial helps me through the developing proccess. Thanks Benign ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Encoding for cfmail containing japanese character problem
I just installed CF8 developer... and have some encoding problem when sending mailing list in utf-8 format. I had put these in my page. cfcontent type=text/html; charset=utf-8 cfprocessingdirective pageencoding=utf-8 also... I have these... cfmail query=mailinglist to=#email# from=webmaster subject=#subject# CFMAILPARAM NAME=MIME-Version VALUE=1.0 CFMAILPARAM NAME=Content-Type VALUE=text/plain; charset=utf-8 #TextMessage(content)# /cfmail Problem : - some recipient (around 20% from 20.000 user) report.. they receive MOJIBAKE (garbage character)... mostly... they receive like this (in the subject) = ?UTF-8?B?UlRORVdTIFZvbCAxMzIp? = or.. =?utf-8?Q?=E3=82=A2=E3=83=BB=E3=82=B9=E3=83=9... And.. mostly.. who receive this mojibake character.. is customer who use yahoo.bb , msn, or Handphone email. Note : Before... on CF5 server.. I used shift_JIS.. and there was NO (or very little) problem. - Can anybody tell me... how to fix this ? - What is those MIME-Version Value=1.0 means ? Thanks. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ObjectBreeze VS. Transfer
Hi, I want to build a small CMS with an ORM tool. It has a small relational database. I found two ORM tools, which I liked when reading the documentation. 1. Objectbreeze: very very very simple, it has relationships on the fly. 2. Transfer: simple, a bit more complicated but nothing I cant handle. What are your experiences with those two ORM tools? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ObjectBreeze vs. Transfer
Hi, I want to build a small CMS with an ORM tool. It has a small relational database. I found two ORM tools, which I liked when reading the documentation. 1. Objectbreeze: very very very simple, it has relationships on the fly. 2. Transfer: simple, a bit more complicated but nothing I cant handle. What are your experiences with those two ORM tools? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
objectBreeze vs Transfer
Hi, I want to build a small CMS with an ORM tool. It has a small relational database. I found two ORM tools, which I liked when reading the documentation. 1. Objectbreeze: very very very simple, it has relationships on the fly. 2. Transfer: simple, a bit more complicated but nothing I cant handle. What are your experiences with those two ORM tools? ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Making advanced search options for a database using CF8
Ali, I'm not trying to be snippy, but you broke a few cardinal rules when asking for help: 1) your 1st question is not really a specific question, it sounds more like you want someone to do your research for you and you don't want to have to do anything at all. When asking on a board like this, you will most often get better results with a specific technical question. 2) you re-posted your question a second time after waiting only 3 minutes for a response. Most folks will look at that, and simply delete it from their inbox. Post your question and be patient, remember you are asking someone else for help and you are at their good graces for assistance ;) There were a lot of results for a google search on how to build a search engine using Verity and Coldfusion: http://www.google.com/search?hl=ensafe=offclient=firefox-arls=org.moz illa%3Aen-US%3Aofficialhs=Z0yq=how+to+build+a+search+with+coldfusion+a nd+verity+coldfusion+8btnG=Search There are also basic tutorials for building Coldfusion based apps: http://www.google.com/search?hl=ensafe=offclient=firefox-arls=org.moz illa%3Aen-US%3Aofficialhs=QLeq=build+first+coldfusion+applicationbtnG =Search I suggest you do some research and come back with some specific questions. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 8:56 AM To: CF-Talk Subject: Making advanced search options for a database using CF8 Hi: I am working on a project which its main idea is, making a dynamic website contanins the basic information about certain companies and gives the users advanced search option through the database. The basic options will be free (all companies can add their info) but when a company pays the price it will appear at the top of the result page. It will be made by CF8 and MSSQL 2000. Now my questions are: Is there any example out there that I can modfy my idea with. Free/Trial. What do you suggest as the search method? I use the basic SQL filtering? Or you suggest something new? And finally, is there any tutorial helps me through the developing proccess. Thanks Benign ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFGRID Select Row
well, the full local docs are at {cfwebroot}/CFIDE/scripts/ajax/ext/docs/ they are frames-based, like the online ones, and i pasted the link to the actual info frame only. in the full docs interface, expand API Reference - Ext - grid to get to the main grid section hth Azadi Saryev Sabai-dee.com Dale Fraser wrote: That link to the docs is great, I've looked at the Ext docs previously, and im doing something dumb as I have no idea how you managed to navigate to get that page. The previous page has that getSelectionModel, but there doesn't appear to be any links taking you to the objects' page that you posted here. Regards Dale Fraser http://learncf.com -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 October 2007 10:40 PM To: CF-Talk Subject: Re: CFGRID Select Row simple as everything ajax seems to be: refreshgrid = function(){ ColdFusion.Grid.getGridObject('yourgridname').getSelectionModel().selectRow( rownumber); } NOTE: rownumbers seem to be 0-based you can also use: selectRows() selectRange() clearSelections() and a lot more... more info @ {cfwebroot}/CFIDE/scripts/ajax/ext/docs/output/Ext.grid.RowSelectionModel.ht ml Azadi Saryev Dale Fraser wrote: Anyone know how to programmatically select a row in a grid. Sometimes you want to refresh the grid and then upon refresh select a specific row. Regards Dale Fraser http://learncf.com ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Value concatenation
I'm not totally following your question or where the error is from, but is the DocID in both the form action and hidden input? I'm unable to locate where the values concatenate. When I click on the button twice, I get the following error msg, Returns the value, 16,16. I'm not sure what I'm doing wrong?? Can someone please help? Thanks! cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex# cfelseif parameterexists(URL.startindex) cfset startnum = #URL.startindex# cfelse cfset startnum=1 /cfif cfset count = 0 cfoutput query=getdocs cfset count=#count#+1 /cfoutput cfoutput cfset endnum = #startnum# +14 cfif #endnum# GT #count# cfset endnum = #count#/cfif cfset prev=#startnum# - 15 cfset next=#endnum# +1 cfset reccount = #startnum# - 1 cfoutput query=getdocs maxrows=15 startrow=#startnum# cfset reccount = #reccount# +1 p align=left !---b#reccount#.nbsp;/b--- cfif #getdocs.deptRestriction# EQ 0 OR #session.deptID# NEQ #getdocs. deptRestriction# a href=#docstorage#/#docName# target=_blankb#docTitle#/b /a cfelse b#docTitle# (Secured Document) /b /cfif font size=-2Date: #DateFormat(lastupdate, MM/DD/YY)# Rev ##: cfif #revision# is 0Initialcfelse#revision#/cfif nbsp;nbsp;nbsp;nbsp;nbsp;/font font size=-1brb#docNumber#/bbr/font font size=-2Summary: i#Left(summary, 125)# nbsp;nbsp;nbsp;(a href=../docs/view.cfm?docID=#docID#see more/a)/i/font cfif ActionType NEQ 'R' cfform action=../docs/docActionLog.cfm?#CGI.QUERY_STRING# !--- cfif #startnum# GTE 15 --- input type=hidden name=hello value=#startnum# !--- cfelseif #count# GTE #next# input type=hidden name=next value=#startnum# --- !--- /cfif --- input type=hidden name=DocName value=#docName# input type=hidden name=DocID value=#DocID# input type=hidden name=DocAction value=R input type=submit value=I have reviewed and understand this document /cfform /cfif /p /cfoutput ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can a ColdFusion application see what processes are scheduled?
I don't believe that cfschedule is the tag for the job. CFschedule lets you schedule, run or delete events. What events are currently scheduled are not accessible by cfschedule. I took a look at the administrator API's in webroot/cfide/adimapi and checked the descriptions of them but I didnt see any methods available to get the scheduled events. You may want to look again yourself I didnt look at every cfc in the directory but if its there you should be able to do it, provided your sandbox security allows it. Regards, -- Gary Gilbert http://www.garyrgilbert.com/blog ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can a ColdFusion application see what processes are scheduled?
Could try using the service factory to get a list of them: http://tutorial475.easycfm.com/ On 10/12/07, gary gilbert [EMAIL PROTECTED] wrote: I don't believe that cfschedule is the tag for the job. CFschedule lets you schedule, run or delete events. What events are currently scheduled are not accessible by cfschedule. I took a look at the administrator API's in webroot/cfide/adimapi and checked the descriptions of them but I didnt see any methods available to get the scheduled events. You may want to look again yourself I didnt look at every cfc in the directory but if its there you should be able to do it, provided your sandbox security allows it. Regards, -- Gary Gilbert http://www.garyrgilbert.com/blog ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fire and forget CFTHREADs / CF8
On Oct 11, 2007, at 9:37 PM, Mark Mandel wrote: Charles, What makes you think that a Thread doesn't end when the code stops processing? Mark It shows up sitting in the server monitor until I actually restart Coldfusion, which is not something I want to do when it goes to production. I'm going to try Barney's suggestion, see if they go away that way. Won't be able to test until tonight, but I'll report the results. Charles ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to write this regex?
I gave it a shot Claude! Ha ha, good luck ! ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Exporting from ColdFuion to a Excel file
I have tried a few ways to export from CF to Excel. I tried a basic query and used cfcontent to download the file. I tried cfreport. They both seem to work fine but a security warning pops up on the client computer when the file is opened. It seems to only come up on computers running Office 07. Here is the message: The file you are trying to open, 'dataFile.xls' is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? If you hit yes it opens fine. I am just concerned that this will confuse users and they will not open it. Any suggestions on how to stop this besides client side security settings in Excel? Thanks. __ Steve Sequenzia Thinksys Incorporated 1613 E Livingston St Orlando, FL 32803 866.633.3000 x305 407.459.1305 Direct 866.892.3000 Help Desk 407.895.3338 Fax -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 10:11 PM To: CF-Talk Subject: Exporting from ColdFuion to a Excel file Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Remove pasted word xml code
Can anyone tell me how to remove the xml code, that text pasted from word or works ads. For examlpe P class=MsoNormal style=MARGIN: 0in 0in 0pt I want to remove this and just insert the text from the text field. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Question
think that I need to look at redoing this table for sure. If you can redesign the table, the best way to handle hierarchy is using a recursive template like a custom tag, called with only the parentId as parameter. The root elements in the the tree have parentId = 0. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT Sys-con at it again
http://www.briankotek.com/blog/index.cfm/2007/10/9/James-Hamilton-SysCon-Shill-Or-Just-a-Misguided-Imbicile-Either-Way-He-Needs-to-Shut-Up On 10/12/07, Ben Forta [EMAIL PROTECTED] wrote: Oh, I couldn't help myself. :-) No links, but ... http://www.forta.com/blog/index.cfm/2007/10/12/A-Moment-Of-Silence-For- --- Ben -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:51 AM To: CF-Talk Subject: RE: OT Sys-con at it again Yep, I am not responding on my blog either. I don't want to give them the traffic. But Jason Delmore did respond ... http://www.cfinsider.com/index.cfm/2007/10/12/Is-Adobe-Officially-killing-Co ldFusion --- Ben -Original Message- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:41 AM To: CF-Talk Subject: OT Sys-con at it again Just saw this today. http://java.sys-con.com/read/441186.htm I'm intentionally not blogging it to not give them my (paltry) traffic, but talk about sour grapes. I guess none of us can ever leave a job, because according to sys-con, it means that as we walk out the door our former company or office EXPOLDES! Terrence Ryan I.T. Director Wharton Computing and Information Technology 3733 Spruce Street 216 Vance Hall Philadelphia, PA 19104 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (215) 898-6705 Mobile: (267) 252-9727 ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checkbox validation
You mean your output isn't parsing the CFML code? Either coldfusion isn't installed, or isn't installed properly, or you're not executing a file that coldfusion parses (ie, you've got CFML code on an .htm or .html file) Rick On 10/12/07, Steve LaBadie [EMAIL PROTECTED] wrote: I have created a form with checkboxes (the person can make multiple choices). Adult/Teen Classes: input type=checkbox name=adults value=session1 / Session 1: input type=checkbox name=adults value=session2 / Session2: input type=checkbox name=adults value=session3 / Session 3: input type=checkbox name=adults value=yoga / Session 4: input type=checkbox name=adults value=belly / Session 5: On the action page a created a loop to capture the responses; If the person makes multiple choices I would like them separated either by comas or displayed in a list Adult/Teen Classes: cfloop list=#form.adults# index=a#a#/cfloop I tried the list, but the tags also appeared in the output Adult/Teen Classes: ulcfloop list=#form.adults# index=alicfoutput#a#/cfoutput/li/cfloop/ul Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Remove pasted word xml code
Can anyone tell me how to remove the xml code, that text pasted from word or works ads. For examlpe P class=MsoNormal style=MARGIN: 0in 0in 0pt This is not XML but HTML. Any way, to remove it, all you need are regular expressions. To build on Claude's comments, there's a very good UDF at cflib.org called DeMoronize: http://www.cflib.org/udf.cfm?id=725 From cflib: -- Description Fixes text using Microsoft Latin-1 Extentions, namely ASCII characters 128-160. Supplies semicolons where missing in HTML numeric and common non-numeric entities. This is a rough port of John Walker's demoroniser, written in Perl. http://www.fourmilab.ch/webtools/demoroniser/ Parameters NameDescription Required textText to be modified.Yes Return Values Returns a string. Example cfset MSText = My name is #Chr(147)#Foo#Chr(148)##Chr(133)#br cfoutputWith MS Latin-1 Extentions:br#MSText#/cfoutput cfset ValidText = DeMoronize(MSText) cfoutputValid ASCII:br#ValidText#/cfoutput -- hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Checkbox validation
I have created a form with checkboxes (the person can make multiple choices). Adult/Teen Classes: input type=checkbox name=adults value=session1 / Session 1: input type=checkbox name=adults value=session2 / Session2: input type=checkbox name=adults value=session3 / Session 3: input type=checkbox name=adults value=yoga / Session 4: input type=checkbox name=adults value=belly / Session 5: On the action page a created a loop to capture the responses; If the person makes multiple choices I would like them separated either by comas or displayed in a list Adult/Teen Classes: cfloop list=#form.adults# index=a#a#/cfloop I tried the list, but the tags also appeared in the output Adult/Teen Classes: ulcfloop list=#form.adults# index=alicfoutput#a#/cfoutput/li/cfloop/ul Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Question
I would add a column hierarchyLevel and order by that column That won't do it: you can have element at the same level, but in completely distinct branches in the hierarchy. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Excel, POI, and HTML Tables (was Re: Memory Issue)
Oh dear. I just attempted to use Ben Nadel's POUtility.cfc to create my excel spreadsheet. Couple of problems. #1 - it took 141 seconds instead of 45 seconds. 3x longer. #2 - it used almost 500 MB of RAM. 2x more. #3 - it had less functionality - my method of producing the file as HTML tables gave me column specific CSS control over each cell. Advantages: #1 - file size, 27MB versus 84MB #2 - no warning for Office 2007 users Back at CFUNITED, I asked the Coldfusion product manager if they had any intention of improving the speed of string concatenation. I told him that I was doing a lot of string concatenation to manufacture excel files via HTML tables. He basically blew me off, saying I should be using POI for that. (If you're reading this, yes, I felt like you blew me off). Now, this might not be POI's problem maybe it has something to do with the POIUtility.cfc, but my initial results don't look good. :( -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFSetting RequestTimeout Not Working
coldfusion processing does not start until *AFTER* the file is completely posted to the server. So I'm not sure that would have anything to do with it anyway. That being said.. what exactly is the error you're seeing? Is it a timeout error showing in the application.log? (also, it's been suggested that this doesn't work in a CFC anyway, but I think it does) Rick On 10/12/07, Shane Trahan [EMAIL PROTECTED] wrote: I have a CFC file that consistantly times out. Even if I put the CFSETTING REQUESTTIMEOUT to a high setting it seems to ignore it. Is there a limit to what can be set? Could it be something on my IIS server that is trumping the CFSETTING? What should I be looking for to increase the timeout? Thank you My code is as follows cffunction name=Upload access=remote returnType=any cfargument name=IViewFileName type=string required=yes hint=Filename to be used cfargument name=IViewFileObject type=any required=yes hint=The base64 text of the uploaded file cfsetting requesttimeout=600 cfset filename=#arguments.IViewFileName# cffile action=write file=#CurrentDir##filename# Output=#ToBinary(IViewFileObject)# /cffunction ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: objectBreeze vs Transfer
Transfer is good but takes some getting used to (be careful with the cache as it can bite you if you don't keep it in mind). On 10/12/07, Joeri B [EMAIL PROTECTED] wrote: Hi, I want to build a small CMS with an ORM tool. It has a small relational database. I found two ORM tools, which I liked when reading the documentation. 1. Objectbreeze: very very very simple, it has relationships on the fly. 2. Transfer: simple, a bit more complicated but nothing I cant handle. What are your experiences with those two ORM tools? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why does this code disable styling?
It's all just b../b at this point. It's just a calendar app that I created for my use and I wanted to distinguish some headings in the textfield where I enter details. At this point, b../b would be all I would probably use. Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 8:36 AM To: CF-Talk Subject: Re: Why does this code disable styling? do you always only have b .../b formatting in yout text, or can it be any html tag (hope not)? Azadi Rick Faircloth wrote: Hmmm... CF_REextract looks useful, but the problem is that I'd have to know enough regex to tell it what RE1 and RE2 should be. If I knew that, I could probably write the regex. This shouldn't be too hard... I can look up a regex reference and probably set it up. It's just a matter of converting all spaces, or chr(32)'s, to nbsp; except those between and . I was just thinking someone might know how to do it off the top of their head, without any effort. Thanks for the reference to CF_REextract, et al. They all look useful! Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 5:37 PM To: CF-Talk Subject: Re: Why does this code disable styling? Know how to regex that, Claude? Must not be simple. I'm too lazy, this is why I made CF_REextract. If I had to do it, I would use CF_REextract for sure. 1ยบ get all strings outside tags and their location, 2 loop on the query backward and replace spaces in these strings See CF_REextract: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm and yes: it is CF4.5 compatible ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT Sys-con at it again
1. CFDJ came out in the fall of 1999, which makes their claims to 10 years (and 12 years in some marketing materials) blatant lies. 2. They're using a sock puppet to put forth 'expert' testimony 3. A magazine does not live or die on the merit of a single advertiser. 4. They must truly be in Microsofts pocket in order to be pissing off a major player in such a way that many other advertisers will not want to advertise with them anymore. 5. This really is OT for the ColdFusion-Talk technical list. :) According to some in the ColdFusion community, Adobe's destruction of ColdFusion started by pulling the plug on a 10 year-old institution, ColdFusion Developer's Journal it's really a shame that they can't be held responsible for lying in print (can they?). shouldn't there be some sort of system in place whereby somebody can say, hey sys-con... produce me one (just ONE) person in the CF community that feels that Adobe's destruction of CF started by pulling the plug on CFDJ. shouldn't there be *some* level of accountability? On 10/12/07, Brian Kotek [EMAIL PROTECTED] wrote: http://www.briankotek.com/blog/index.cfm/2007/10/9/James-Hamilton-SysCon-Shill-Or-Just-a-Misguided-Imbicile-Either-Way-He-Needs-to-Shut-Up On 10/12/07, Ben Forta [EMAIL PROTECTED] wrote: Oh, I couldn't help myself. :-) No links, but ... http://www.forta.com/blog/index.cfm/2007/10/12/A-Moment-Of-Silence-For- --- Ben -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:51 AM To: CF-Talk Subject: RE: OT Sys-con at it again Yep, I am not responding on my blog either. I don't want to give them the traffic. But Jason Delmore did respond ... http://www.cfinsider.com/index.cfm/2007/10/12/Is-Adobe-Officially-killing-Co ldFusion --- Ben -Original Message- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:41 AM To: CF-Talk Subject: OT Sys-con at it again Just saw this today. http://java.sys-con.com/read/441186.htm I'm intentionally not blogging it to not give them my (paltry) traffic, but talk about sour grapes. I guess none of us can ever leave a job, because according to sys-con, it means that as we walk out the door our former company or office EXPOLDES! Terrence Ryan I.T. Director Wharton Computing and Information Technology 3733 Spruce Street 216 Vance Hall Philadelphia, PA 19104 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (215) 898-6705 Mobile: (267) 252-9727 ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290965 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to write this regex?
Wow... pretty complicated... thanks, Bobby! Rick -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 12:22 PM To: CF-Talk Subject: RE: How to write this regex? I'm sure there is probably a better way... such as a simple regex.. youll need Doom for that one but until then try this... cfsavecontent variable=txt This is a test of something a href=test.cfm title=testAnd this is a link/abr / This is another test but with an image tag img src=somimg.jpg al / so let's see how it goes /cfsavecontent cfscript function noBreak(str) { blockArr = arrayNew(1); while (reFindNoCase(.*?, str) and reFindNoCase(.*?, str)) { startPos = reFindNoCase(.*?, str); endPos = reFindNoCase(*.?, str); thisBlock = Mid(str, startPos, endPos - startPos+2); str = removeChars(str, startPos, endPos - startPos+2); ArrayAppend(blockArr, thisBlock); str = Insert([!*#ArrayLen(blockArr)#*!], str, startPos - 1); } str = replace(str, ' ', 'nbsp;', 'all'); for (i=1; i lte ArrayLen(blockArr); i=i+1) { str = replacenocase(str, '[!*#i#*!]', blockArr[i]); } return str; } /cfscript cfoutput#noBreak(txt)#/cfoutput ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:01 PM To: CF-Talk Subject: How to write this regex? Hi, all. I thought I could figure this out, but apparently not. at least so far. But how would I write a regex that would find all spaces and change them to nbsp; except those inside a or ? REreplace(string, all spaces not in between and , nbsp;, All) And I'd rather not have an unbreakable space, but I couldn't come up with anything else to use. (I gave it a shot Claude!) Suggestions anyone? Rick ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Value concatenation
I have 15 documents on one page and there are ack buttons for each document listed. If I click the button once, i return to the current page; if i click another button, i get the error msg. Does this help? Thanks I'm not totally following your question or where the error is from, but is the DocID in both the form action and hidden input? I'm unable to locate where the values concatenate. When I click on the button twice, I get the following error msg, Returns the value, 16,16. I'm not sure what I'm doing wrong?? Can someone please help? Thanks! cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex# cfelseif parameterexists(URL.startindex) cfset startnum = #URL.startindex# cfelse cfset startnum=1 /cfif cfset count = 0 cfoutput query=getdocs cfset count=#count#+1 /cfoutput cfoutput cfset endnum = #startnum# +14 cfif #endnum# GT #count# cfset endnum = #count#/cfif cfset prev=#startnum# - 15 cfset next=#endnum# +1 cfset reccount = #startnum# - 1 cfoutput query=getdocs maxrows=15 startrow=#startnum# cfset reccount = #reccount# +1 p align=left !---b#reccount#.nbsp;/b--- cfif #getdocs.deptRestriction# EQ 0 OR #session.deptID# NEQ #getdocs. deptRestriction# a href=#docstorage#/#docName# target=_blankb#docTitle#/b /a cfelse b#docTitle# (Secured Document) /b /cfif font size=-2Date: #DateFormat(lastupdate, MM/DD/YY)# Rev ##: cfif #revision# is 0Initialcfelse#revision#/cfif nbsp;nbsp;nbsp;nbsp;nbsp;/font font size=-1brb#docNumber#/bbr/font font size=-2Summary: i#Left(summary, 125)# nbsp;nbsp;nbsp;(a href=../docs/view.cfm?docID=#docID#see more/a)/i/font cfif ActionType NEQ 'R' cfform action=../docs/docActionLog.cfm?#CGI.QUERY_STRING# !--- cfif #startnum# GTE 15 --- input type=hidden name=hello value=#startnum# !--- cfelseif #count# GTE #next# input type=hidden name=next value=#startnum# --- !--- /cfif --- input type=hidden name=DocName value=#docName# input type=hidden name=DocID value=#DocID# input type=hidden name=DocAction value=R input type=submit value=I have reviewed and understand this document /cfform /cfif /p /cfoutput ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290962 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checkbox validation
It's not parsing, the page is .cfm document. If a person choose all options it displays like this session1session2session3session4session5 The whole site is coldfusion, all other apps are working fine. I even tried using the delimiter=, attribute in the cfloop. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 2:14 PM To: CF-Talk Subject: Re: Checkbox validation You mean your output isn't parsing the CFML code? Either coldfusion isn't installed, or isn't installed properly, or you're not executing a file that coldfusion parses (ie, you've got CFML code on an .htm or .html file) Rick On 10/12/07, Steve LaBadie [EMAIL PROTECTED] wrote: I have created a form with checkboxes (the person can make multiple choices). Adult/Teen Classes: input type=checkbox name=adults value=session1 / Session 1: input type=checkbox name=adults value=session2 / Session2: input type=checkbox name=adults value=session3 / Session 3: input type=checkbox name=adults value=yoga / Session 4: input type=checkbox name=adults value=belly / Session 5: On the action page a created a loop to capture the responses; If the person makes multiple choices I would like them separated either by comas or displayed in a list Adult/Teen Classes: cfloop list=#form.adults# index=a#a#/cfloop I tried the list, but the tags also appeared in the output Adult/Teen Classes: ulcfloop list=#form.adults# index=alicfoutput#a#/cfoutput/li/cfloop/ul Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Remove pasted word xml code
Can anyone tell me how to remove the xml code, that text pasted from word or works ads. For examlpe P class=MsoNormal style=MARGIN: 0in 0in 0pt This is not XML but HTML. Any way, to remove it, all you need are regular expressions. Another option is to open it in word then copy/paste the text from the document viewer. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Training Powerpoints for Sales
I'm sure others will have plenty of reasons, but my suggestion would be to actually create the presentation using CF8's new presentation tags. Then, on the last slide of the presentation, make note that you used CF8 for what they just witnessed. I would not mind creating and posting something like that for general consumption... if I could get at least a leg up on the material to cover? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkbox validation
On 10/12/07, Steve LaBadie [EMAIL PROTECTED] wrote: It's not parsing, the page is .cfm document. If a person choose all options it displays like this session1session2session3session4session5 The whole site is coldfusion, all other apps are working fine. I even tried using the delimiter=, attribute in the cfloop. That's exactly what you're telling it to output. you're looping over a list, outputting each element (and in your output, you're not putting a comma). you'd need to do: cfloop list=#form.adults# index=a#a#,/cfloop (which would leave a trailing comma, so you'd have to do a conditional inside the loop to determine whether or not to show the comma). of course, if you want to output the list, you could just do: cfoutput#form.adults#/cfoutput :) -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Exporting from ColdFuion to a Excel file
I have a different problem falling under the same topic. I'm trying to download a .csv file from ColdFusion to Excel via a browser. My code is: cfheader name=Content-Type value=text/csv cfheader name=Content-Disposition value=attachment; filename=Target_File_Name.csv cfcontent type=application/vnd.ms-excel file=Source_File_Name deletefile=No IE has no problem with this but Firefox strips off the .csv extension. It offers to open the file in Excel as Target_File_Name without the .csv, but this puts everything in the first column since the format is .csv, not .xls Or Firefox will save the file with no extension. I'm currently telling users to save the file, add the extension, then open in Excel. This works but it's a pain in the neck. Can anyone tell me why Firefox is stripping off the .cvs extension, and how I can prevent this? Firefox is evidently getting Target_File_Name.csv, so I wonder whether it's zapping the extension as a security issue. I can't find a setting for this, however. Thanks, Bob Mack ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ANSWER: Can a ColdFusion application see what processes are scheduled?
I can see the current scheduled processes through the administrator, but is there a way for my application to see what scheduled processes are active, and when they will next run? Thanks, Bob Mack The answer is on Ben Fortas' blog: http://www.forta.com/blog/index.cfm/2006/8/28/GetScheduledTasks-Function-Returns-Scheduled-Task-List CF can't to it directly, but a block of code written by none other than Michael Dinowitz provides a workaround. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT Sys-con at it again
Lol. You're approach is working already... http://www.google.com/search?hl=enq=James+Hamilton+sys-conbtnG=Search First result. ~Brad -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 12:03 PM To: CF-Talk Subject: Re: OT Sys-con at it again http://www.briankotek.com/blog/index.cfm/2007/10/9/James-Hamilton-SysCon -Shill-Or-Just-a-Misguided-Imbicile-Either-Way-He-Needs-to-Shut-Up On 10/12/07, Ben Forta [EMAIL PROTECTED] wrote: Oh, I couldn't help myself. :-) No links, but ... http://www.forta.com/blog/index.cfm/2007/10/12/A-Moment-Of-Silence-For- --- Ben -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:51 AM To: CF-Talk Subject: RE: OT Sys-con at it again Yep, I am not responding on my blog either. I don't want to give them the traffic. But Jason Delmore did respond ... http://www.cfinsider.com/index.cfm/2007/10/12/Is-Adobe-Officially-killin g-Co ldFusion --- Ben -Original Message- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:41 AM To: CF-Talk Subject: OT Sys-con at it again Just saw this today. http://java.sys-con.com/read/441186.htm I'm intentionally not blogging it to not give them my (paltry) traffic, but talk about sour grapes. I guess none of us can ever leave a job, because according to sys-con, it means that as we walk out the door our former company or office EXPOLDES! Terrence Ryan I.T. Director Wharton Computing and Information Technology 3733 Spruce Street 216 Vance Hall Philadelphia, PA 19104 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (215) 898-6705 Mobile: (267) 252-9727 ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT Sys-con at it again
two things... 2nd to last paragraph: ...considered another strong step by Adobe on its way to dismentaling ColdFusion. dismentaling? last paragraph: What Adobe is doing with ColdFusion is very similar to what Borland did in 1986. They bought Ashton Software for the sole purpose of killing dBase IV, which competed with Borland's Paradox at the time, and they did, said one industry insider. their industry insider is a moron. if Borland bought Ashton for the sole purpose of killing off a competing product... wouldn't that imply that Adobe -had- a product that was competing with CF? it's a ridiculous analogy that doesn't come close to holding true. It just reeks of sys-con being really really really bitter. especially this part (also from the 2nd to last paragraph): According to some in the ColdFusion community, Adobe's destruction of ColdFusion started by pulling the plug on a 10 year-old institution, ColdFusion Developer's Journal it's really a shame that they can't be held responsible for lying in print (can they?). shouldn't there be some sort of system in place whereby somebody can say, hey sys-con... produce me one (just ONE) person in the CF community that feels that Adobe's destruction of CF started by pulling the plug on CFDJ. shouldn't there be *some* level of accountability? On 10/12/07, Brian Kotek [EMAIL PROTECTED] wrote: http://www.briankotek.com/blog/index.cfm/2007/10/9/James-Hamilton-SysCon-Shill-Or-Just-a-Misguided-Imbicile-Either-Way-He-Needs-to-Shut-Up On 10/12/07, Ben Forta [EMAIL PROTECTED] wrote: Oh, I couldn't help myself. :-) No links, but ... http://www.forta.com/blog/index.cfm/2007/10/12/A-Moment-Of-Silence-For- --- Ben -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:51 AM To: CF-Talk Subject: RE: OT Sys-con at it again Yep, I am not responding on my blog either. I don't want to give them the traffic. But Jason Delmore did respond ... http://www.cfinsider.com/index.cfm/2007/10/12/Is-Adobe-Officially-killing-Co ldFusion --- Ben -Original Message- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:41 AM To: CF-Talk Subject: OT Sys-con at it again Just saw this today. http://java.sys-con.com/read/441186.htm I'm intentionally not blogging it to not give them my (paltry) traffic, but talk about sour grapes. I guess none of us can ever leave a job, because according to sys-con, it means that as we walk out the door our former company or office EXPOLDES! Terrence Ryan I.T. Director Wharton Computing and Information Technology 3733 Spruce Street 216 Vance Hall Philadelphia, PA 19104 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (215) 898-6705 Mobile: (267) 252-9727 ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Training Powerpoints for Sales
I'm sure others will have plenty of reasons, but my suggestion would be to actually create the presentation using CF8's new presentation tags. Then, on the last slide of the presentation, make note that you used CF8 for what they just witnessed. M!ke -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:52 AM To: CF-Talk Subject: SOT: Training Powerpoints for Sales (Cross-posting to talk) Folks - I have been asked to give a brief (15 minute) presentation to our sales staff in a couple of weeks about ColdFusion, why we selected it as our primary development platform, some of the things that we can do with it (we have CF8) and blurbs for overcoming typical obstacles. I know I've seen canned presentations in the past but does any one have something that's updated for CF7 or potentially CF8? Thanks! Hatton ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290960 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Checkbox validation
It's because check boxes need separate names. It's the HTML form, not CF. If you want multi-select use a multi-select combo box (which will give you a delimited string) ... OR if you need checkboxes give them different names. If the check boxes are output from a query and you don't know the number, then add a count number to the name to make then unique. Then, when you process, loop on them and use EVALUATE to extract the values. If you don't understand this contact me off list and I'll send you a routine that will do it... but it's two sides - the build side and the process side. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Exporting from ColdFuion to a Excel file
I have a different problem falling under the same topic. I'm trying to download a .csv file from ColdFusion to Excel via a browser. My code is: cfheader name=Content-Type value=text/csv cfheader name=Content-Disposition value=attachment; filename=Target_File_Name.csv cfcontent type=application/vnd.ms-excel file=Source_File_Name deletefile=No IE has no problem with this but Firefox strips off the .csv extension. It offers to open the file in Excel as Target_File_Name without the .csv, but this puts everything in the first column since the format is .csv, not .xls Or Firefox will save the file with no extension. I'm currently telling users to save the file, add the extension, then open in Excel. This works but it's a pain in the neck. Can anyone tell me why Firefox is stripping off the .cvs extension, and how I can prevent this? Firefox is evidently getting Target_File_Name.csv, so I wonder whether it's zapping the extension as a security issue. I can't find a setting for this, however. Thanks, Bob Mack ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Value concatenation
I'm not totally following your question or where the error is from, but is the DocID in both the form action and hidden input? That would be my guess. This question was posted before with a different subject. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:53834 ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Killing a login
If you are on CFMX, you can use J2EE session which will expire on browser close. HTH On 10/12/07, Richard Colman [EMAIL PROTECTED] wrote: I am trying to provide a logout function on my site. I have tried various combination like: cfcookie name = UserID value = #session.client_id# expires = NOW cfset structDelete(cookie,'UserID') / CFSET temp=structDELETE(session, 'level') CFSET temp=structDELETE(session, 'loginok') CFSET temp=structDELETE(session, 'client_id') CFSET temp=structDELETE(session, 'lname') CFSET temp=structDELETE(session, 'fname') But the login presists until the browser is closed. Is there any way to kill a login without exiting the browser? Any suggestions appreciated. Rick Colman ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFSetting RequestTimeout Not Working
I have a CFC file that consistantly times out. Even if I put the CFSETTING REQUESTTIMEOUT to a high setting it seems to ignore it. Is there a limit to what can be set? Could it be something on my IIS server that is trumping the CFSETTING? What should I be looking for to increase the timeout? Thank you My code is as follows cffunction name=Upload access=remote returnType=any cfargument name=IViewFileName type=string required=yes hint=Filename to be used cfargument name=IViewFileObject type=any required=yes hint=The base64 text of the uploaded file cfsetting requesttimeout=600 cfset filename=#arguments.IViewFileName# cffile action=write file=#CurrentDir##filename# Output=#ToBinary(IViewFileObject)# /cffunction ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290954 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to write this regex?
I'm sure there is probably a better way... such as a simple regex.. youll need Doom for that one but until then try this... cfsavecontent variable=txt This is a test of something a href=test.cfm title=testAnd this is a link/abr / This is another test but with an image tag img src=somimg.jpg al / so let's see how it goes /cfsavecontent cfscript function noBreak(str) { blockArr = arrayNew(1); while (reFindNoCase(.*?, str) and reFindNoCase(.*?, str)) { startPos = reFindNoCase(.*?, str); endPos = reFindNoCase(*.?, str); thisBlock = Mid(str, startPos, endPos - startPos+2); str = removeChars(str, startPos, endPos - startPos+2); ArrayAppend(blockArr, thisBlock); str = Insert([!*#ArrayLen(blockArr)#*!], str, startPos - 1); } str = replace(str, ' ', 'nbsp;', 'all'); for (i=1; i lte ArrayLen(blockArr); i=i+1) { str = replacenocase(str, '[!*#i#*!]', blockArr[i]); } return str; } /cfscript cfoutput#noBreak(txt)#/cfoutput ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:01 PM To: CF-Talk Subject: How to write this regex? Hi, all. I thought I could figure this out, but apparently not. at least so far. But how would I write a regex that would find all spaces and change them to nbsp; except those inside a or ? REreplace(string, all spaces not in between and , nbsp;, All) And I'd rather not have an unbreakable space, but I couldn't come up with anything else to use. (I gave it a shot Claude!) Suggestions anyone? Rick ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290953 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Killing a login
By setting the cookie and session variables (shown in the code) that I am trying to destroy on a logout. The login script checks for a session variable, or presence of the cookie. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 9:10 AM To: CF-Talk Subject: Re: Killing a login Richard Colman wrote: I am trying to provide a logout function on my site. Is there any way to kill a login without exiting the browser? How do you log users in? Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290952 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Killing a login
But the login presists until the browser is closed. Yes it will persist until you check it again. First expire the cookie. Then process a command that checks the cookie and if it doesn't exists, kill your session variables and kick them out. You will need to add the routine (or include) to the top of every secure page. That's a pain but it will force checking and kick them out. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290951 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flash form rich text editor
Looks like Pim is no longer keeping up on his blog and the download URL is broken. http://cfpim.blogspot.com/2005/04/rich-textarea-for-flash-cfforms.html Are there any others in existence? ___ Jason Durham ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT Sys-con at it again
Oh, I couldn't help myself. :-) No links, but ... http://www.forta.com/blog/index.cfm/2007/10/12/A-Moment-Of-Silence-For- --- Ben -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:51 AM To: CF-Talk Subject: RE: OT Sys-con at it again Yep, I am not responding on my blog either. I don't want to give them the traffic. But Jason Delmore did respond ... http://www.cfinsider.com/index.cfm/2007/10/12/Is-Adobe-Officially-killing-Co ldFusion --- Ben -Original Message- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:41 AM To: CF-Talk Subject: OT Sys-con at it again Just saw this today. http://java.sys-con.com/read/441186.htm I'm intentionally not blogging it to not give them my (paltry) traffic, but talk about sour grapes. I guess none of us can ever leave a job, because according to sys-con, it means that as we walk out the door our former company or office EXPOLDES! Terrence Ryan I.T. Director Wharton Computing and Information Technology 3733 Spruce Street 216 Vance Hall Philadelphia, PA 19104 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (215) 898-6705 Mobile: (267) 252-9727 ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Killing a login
Richard Colman wrote: I am trying to provide a logout function on my site. Is there any way to kill a login without exiting the browser? How do you log users in? Jochem ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Killing a login
I am trying to provide a logout function on my site. I have tried various combination like: cfcookie name = UserID value = #session.client_id# expires = NOW cfset structDelete(cookie,'UserID') / CFSET temp=structDELETE(session, 'level') CFSET temp=structDELETE(session, 'loginok') CFSET temp=structDELETE(session, 'client_id') CFSET temp=structDELETE(session, 'lname') CFSET temp=structDELETE(session, 'fname') But the login presists until the browser is closed. Is there any way to kill a login without exiting the browser? Any suggestions appreciated. Rick Colman ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT Sys-con at it again
Yep, I am not responding on my blog either. I don't want to give them the traffic. But Jason Delmore did respond ... http://www.cfinsider.com/index.cfm/2007/10/12/Is-Adobe-Officially-killing-Co ldFusion --- Ben -Original Message- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:41 AM To: CF-Talk Subject: OT Sys-con at it again Just saw this today. http://java.sys-con.com/read/441186.htm I'm intentionally not blogging it to not give them my (paltry) traffic, but talk about sour grapes. I guess none of us can ever leave a job, because according to sys-con, it means that as we walk out the door our former company or office EXPOLDES! Terrence Ryan I.T. Director Wharton Computing and Information Technology 3733 Spruce Street 216 Vance Hall Philadelphia, PA 19104 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (215) 898-6705 Mobile: (267) 252-9727 ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT Sys-con at it again
Just saw this today. http://java.sys-con.com/read/441186.htm I'm intentionally not blogging it to not give them my (paltry) traffic, but talk about sour grapes. I guess none of us can ever leave a job, because according to sys-con, it means that as we walk out the door our former company or office EXPOLDES! Terrence Ryan I.T. Director Wharton Computing and Information Technology 3733 Spruce Street 216 Vance Hall Philadelphia, PA 19104 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (215) 898-6705 Mobile: (267) 252-9727 ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 Upgrade Affecting ASP Applications
Steve Moore wrote: I was sure this was coincidental, but has now happened for the second time on another server. Server A was upgraded from CF 7.02 to CF 8 on a Saturday. On Monday an ASP application on server suddenly took 5+ minutes just to display a login screen. Worked fine the previous week. That ASP application was upgraded to the vendor's latest version and it began working reasonably. Now, after a Saturday upgrade to CF 8 on Server B, another ASP application on this server is now taking 5 minutes to display a login screen. Seems obvious there is some relation, but I have no idea how CF 8 could be affecting an old ASP application. Anyone experienced anything like this or have any ideas what relation could be? Probably you have the CF wildcard filter installed and for some reason the JRun connector is: - forwarding .asp requests to JRun; - taking too long to determine the request should not be handled by CF. Switch on verbose logging on the connector (restart IIS afterwards) and check the logfiles. Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Making advanced search options for a database using CF8
Dear sir: Thanks for the reply. I'm deeply sorry for my mistake. It was not on purpose and you are right I should reconsider my mailing server. Sorry again. Benign Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 12 Oct 2007, [EMAIL PROTECTED] wrote: Hi: Three strikes. Get a new mail server, or calm down and wait. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Question
Bruce, I would add a column hierarchyLevel and order by that column ~Svetlana Rudkovsky ย ย ย oย ย ย ย ย ย oย @..@ ย ()ย ( )--( ) ย o0..0o -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 6:04 PM To: CF-Talk Subject: Query Question I have a simple select query: Select parentID, title, body, status, hierarchy From pages Where status='A' Order by hierarchy The hierarchy field looks like this: 1 1~7 1~8 1~9 1~10 1~12 1~12~13 1~12~14 and so on. The problem is that when I run this query, it orders them like this: 1 1~10 1~12 1~12~13 1~12~14 1~7 1~8 and so on. So how can I get it where it orders them the way they are supposed to? Thanks, Bruce ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Making advanced search options for a database using CF8
Dear sir: Thanks for the reply. I'm really sorry for sending the questions 3 times. I didn't do it on pupose. The mailing server showed no adding and I thiught it was my IE problem or wireless internet internet which is now working very well these days. Anyway I am really sorry and I do apologize for the mistake. About doing research, nope! I did my research a lot but I wanted to use your ideas in general. I didn't specify something because I felt it might comes with answers which can help me modify the whole idea but surely you are right. I'm sorry again. I will research more and I will ask more specific/technical questions. It was my mistake and sorry. Benign ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Remove pasted word xml code
Can anyone tell me how to remove the xml code, that text pasted from word or works ads. For examlpe P class=MsoNormal style=MARGIN: 0in 0in 0pt This is not XML but HTML. Any way, to remove it, all you need are regular expressions. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Value concatenation
Candice, Concatenation happens because you have two form input elements with the same name. HTH ~Svetlana Rudkovsky Applications Developer, DIT Inc. 571-246-7197 oย ย ย ย ย oย ย ย ย ย ย oย @..@ ย ()ย ( )--( ) ย o0..0o -Original Message- From: Candice toro [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 6:05 PM To: CF-Talk Subject: Value concatenation I'm unable to locate where the values concatenate. When I click on the button twice, I get the following error msg, Returns the value, 16,16. I'm not sure what I'm doing wrong?? Can someone please help? Thanks! cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex# cfelseif parameterexists(URL.startindex) cfset startnum = #URL.startindex# cfelse cfset startnum=1 /cfif cfset count = 0 cfoutput query=getdocs cfset count=#count#+1 /cfoutput cfoutput cfset endnum = #startnum# +14 cfif #endnum# GT #count# cfset endnum = #count#/cfif cfset prev=#startnum# - 15 cfset next=#endnum# +1 cfset reccount = #startnum# - 1 cfoutput query=getdocs maxrows=15 startrow=#startnum# cfset reccount = #reccount# +1 p align=left !---b#reccount#.nbsp;/b--- cfif #getdocs.deptRestriction# EQ 0 OR #session.deptID# NEQ #getdocs.deptRestriction# a href=#docstorage#/#docName# target=_blankb#docTitle#/b /a cfelse b#docTitle# (Secured Document) /b /cfif font size=-2Date: #DateFormat(lastupdate, MM/DD/YY)# Rev ##: cfif #revision# is 0Initialcfelse#revision#/cfif nbsp;nbsp;nbsp;nbsp;nbsp;/font font size=-1brb#docNumber#/bbr/font font size=-2Summary: i#Left(summary, 125)#nbsp;nbsp;nbsp;(a href=../docs/view.cfm?docID=#docID#see more/a)/i/font cfif ActionType NEQ 'R' cfform action=../docs/docActionLog.cfm?#CGI.QUERY_STRING# !--- cfif #startnum# GTE 15 --- input type=hidden name=hello value=#startnum# !--- cfelseif #count# GTE #next# input type=hidden name=next value=#startnum# --- !--- /cfif --- input type=hidden name=DocName value=#docName# input type=hidden name=DocID value=#DocID# input type=hidden name=DocAction value=R input type=submit value=I have reviewed and understand this document /cfform /cfif /p /cfoutput ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pivot Query Display
I have a SQL query for the output I need to have: cfquery ... select a.Dept, a.JobTitle, e.Shift, e.ExposureType, e.device, e.ExposureDate from exposure e, AssociatePersonal a where e.AssociateIDEx = a.AssociateID /cfquery The output I need to have is the sample output at http://www.mediafire.com/?9hzxddssiwy I uploaded an Excel spreadsheet (qryoutput.xls) for better explanations. Thx much ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Memory Issue
Along those same lines, it seems save to assume that THIS also creates a new string isntance every iteration: cfloop list=#fields# index=ThisCol Since I know list processing is slow (at least it's slower in CF7)... and I don't want to be creating 10 million strings... I tried converting the list to an array and using this functionality instead: cfloop from=1 to=#numFields# index=i step=1 and then instead of reference the variable ThisCol, Didn't help much. Which made me also realize that this kind of stuff: cfset fileOutput.append( resultSet[fieldsArray[i]][resultSet.currentRow] ) might *ALSO* be creating one or more strings.. ie, evaluating resultSet[fieldsArray[i]][resultSet.currentRow] and then calling fileOutput.append() I also discovered that I was running a couple lines of code (that I didn't share with the list) once per column instead of once per record... It also is apparently faster to write out every line to disk rather than every 500 lines... that surprised me.. cut my processing time from 90 seconds to 75 seconds. With other changes, I've gotten my file generation time down to 46 seconds. however, it's still using 300+ MB of memory! Here is my current loop code.. approximately 42 seconds of the the 46 seconds total occur during this loop code: cfloop query=resultSet cfset row = resultSet.currentRow cfif NOT JOINT_LABELS OR listFind(ArrayToList(spouses),SPOUSE_ID) is 0 cfif JOINT_LABELS AND IS_JOINT cfset ArrayAppend(spouses, SPOUSE_ID) /cfif cfset fileOutput.append(START_ROW) cfloop from=1 to=#numFields# index=i step=1 cfset fileOutput.append( START_FIELDS[fieldsArray[i]] resultSet[fieldsArray[i]][row] END_FIELD) /cfloop cfset fileOutput.append(END_ROW) /cfif cfset fileWrite(fh, fileOutput.toString()) !--- cfset fileOutput.delete(0,fileOutput.length()) --- cfset fileOutput.setLength(0) /cfloop Ultimately, I think I might need to write this datadrop gateway in Java -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why does this code disable styling?
Hmmm... CF_REextract looks useful, but the problem is that I'd have to know enough regex to tell it what RE1 and RE2 should be. If I knew that, I could probably write the regex. Not really, because REextract needs much simpler regexp to do the job, so you only need to master the basic about regexp. Most of the time, the regExp are just standard strings. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion 8 Upgrade Affecting ASP Applications
I was sure this was coincidental, but has now happened for the second time on another server. Server A was upgraded from CF 7.02 to CF 8 on a Saturday. On Monday an ASP application on server suddenly took 5+ minutes just to display a login screen. Worked fine the previous week. That ASP application was upgraded to the vendor's latest version and it began working reasonably. Now, after a Saturday upgrade to CF 8 on Server B, another ASP application on this server is now taking 5 minutes to display a login screen. Seems obvious there is some relation, but I have no idea how CF 8 could be affecting an old ASP application. Anyone experienced anything like this or have any ideas what relation could be? Steve Moore ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Making advanced search options for a database using CF8
On Friday 12 Oct 2007, [EMAIL PROTECTED] wrote: Hi: Three strikes. Get a new mail server, or calm down and wait. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Memory Issue
On 10/11/07, Brian Kotek [EMAIL PROTECTED] wrote: Also, I am almost positive that Replace() is creating another string variable under the hood, which means in this nested loop that could be a huge number of new CF string variables, depending on how many iterations you're doing. cfset fileOutput.append (replace(START_FIELD,___COLNAME___,ThisCol,ALL)) That's a good point! I use the StringBuffer method to avoid that! But... imagine, 50,000 rows, 200 columns. That's 10,000,000 iterations of this particular operation. I haven't run this yet, but I'm going to try it.. what I've done is created a struct called start_fields which is populated BEFORE the output of the columns.. So the above line is now: cfset fileOutput.append(START_FIELDS[ThisCol]) START_FIELD contained td class=___COLNAME___ But START_FIELDS[ENTITYID] now contains td class=ENTITYID I'll give this a whirl and see what happens. I'll try the setLength() thing that Mark suggested too. -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can a ColdFusion application see what processes are scheduled?
You may want to try: cfschedule action=run task=__list It provides a list of scheduled tasks on a server, tho' not a particularly 'pretty' one. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Returns the value, 16,16?? Please help!
On Thursday 11 Oct 2007, [EMAIL PROTECTED] wrote: You'll get smarter answers if you say some words in your post. Sometimes I thing someone is testing a Turing entry... -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why does this code disable styling?
do you always only have b .../b formatting in yout text, or can it be any html tag (hope not)? Azadi Rick Faircloth wrote: Hmmm... CF_REextract looks useful, but the problem is that I'd have to know enough regex to tell it what RE1 and RE2 should be. If I knew that, I could probably write the regex. This shouldn't be too hard... I can look up a regex reference and probably set it up. It's just a matter of converting all spaces, or chr(32)'s, to nbsp; except those between and . I was just thinking someone might know how to do it off the top of their head, without any effort. Thanks for the reference to CF_REextract, et al. They all look useful! Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 5:37 PM To: CF-Talk Subject: Re: Why does this code disable styling? Know how to regex that, Claude? Must not be simple. I'm too lazy, this is why I made CF_REextract. If I had to do it, I would use CF_REextract for sure. 1ยบ get all strings outside tags and their location, 2 loop on the query backward and replace spaces in these strings See CF_REextract: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm and yes: it is CF4.5 compatible ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Making advanced search options for a database using CF8
Hi: I am working on a project which its main idea is, making a dynamic website contanins the basic information about certain companies and gives the users advanced search option through the database. The basic options will be free (all companies can add their info) but when a company pays the price it will appear at the top of the result page. It will be made by CF8 and MSSQL 2000. Now my questions are: Is there any example out there that I can modfy my idea with. Free/Trial. What do you suggest as the search method? I use the basic SQL filtering? Or you suggest something new? And finally, is there any tutorial helps me through the developing proccess. Thanks Benign ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Making advanced search options for a database using CF8
Hi: I am working on a project which its main idea is, making a dynamic website contanins the basic information about certain companies and gives the users advanced search option through the database. The basic options will be free (all companies can add their info) but when a company pays the price it will appear at the top of the result page. It will be made by CF8 and MSSQL 2000. Now my questions are: Is there any example out there that I can modfy my idea with. Free/Trial. What do you suggest as the search method? I use the basic SQL filtering? Or you suggest something new? And finally, is there any tutorial helps me through the developing proccess. Thanks Benign ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Encoding for cfmail containing japanese character problem
NUGROHO NOTO wrote: I had put these in my page. cfcontent type=text/html; charset=utf-8 cfprocessingdirective pageencoding=utf-8 also... I have these... cfmail query=mailinglist to=#email# from=webmaster subject=#subject# missed the charset atribute. CFMAILPARAM NAME=MIME-Version VALUE=1.0 CFMAILPARAM NAME=Content-Type VALUE=text/plain; charset=utf-8 CFMAILPARAM NAME=Content-Type VALUE=text/plain; charset='utf-8' might work better. - some recipient (around 20% from 20.000 user) report.. they receive MOJIBAKE (garbage character)... that's rather a lot. And.. mostly.. who receive this mojibake character.. is customer who use yahoo.bb , msn, or Handphone email. ...and can these email services actually use utf-8 in your region? Before... on CF5 server.. I used shift_JIS.. and there was NO (or very little) problem. because cf5 didn't an encoding from a hole in the ground. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Value concatenation
I have 15 documents on one page and there are ack buttons for each document listed. If I click the button once, i return to the current page; if i click another button, i get the error msg. Does this help? Thanks I'm not totally following your question or where the error is from, but is the DocID in both the form action and hidden input? I'm unable to locate where the values concatenate. When I click on the button twice, I get the following error msg, Returns the value, 16,16. I'm not sure what I'm doing wrong?? Can someone please help? Thanks! cfif parameterexists(FORM.startindex) cfset startnum = #FORM.startindex# cfelseif parameterexists(URL.startindex) cfset startnum = #URL.startindex# cfelse cfset startnum=1 /cfif cfset count = 0 cfoutput query=getdocs cfset count=#count#+1 /cfoutput cfoutput cfset endnum = #startnum# +14 cfif #endnum# GT #count# cfset endnum = #count#/cfif cfset prev=#startnum# - 15 cfset next=#endnum# +1 cfset reccount = #startnum# - 1 cfoutput query=getdocs maxrows=15 startrow=#startnum# cfset reccount = #reccount# +1 p align=left !---b#reccount#.nbsp;/b--- cfif #getdocs.deptRestriction# EQ 0 OR #session.deptID# NEQ #getdocs. deptRestriction# a href=#docstorage#/#docName# target=_blankb#docTitle#/b /a cfelse b#docTitle# (Secured Document) /b /cfif font size=-2Date: #DateFormat(lastupdate, MM/DD/YY)# Rev ##: cfif #revision# is 0Initialcfelse#revision#/cfif nbsp;nbsp;nbsp;nbsp;nbsp;/font font size=-1brb#docNumber#/bbr/font font size=-2Summary: i#Left(summary, 125)# nbsp;nbsp;nbsp;(a href=../docs/view.cfm?docID=#docID#see more/a)/i/font cfif ActionType NEQ 'R' cfform action=../docs/docActionLog.cfm?#CGI.QUERY_STRING# !--- cfif #startnum# GTE 15 --- input type=hidden name=hello value=#startnum# !--- cfelseif #count# GTE #next# input type=hidden name=next value=#startnum# --- !--- /cfif --- input type=hidden name=DocName value=#docName# input type=hidden name=DocID value=#DocID# input type=hidden name=DocAction value=R input type=submit value=I have reviewed and understand this document /cfform /cfif /p /cfoutput ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Training Powerpoints for Sales
(Cross-posting to talk) Folks - I have been asked to give a brief (15 minute) presentation to our sales staff in a couple of weeks about ColdFusion, why we selected it as our primary development platform, some of the things that we can do with it (we have CF8) and blurbs for overcoming typical obstacles. I know I've seen canned presentations in the past but does any one have something that's updated for CF7 or potentially CF8? Thanks! Hatton ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290957 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Exporting from ColdFuion to a Excel file
I didn't know that. That's really nice - I can see a lot of uses for this. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 12 October 2007 02:43 To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file Or, if the data is query data, use cfreport which can output to Excel. --- Ben -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:26 PM To: CF-Talk Subject: Re: Exporting from ColdFuion to a Excel file cfcontent type=application/vnd.ms-excel cfheader name=Content-Disposition value=filename=#filename#.xls cfoutput#pageContent#/cfoutput I assume this will still work on 8 Jerry On 10/11/07, Steve Sequenzia [EMAIL PROTECTED] wrote: Can someone please give me some insight into exporting data to excel using CF8. I am having issues with all the code I am trying. Any help would be great. Thanks ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Exporting from ColdFuion to a Excel file
On 10/12/07, Steve Sequenzia [EMAIL PROTECTED] wrote: If you hit yes it opens fine. I am just concerned that this will confuse users and they will not open it. In our environment, that's not a problem because if they want the file, they have to open it :) Otherwise, they can't do their jobs! I knowwhat you mean though I don't think it's important enough to personally worry about, but maybe the java POI method would work better. http://www.bennadel.com/blog/469-Creating-Microsoft-Excel-Files-Using-ColdFusion-And-POI.htm -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfsearch won't return suggestions-related keys in status structure
(CFMX 7) Using: cfsearch name=site_results type=internet collection=#request.verityspider# criteria=#verityKeywords# status=site_results_status suggestions=always ContextPassages = 1 ContextBytes = 200 maxrows=50 / I'm expecting the following keys in site_results_status *found *searched *time *suggestedQuery *keywords *keywordScore but I'm only getting the bare-bones keys: *found *searched *time What could be going wrong? It seems straightforward, but my experience doesn't match the docs. I filed a bug report with Adobe, but Adobe's bug list might be a rocky place, where my seed can find no purchase. Besides, maybe I'm just screwing something up, or maybe there's some undocumented caveats that you helpful folks might be able to point out. Thanks, Jamie ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Killing a login
The login script checks for a session variable, or presence of the cookie. The presence of the cookie should not be enough to be logged. Keep the userId in the cookie for user code preset in the login form, but use the session variable only to test for login done. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Killing a login
The login script checks for a session variable, or presence of the cookie. The presence of the cookie should not be enough to be logged. Keep the userId in the cookie for user code preset in the login form, but use the session variable only to test for login done. Absolutely. Use a session variable. Clear the variable on log-out and, if appropriate, expire the cookie. The trick is to check for the session variable on every secure page. If not... away you go evil hacker. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFSetting RequestTimeout Not Working
Thank you Rick, With that in mind that the Coldfusion doesn't start processing until after the file is completely posted perhaps it is a setting on the IIS? I don't see anything in the application log The specific error is when trying to upload a file that is approximatly 20 to 21 MB in size. The service just kicks back a message stating The operation has timed out I did do some logginging of times and it appears that after 1 minute and 40 seconds everything stops.. CF doesn't return an error and this is within a try catch. I think you are right that it isn't CF it is probably IIS? Any idea as to how I can increase this timeout programatically with VB? Thank you ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkbox validation
So it IS parsing the CFML. I was confused because you said : tried the list, but the tags also appeared in the output I think Charlie's got your answer. Rick On 10/12/07, Steve LaBadie [EMAIL PROTECTED] wrote: It's not parsing, the page is .cfm document. If a person choose all options it displays like this session1session2session3session4session5 The whole site is coldfusion, all other apps are working fine. I even tried using the delimiter=, attribute in the cfloop. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 2:14 PM To: CF-Talk Subject: Re: Checkbox validation You mean your output isn't parsing the CFML code? Either coldfusion isn't installed, or isn't installed properly, or you're not executing a file that coldfusion parses (ie, you've got CFML code on an .htm or .html file) Rick On 10/12/07, Steve LaBadie [EMAIL PROTECTED] wrote: I have created a form with checkboxes (the person can make multiple choices). Adult/Teen Classes: input type=checkbox name=adults value=session1 / Session 1: input type=checkbox name=adults value=session2 / Session2: input type=checkbox name=adults value=session3 / Session 3: input type=checkbox name=adults value=yoga / Session 4: input type=checkbox name=adults value=belly / Session 5: On the action page a created a loop to capture the responses; If the person makes multiple choices I would like them separated either by comas or displayed in a list Adult/Teen Classes: cfloop list=#form.adults# index=a#a#/cfloop I tried the list, but the tags also appeared in the output Adult/Teen Classes: ulcfloop list=#form.adults# index=alicfoutput#a#/cfoutput/li/cfloop/ul Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: Training Powerpoints for Sales
(Cross-posting to talk) Folks - I have been asked to give a brief (15 minute) presentation to our sales staff in a couple of weeks about ColdFusion, why we selected it as our primary development platform, some of the things that we can do with it (we have CF8) and blurbs for overcoming typical obstacles. I've been using cfpresenation lately. Seems to work fairly well. I've seen a couple of bugs, but it should handle your needs. Will ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Question
Actually I am going to stop re-inventing the wheel and go with an open source CMS. Claude Schneegans wrote: I would add a column hierarchyLevel and order by that column That won't do it: you can have element at the same level, but in completely distinct branches in the hierarchy. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to write this regex?
Wow... pretty complicated. Ok, then try this: CFSET myString='Some text here,b style=color:red; some text in bold/b and some othetext at the end' CF_REextract INPUTMODE = variable INPUT = myString RE1 = ^|| RE2 = ||$ OUTPUTMODE = query RECYCLE=yes CFSET finalString = CFLOOP QUERY=REextract CFIF String1 NEQ CFSET string2 = Replace(string2, , nbsp;, all) CFSET finalString = finalString Replace(string2, , nbsp;, all) CFELSE CFSET finalString = finalString string1 string2 string3 /CFIF /CFLOOP CFOUTPUT#HTMLEditFormat(finalString)#/CFOUTPUT -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to write this regex?
Not the end result.. the end result is just... #noBreak(str)# :-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFSetting RequestTimeout Not Working
It may not be a timeout issue but a upload throttle? I do not remember the exact numbers or how one configures it, but a search of the Microsoft - IIS knowledge base should turn up the details. That is where I have read about this issue. IIS has a maximum HTTP content size setting that can prevent very large uploads from going through. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excel, POI, and HTML Tables (was Re: Memory Issue)
It has been well over a year since I looked at this, but I also remember seeing memory issues when trying to create the Excel file via various cffunction calls. I had a process that created Excel files using POI functions that worked fine, and I wanted to make it more maintainable by dividing common routines up into functions. When I did this I believe I kept getting memory errors, which instead of trying to troubleshoot, I just reverted to the working code sans functions since I was under a deadline. You can apply styles to cells using POI, although it not as easy as creating HTML tables with CSS classes. I believe my hacking though POI was before Ben Nadel's POIUtility existed, since I don't remember having the benefit of a pre-built code library. -Mike Chabot On 10/12/07, Rick Root [EMAIL PROTECTED] wrote: Oh dear. I just attempted to use Ben Nadel's POUtility.cfc to create my excel spreadsheet. Couple of problems. #1 - it took 141 seconds instead of 45 seconds. 3x longer. #2 - it used almost 500 MB of RAM. 2x more. #3 - it had less functionality - my method of producing the file as HTML tables gave me column specific CSS control over each cell. Advantages: #1 - file size, 27MB versus 84MB #2 - no warning for Office 2007 users Back at CFUNITED, I asked the Coldfusion product manager if they had any intention of improving the speed of string concatenation. I told him that I was doing a lot of string concatenation to manufacture excel files via HTML tables. He basically blew me off, saying I should be using POI for that. (If you're reading this, yes, I felt like you blew me off). Now, this might not be POI's problem maybe it has something to do with the POIUtility.cfc, but my initial results don't look good. :( -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excel, POI, and HTML Tables (was Re: Memory Issue)
Well you do realize that whenever you use strings, and you modify it, a brand new string has to be created, since Strings in java are immutable. You should use some java code and use something like StingBuffer instead to build out your string. This should help with memory utilization. Russ -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 5:15 PM To: CF-Talk Subject: Re: Excel, POI, and HTML Tables (was Re: Memory Issue) It has been well over a year since I looked at this, but I also remember seeing memory issues when trying to create the Excel file via various cffunction calls. I had a process that created Excel files using POI functions that worked fine, and I wanted to make it more maintainable by dividing common routines up into functions. When I did this I believe I kept getting memory errors, which instead of trying to troubleshoot, I just reverted to the working code sans functions since I was under a deadline. You can apply styles to cells using POI, although it not as easy as creating HTML tables with CSS classes. I believe my hacking though POI was before Ben Nadel's POIUtility existed, since I don't remember having the benefit of a pre-built code library. -Mike Chabot On 10/12/07, Rick Root [EMAIL PROTECTED] wrote: Oh dear. I just attempted to use Ben Nadel's POUtility.cfc to create my excel spreadsheet. Couple of problems. #1 - it took 141 seconds instead of 45 seconds. 3x longer. #2 - it used almost 500 MB of RAM. 2x more. #3 - it had less functionality - my method of producing the file as HTML tables gave me column specific CSS control over each cell. Advantages: #1 - file size, 27MB versus 84MB #2 - no warning for Office 2007 users Back at CFUNITED, I asked the Coldfusion product manager if they had any intention of improving the speed of string concatenation. I told him that I was doing a lot of string concatenation to manufacture excel files via HTML tables. He basically blew me off, saying I should be using POI for that. (If you're reading this, yes, I felt like you blew me off). Now, this might not be POI's problem maybe it has something to do with the POIUtility.cfc, but my initial results don't look good. :( -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Concat Issue
I am probably being dense or showing my ignorance here, but I have a legacy database that I need to run a query on like the following. Can anyone tell me how I can achieve the following. Right now I am getting an error that PubYear is not a valid column. Thank you! SELECT AdINFO_Publication, ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear FROMcrAdInfo AND PubYear BETWEEN #dateformat(startdate,-mm-dd)# AND #dateformat(enddate,-mm-dd)# Any Help is appreciated. Thanks! ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Concat Issue
Try this SELECT AdINFO_Publication, ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear FROMcrAdInfo AND ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH + '-01' BETWEEN #dateformat(startdate,-mm-dd)# AND #dateformat(enddate,-mm-dd)# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 7:01 PM To: CF-Talk Subject: SQL Concat Issue I am probably being dense or showing my ignorance here, but I have a legacy database that I need to run a query on like the following. Can anyone tell me how I can achieve the following. Right now I am getting an error that PubYear is not a valid column. Thank you! SELECT AdINFO_Publication, ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear FROMcrAdInfo AND PubYear BETWEEN #dateformat(startdate,-mm-dd)# AND #dateformat(enddate,-mm-dd)# Any Help is appreciated. Thanks! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Encoding for cfmail containing japanese character problem
CFMAILPARAM NAME=Content-Type VALUE=text/plain; charset='utf-8' might work better. Thanks Paul... as always... you really i18n guru. and can these email services actually use utf-8 in your region? Hmm...I don't know have to find out... I also think they are not. in Japan still shift_JIS is the most popular I think. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to write this regex?
Thanks, Claude! I'll check it out! Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 3:10 PM To: CF-Talk Subject: Re: How to write this regex? Wow... pretty complicated. Ok, then try this: CFSET myString='Some text here,b style=color:red; some text in bold/b and some othetext at the end' CF_REextract INPUTMODE = variable INPUT = myString RE1 = ^|| RE2 = ||$ OUTPUTMODE = query RECYCLE=yes CFSET finalString = CFLOOP QUERY=REextract CFIF String1 NEQ CFSET string2 = Replace(string2, , nbsp;, all) CFSET finalString = finalString Replace(string2, , nbsp;, all) CFELSE CFSET finalString = finalString string1 string2 string3 /CFIF /CFLOOP CFOUTPUT#HTMLEditFormat(finalString)#/CFOUTPUT -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to write this regex?
Ok, Bobby... that works, thanks! However, now I have to use br whenever I want a carriage return. What about having it ignore the Chr(13) ? Rick -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 4:16 PM To: CF-Talk Subject: RE: How to write this regex? Not the end result.. the end result is just... #noBreak(str)# :-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Value concatenation
Candice, I think the problem is you're passing the Doc_Id value in two places: In the URL here cfform action=../docs/docActionLog.cfm?#CGI.QUERY_STRING# and again in a hidden form field input type=hidden name=DocID value=#DocID# That's why the DocID value is 16,16 instead of just 16. Try removing #CGI.QUERY_STRING# from the form action: cfform action=../docs/docActionLog.cfm? Janet ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using Japanese Text and CFIMAGE
Hey All, Anyone out there used CF8 and CFIMAGE to create dynamic images that contain Japanese (well,really any double byte text language. Russian, Chinese, etc...) text yet? I'm having no luck on it, any help would be greatly appreciated. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
test
Test message sent at Saturday, 13 October 2007 01:25:26 (a.m.) GMT ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
column totals
Hi there I have an application where I am outputing a number of sales figures for a year for various departments. Basically the table that I am outputing is in this format: Dept July Aug SepOctNov DecTotal A 23 24 20 18 15 50 150 B 20 20 20 20 20 20 120 C 10 10 10 10 10 10 60 Total xxx xxx xxx xxx xxx xxx xxx Basically I have not had any trouble creating the total for the end of the row - I have created an array and just added to the array and then I get the total. I am struggling with obtaining the total for the bottom of the columns. What would be the most efficient way to do this. Thanks in advance. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Encoding for cfmail containing japanese character problem
NUGROHO NOTO wrote: and can these email services actually use utf-8 in your region? Hmm...I don't know have to find out... I also think they are not. in Japan still shift_JIS is the most popular I think. for yahoo you'll usually get whatever region you signed up for, doesn't matter where their servers are (though i bet they have some in japan). hotmail used to have utf-8 issues but it's been a while since anybody's complained. send me an example of the email off-list that causes problems i'll have a look sunday--off to do my century today ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to write this regex?
Well for display, you would have to use a BR for a line break anyway... unless its wrapped in pre tags... If you still need to... you could just replace #chr(13)##chr(10)# with br / beforehand then put them back afterwards. Before replace(str, #chr(13)##chr(10)#, br /, all) After replace(str, br /, #chr(13)##chr(10)#, all) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 7:17 PM To: CF-Talk Subject: RE: How to write this regex? Ok, Bobby... that works, thanks! However, now I have to use br whenever I want a carriage return. What about having it ignore the Chr(13) ? Rick -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 4:16 PM To: CF-Talk Subject: RE: How to write this regex? Not the end result.. the end result is just... #noBreak(str)# :-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
New releases
Just a quick note about some new releases that might be of interest: Galleon 2 http://www.coldfusionjedi.com/index.cfm/2007/10/12/Update-3-Galleon-2 Major new release of my ColdFusion forums. BlogCFC 5.9 http://www.coldfusionjedi.com/index.cfm/2007/10/12/Update-2-BlogCFC-59 Minor update - but covers a LOT of bugs. toXML http://www.coldfusionjedi.com/index.cfm/2007/10/12/Update-1-toXML Minor update to my CFC which helps you generate XML from CFML datatypes. -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT Sys-con at it again
Somehow I knew that it wouldn't take long, considering what a nobody this guy is (if it's even a real person). On 10/12/07, Brad Wood [EMAIL PROTECTED] wrote: Lol. You're approach is working already... http://www.google.com/search?hl=enq=James+Hamilton+sys-conbtnG=Search First result. ~Brad ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to write this regex?
I ended up trying this #replace(noBreak(txt), #Chr(13)#, br /, All)# and it works fine... is that what you were getting at below? I didn't quite understand the before and after aspect. Rick -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:19 PM To: CF-Talk Subject: RE: How to write this regex? Well for display, you would have to use a BR for a line break anyway... unless its wrapped in pre tags... If you still need to... you could just replace #chr(13)##chr(10)# with br / beforehand then put them back afterwards. Before replace(str, #chr(13)##chr(10)#, br /, all) After replace(str, br /, #chr(13)##chr(10)#, all) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 7:17 PM To: CF-Talk Subject: RE: How to write this regex? Ok, Bobby... that works, thanks! However, now I have to use br whenever I want a carriage return. What about having it ignore the Chr(13) ? Rick -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 4:16 PM To: CF-Talk Subject: RE: How to write this regex? Not the end result.. the end result is just... #noBreak(str)# :-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4