CFGRID Select Row
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 ~| 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:290840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Set Coldfusion Variable using AJAX
Whats the code look like Aaron? You should be able to make a Ajax call and pass a param as part of the query string to your CF page. Rey Aaron Bodell wrote: I have a javascript variable set to the current selected row of a table (can't use cfgrid for this one). I need to pass that variable to a cfc for binding to a query. I can't seem to force it. I've tried setting an invisible field value, and then asynch submit the form, but with no luck. What is the right way to accomplish this? Aaron Thanks for your suggestion, Rey. I finally restarted the page using the example from the cfajaxproxy page in the documentation. I discovered that I had a problem with my SQL syntax that wasn't allowing the completion of the request. I'm such a newbie! Aaron ~| 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:290841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Set Coldfusion Variable using AJAX
Whats the code look like Aaron? You should be able to make a Ajax call and pass a param as part of the query string to your CF page. Thanks for your suggestion, Rey. I finally restarted the page using the example from the cfajaxproxy page in the CF8 documentation. I discovered that I had a problem with my SQL syntax that wasn't allowing the completion of the request. I'm such a newbie! Aaron ~| 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:290842 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 create a SQL query above 2 tablespaces?
Stivn .. wrote: i want to create a SQL query above 2 tablespaces. A tablespace is an implementation detail of your SQL server that does not influence the logical database stucture so you would query it the same way as you would a single tablespace. Jochem ~| 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:290844 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 cfqueryparam cfprocparam dodge all known SQL Injection attack?
henry ho wrote: After reading the following pages... The Unexpected SQL Injection - When Escaping Is Not Enough http://webappsec.org/projects/articles/091007.shtml SQL Injection Cheat Sheet http://ferruh.mavituna.com/makale/sql-injection-cheatsheet/ I wonder if our beloved cfqueryparam and cfprocparam are strong enough to defend all of the attacks mentioned in the pages above. If you use them in *all* SQL statements you execute they are. But read and make sure you understand the part about second order SQL injection attacks because it adds a twist to *all*. Jochem ~| 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:290843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Coding Standards
Gaulin, Mark wrote: What I would find more interesting is something approaching a coding style validator for important things, like varing local variables in functions and always scoping variables properly (to the degree that I would want), checking for cfparam tags for url, form, and attribute variables, etc. I have experimented with a SVN hook that ran several checks including Mike Schierberl's vasrScoper and an attempt to compile the code with cfcompile.bat before allowing a commit. It wasn't exactly production quality, but it can be done. Jochem ~| 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:290845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Invoking component
Jeez, Sorry chaps, It would appear that my British Telecom SMTP server was playing up yesterday and duplicating the damn things, it 'appears' to be much better this morning. Sorry for all the trouble. Rob -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 10 October 2007 22:26 To: CF-Talk Subject: Re: Invoking component Damn, I replied to the wrong thread . . and you've got a severe hiccup? -- ___ 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:290846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Coding Standards / validation
On Wednesday 10 Oct 2007, [EMAIL PROTECTED] wrote: It's always on topic to show how much better ColdFusion is :-) Not better. Just different. It is never better to have humans do garbage collection and memory allocation. Studies have been done, and compilers are much, much quicker at it and make fewer errors. -- 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:290847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Security / Vulnerabilities
On Thursday 11 Oct 2007, [EMAIL PROTECTED] wrote: Looking through my logs I came across these strange things. Some of which I know a are vulnerabilities some I had to google to figure out, but some just leave me baffled like FN1rFWvfUWgo.cfm and wzryve7i.cfm. Anyone shed any light on these? Testing your site wide error/404 handler to see if it reveals too much about you. -- 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:290848 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
i am working on the same issue... will post my findings [if any...] later... Azadi 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 ~| 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:290849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OOP Coldfusion
Hi All, I'm working on an OOP project and am having a bit of a problem with objects referencing each other. My folder structure is /siteRoot/ /siteRoot/core (Where all my classes are) /siteRoot/core/valueObjects I'm quite early on in the build so I'm just setting up my value classes. I've got two classes in there, one called Page, the other called Head. Back at the root I'm instantiating these classes in a cfm file called testing. cfset page = CreateObject(component,core.valueObjects.Page).init() cfset head = CreateObject(component,core.valueObjects.Head).init(title:This is a new title) So far so cool. The problem is that one of the properties of the Page class is a Head object. This is populated with this function in the Page class cffunction name=setHead access=public hint=Sets the Head Object cfargument name=head type=core.valueObjects.Head required=yes cfset variables.head = ARGUMENTS.head /cffunction However when I call the function from the testing page with : cfset page.setHead(head) I get an error : - The HEAD argument passed to the setHead function is not of type core.valueObjects.Head. When as far as I'm concerned it is. The fix I came up with is to change the argument in the setHead function to be only Head. Now this sort of works as Page and Had live in the same folder, but I can see problems further down the line unless I get this clear in my head. So am I a - doing this wrong, should there be a special place or method of creating CF classes where they can reference each other with complete class paths? b - Just accept that the classes can only reference each other relatively? c - Go back to actionscript and stop pretending to be a server side coder? Thanks in advance Tim ~| 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:290850 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
Dale, Should read my blog more then:-) If you followon from my Grid example, and use the extJS docs you would get the following. var grid = ColdFusion.Grid.getGridObject('NameOfGrid'); grid.getSelectionModel().getSelected() Will return the record store of the selected row. btw if you use Firefox and firebug, you can type the following into the console of firebug. grid, which will dump the structure of the grid to get all its properties and methods. And you can drill into the getSelectionModel and see the same for the methods etc for that. but for more info your best bet is go to extJS.com and the info is all there. On 10/11/07, Dale Fraser [EMAIL PROTECTED] 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 ~| 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:290851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFGRID Select Row
well, that's all good and all, but how about pre-selecting a specific row??? your code will return record store of the selected row... how about when no row is yet selected??? Azadi Andrew Scott wrote: Dale, Should read my blog more then:-) If you followon from my Grid example, and use the extJS docs you would get the following. var grid = ColdFusion.Grid.getGridObject('NameOfGrid'); grid.getSelectionModel().getSelected() Will return the record store of the selected row. btw if you use Firefox and firebug, you can type the following into the console of firebug. grid, which will dump the structure of the grid to get all its properties and methods. And you can drill into the getSelectionModel and see the same for the methods etc for that. but for more info your best bet is go to extJS.com and the info is all there. On 10/11/07, Dale Fraser [EMAIL PROTECTED] 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 ~| 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:290852 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? / Regex needed...
Any Regex gurus care to lend a hand with this one? Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 9:53 PM To: CF-Talk Subject: Re: Why does this code disable styling? use REReplace() with a regex to replace spaces only outside and . will write one for you later if nobody else does... Azadi Rick Faircloth wrote: No, it's just text with the b style=color:red;SITE DEVELOPMENT/b around it. But after looking at the source I figured out what was going on. The spaces inside the style code are also being changed to nbsp; . So, in the source it looks like this: bnbsp;style=color:red;nbsp;font-size:14px; which is non-functional. The question is... how do I replace just the spaces, or the chr(32) characters in the text with something that won't affect the code? Is there any other code I can add to the b style=... which will cause it to be parsed as code and not text? Something like, codeb style=color:red;/codeSITE DEVELOPMENTcode/b/code ??? 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:290853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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.html 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 ~| 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:290854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Coding Standards / validation / CFML pasring
I've been thinking about what a CFML parser has to do and man, it isn't all that easy... I'm not sure any .cfm file could be parsed properly without knowing the state of cfoutput before the file is (potentially) cfincluded. In other words, if you see some text like this is text#hi# and some more, how can you be sure that #hi# represents a variable interpolation (so, hi must be a variable, and it is apparently not scoped) vs plain text that just happens to contain the literal string #hi#.Of even worse, perhaps, would be a run of text like this is some text#here is some more... Is there is a missing # after the variable here (so, a syntax error), or not? And when should ## be converted to the plain text #? All of these issues require the correct determination of the cfoutput state, and the potential to cfinclude any file makes that pretty hard to do on a file-by-file basis... You almost need to know which .cfm files are real pages (mapped to urls) and which are support files (custom tags or cfincludes). And that is not even considering the problem of simply having to keep track of cfoutput tags within a single file, which would have to be done properly (including cffunction output=x tags). This could definitely get tricky! I imagine it is possible to use the compiled classes that CF makes to get a better idea of how to parse things but that would not allow CFEclipse (or some other plugin) to take advantage of such a parser. I wonder if Macromedia would ever release a parser (say, in java) to the open source community, as a way of stimulating third-party plugin and tool development... Thanks Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 3:46 AM To: CF-Talk Subject: Re: CF Coding Standards Gaulin, Mark wrote: What I would find more interesting is something approaching a coding style validator for important things, like varing local variables in functions and always scoping variables properly (to the degree that I would want), checking for cfparam tags for url, form, and attribute variables, etc. I have experimented with a SVN hook that ran several checks including Mike Schierberl's vasrScoper and an attempt to compile the code with cfcompile.bat before allowing a commit. It wasn't exactly production quality, but it can be done. 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:290855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
The quick way to fix this issue is to just set the argument type to any. Coldfusion is dynamic and can handle that just fine. However, this can make debugging the app more difficult because instead of getting a helpful type-casting error, you may get something like tthe method cannot be found, further down the line of code execution. The slower way to fix this issue, and probably the better in the long run way, would be to learn and use ColdSpring to handle your object instantiation and dependencies. Using ColdSpring, you would declare the classes and their dependencies in an xml file and then do something like cfset page = application.CSFactory.getBean('page') / It will already have an instance of head in it because of the xml declarations. Matt On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Hi All, I'm working on an OOP project and am having a bit of a problem with objects referencing each other. My folder structure is /siteRoot/ /siteRoot/core (Where all my classes are) /siteRoot/core/valueObjects I'm quite early on in the build so I'm just setting up my value classes. I've got two classes in there, one called Page, the other called Head. Back at the root I'm instantiating these classes in a cfm file called testing. cfset page = CreateObject(component,core.valueObjects.Page).init() cfset head = CreateObject(component,core.valueObjects.Head).init(title:This is a new title) So far so cool. The problem is that one of the properties of the Page class is a Head object. This is populated with this function in the Page class cffunction name=setHead access=public hint=Sets the Head Object cfargument name=head type=core.valueObjects.Head required=yes cfset variables.head = ARGUMENTS.head /cffunction However when I call the function from the testing page with : cfset page.setHead(head) I get an error : - The HEAD argument passed to the setHead function is not of type core.valueObjects.Head. When as far as I'm concerned it is. The fix I came up with is to change the argument in the setHead function to be only Head. Now this sort of works as Page and Had live in the same folder, but I can see problems further down the line unless I get this clear in my head. So am I a - doing this wrong, should there be a special place or method of creating CF classes where they can reference each other with complete class paths? b - Just accept that the classes can only reference each other relatively? c - Go back to actionscript and stop pretending to be a server side coder? Thanks in advance Tim ~| 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:290859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFGRID Select Row
Well I thought the hint was in the using of firefox and its plugin fireDebug, use the console to type the var name of the grid and you get to see all methods and properties. How much more does one need to spell it out, when all the docs are also on extJS:-) And the reverse of get is set is it not:-) On 10/11/07, Azadi Saryev [EMAIL PROTECTED] wrote: well, that's all good and all, but how about pre-selecting a specific row??? your code will return record store of the selected row... how about when no row is yet selected??? Azadi Andrew Scott wrote: Dale, Should read my blog more then:-) If you followon from my Grid example, and use the extJS docs you would get the following. var grid = ColdFusion.Grid.getGridObject('NameOfGrid'); grid.getSelectionModel().getSelected() Will return the record store of the selected row. btw if you use Firefox and firebug, you can type the following into the console of firebug. grid, which will dump the structure of the grid to get all its properties and methods. And you can drill into the getSelectionModel and see the same for the methods etc for that. but for more info your best bet is go to extJS.com and the info is all there. On 10/11/07, Dale Fraser [EMAIL PROTECTED] 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:290856 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
Anyone got any ideas here? On 10/10/07, Rick Root [EMAIL PROTECTED] wrote: I'm trying to discover why a piece of code that I run causes my JVM memory usage to go up about 400MB. I'm using CF8... I'm not sure how to debug this. Basically I've got an event gateway request that generates an excel file (via HTML tables). I do a lot of string appends and i'm using the java stringbuffer method. Some of the memory usage is the query - in my test case, the CF8 server monitor says the query is about 50 megabytes. But obviously, something I'm doing in the looping through that query is sucking up memory. Here's a simplified example of the code in the loop... fileOutput is a java StringBuffer object.. the purpose of using the StringBuffer is because string concatenation in CF is very slow when done in high quantities. cfloop query=resultSet cfset fileOutput.append(START_ROW) cfloop list=#fields# index=ThisCol cfset fileOutput.append(replace(START_FIELD,___COLNAME___,ThisCol,ALL)) cfset fileOutput.append( resultSet[ThisCol][resultSet.currentRow] ) cfset fileOutput.append(END_FIELD) /cfloop cfset fileOutput.append(END_ROW) cfif currentRow MOD 500 is 0 cflog log=APPLICATION text=Looping, currentrow = #currentRow# cflog log=APPLICATION text=Writing data to file, length: #fileOutput.length()# cfset fileWrite(fh, fileOutput.toString()) cfset fileOutput.delete(0,fileOutput.length()) /cfif /cfloop The total file size, when the job is complete, is about 84 megabytes. At the time the fileWrite() call takes place, the fileOutput variable contains about 3,000,000 characters (3mb) Anyone got any ideas here? -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com -- 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:290857 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
Just a stab here, but maybe instead of using cfset's you can re-write into a cfscript block? Also, if this is in a cfc, be sure you have var-scoped every variable (even temp ones) Just some idea's off the cuff =) You could always post the entire pertinent code to some place like cfm.pastebin.com Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 10:08 AM To: CF-Talk Subject: Re: Memory Issue Anyone got any ideas here? On 10/10/07, Rick Root [EMAIL PROTECTED] wrote: I'm trying to discover why a piece of code that I run causes my JVM memory usage to go up about 400MB. I'm using CF8... I'm not sure how to debug this. Basically I've got an event gateway request that generates an excel file (via HTML tables). I do a lot of string appends and i'm using the java stringbuffer method. Some of the memory usage is the query - in my test case, the CF8 server monitor says the query is about 50 megabytes. But obviously, something I'm doing in the looping through that query is sucking up memory. Here's a simplified example of the code in the loop... fileOutput is a java StringBuffer object.. the purpose of using the StringBuffer is because string concatenation in CF is very slow when done in high quantities. cfloop query=resultSet cfset fileOutput.append(START_ROW) cfloop list=#fields# index=ThisCol cfset fileOutput.append(replace(START_FIELD,___COLNAME___,ThisCol,ALL)) cfset fileOutput.append( resultSet[ThisCol][resultSet.currentRow] ) cfset fileOutput.append(END_FIELD) /cfloop cfset fileOutput.append(END_ROW) cfif currentRow MOD 500 is 0 cflog log=APPLICATION text=Looping, currentrow = #currentRow# cflog log=APPLICATION text=Writing data to file, length: #fileOutput.length()# cfset fileWrite(fh, fileOutput.toString()) cfset fileOutput.delete(0,fileOutput.length()) /cfif /cfloop The total file size, when the job is complete, is about 84 megabytes. At the time the fileWrite() call takes place, the fileOutput variable contains about 3,000,000 characters (3mb) Anyone got any ideas here? -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com -- 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:290858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Request timeout
In the coldfusion administrator all the event gateways are defaulted to timeout after 30 seconds additionally in CF8 if you use the flex messaging gateway the default is NOT to kill the thread on a timeout... I believe that cfsetting only works within .cfm pages. You could bump up the timeout on the flexmessaging gateway in the CF admin... -- Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:290861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8 Dev running very slow
Hi Bill, We need more info on this to debug the problem: What is the JDK you are using? What is the max JVM memory(Xmx)? When you run the CF file (which runs as slow as 20s), can you collect multiple thread dumps when the request is getting processed and send the thread dumps to me? Please send the CFM as well. Can you also try with a simple CF file (just containing a cfoutput tag) and find out if it is slow? If it is, then please send multiple thread dumps to this test too. BTW, turn off server monitoring completely. Check if it is still slow. Thanx -Manjukiran ColdFusion Product Team Adobe -Original Message- From: Bill Betournay [mailto:[EMAIL PROTECTED] Sent: Friday, October 05, 2007 6:00 AM To: CF-Talk Subject: CF8 Dev running very slow My local dev edition of CF8 is running very slow. Like 15 20 sec to render very simple cf files. Some of my files (again very simple code and queries) are up around 2000 3000 ms. Anyone know of obviously things I can look for to help speed things up?? I do have debugging enabled and realize that slows things down a little but it shouldn't slow it down that much. Specs ASUS MB 800Mhz FSB 4 Gb DDR2 Dual Channel ram WIN XP Pro SP2 CF8 Bill ~| 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:290860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: flash form and spry tabs
Will, Did you set the timeout value on the cfform tag? It defaults to 0 which would probably result in you receiving that error. cfform name=myform format=flash timeout=300 Regards, -- Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:290862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
Tim, I am not 100% sure, but I have come across this before and I think it has to do with loading the cfc from the current directory. Others like Sean might give a better explanation, but my fix has been to create a mapping for core or to use /core.package.component. On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Hi All, I'm working on an OOP project and am having a bit of a problem with objects referencing each other. My folder structure is /siteRoot/ /siteRoot/core (Where all my classes are) /siteRoot/core/valueObjects I'm quite early on in the build so I'm just setting up my value classes. I've got two classes in there, one called Page, the other called Head. Back at the root I'm instantiating these classes in a cfm file called testing. cfset page = CreateObject(component,core.valueObjects.Page).init() cfset head = CreateObject(component,core.valueObjects.Head).init(title:This is a new title) So far so cool. The problem is that one of the properties of the Page class is a Head object. This is populated with this function in the Page class cffunction name=setHead access=public hint=Sets the Head Object cfargument name=head type=core.valueObjects.Head required=yes cfset variables.head = ARGUMENTS.head /cffunction However when I call the function from the testing page with : cfset page.setHead(head) I get an error : - The HEAD argument passed to the setHead function is not of type core.valueObjects.Head. When as far as I'm concerned it is. The fix I came up with is to change the argument in the setHead function to be only Head. Now this sort of works as Page and Had live in the same folder, but I can see problems further down the line unless I get this clear in my head. So am I a - doing this wrong, should there be a special place or method of creating CF classes where they can reference each other with complete class paths? b - Just accept that the classes can only reference each other relatively? c - Go back to actionscript and stop pretending to be a server side coder? Thanks in advance Tim ~| 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:290863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ANN: Introducing Validat - A Data Validation Engine for ColdFusion
I would like to introduce Validat, an open source data validation engine for ColdFusion being developed by Alagad http://www.alagad.com/ . The code is currently available and marked as Alpha until I can get some more documentation written (the bane of every open source project!). Once the initial pass at the documentation is complete, we already have a refactoring planned, but I want to get your input and feedback. So, take a look when you have a spare moment and let us know what you like and don't like. Where do I find more information? A Trac site has been setup for the project at http://trac.alagad.com/Validat and this site contains the information currently available about Validat and will continue to be added to over the coming days and weeks. To get the source for Validat, an anonymous SVN repository is available at http://svn.alagad.com/Validat. The main trunk is all there is at the moment. We will start adding tags as development progresses and the code gets tighter. To ask any questions or provide feedback, a Google Group site has been setup as well at http://groups.google.com/group/Validat. Please sign up and fire away with your questions or comments. An Overview of Validat Validat is a data validation engine that is broken up into 3 parts ... a collection of pluggable validators, one or more data transformers and one or more data set configurations. The validators allow you to build your own custom validation rules. This could be as simple as checking that a given data field (element) contains a value or as complex as running tests based upon multiple data fields, talking to a database or web service, etc. The idea is that no validation framework can imagine every possible test, so this allows you to easily add your own validation routines. The data transformers abstract out the concept of where the data being validated is coming from. This way, we can have a simple form structure transformer that knows to retrieve data out of the form scope and send it to the validation engine. We also have a basic bean transformer that inspects a bean and grabs its data based upon each getter method. The goal here again is abstracting out where the data is coming from so if you prefer to validate beans vs. form data, you can do whatever you wish. The last piece to the puzzle is the data set configuration. Basically what this is is a mapping between data elements and validation rules. For example, the firstName data element requires the required valdiator to be run. Through this mapping your can also setup mappings between groups of fields - for example a validation rule for the firstName, lastName, and emailAddress data elements to determine if they represent a unique user. This mapping can be setup via an XML configuration or via a programmatic API if you want to store and manage the rules via your application (a dynamically built form for example). More information is to come via the Trac site http://trac.alagad.com/Validat and again, in the mean time, feel free to post a question or comment in the Validat Google Groups http://groups.google.com/group/Validat site. Thank you for your time. -- Jeff Jeff Chastain Senior Software Developer Alagad, Inc. http://www.alagad.com www.alagad.com 1-888-ALAGAD4 ext. 4 ~| 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:290866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 ~| 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:290865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OOP Coldfusion
Thanks for the reply Matt, I have to confess I'm not particularly looking forward to learning a framework. I was sort of hoping that defining class paths to cfcs would be a setting somewhere.. I ColdSpring sounds cool tho, I'll check it out. Thanks again Tim -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: 11 October 2007 15:17 To: CF-Talk Subject: Re: OOP Coldfusion The quick way to fix this issue is to just set the argument type to any. Coldfusion is dynamic and can handle that just fine. However, this can make debugging the app more difficult because instead of getting a helpful type-casting error, you may get something like tthe method cannot be found, further down the line of code execution. The slower way to fix this issue, and probably the better in the long run way, would be to learn and use ColdSpring to handle your object instantiation and dependencies. Using ColdSpring, you would declare the classes and their dependencies in an xml file and then do something like cfset page = application.CSFactory.getBean('page') / It will already have an instance of head in it because of the xml declarations. Matt On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Hi All, I'm working on an OOP project and am having a bit of a problem with objects referencing each other. My folder structure is /siteRoot/ /siteRoot/core (Where all my classes are) /siteRoot/core/valueObjects I'm quite early on in the build so I'm just setting up my value classes. I've got two classes in there, one called Page, the other called Head. Back at the root I'm instantiating these classes in a cfm file called testing. cfset page = CreateObject(component,core.valueObjects.Page).init() cfset head = CreateObject(component,core.valueObjects.Head).init(title:This is a new title) So far so cool. The problem is that one of the properties of the Page class is a Head object. This is populated with this function in the Page class cffunction name=setHead access=public hint=Sets the Head Object cfargument name=head type=core.valueObjects.Head required=yes cfset variables.head = ARGUMENTS.head /cffunction However when I call the function from the testing page with : cfset page.setHead(head) I get an error : - The HEAD argument passed to the setHead function is not of type core.valueObjects.Head. When as far as I'm concerned it is. The fix I came up with is to change the argument in the setHead function to be only Head. Now this sort of works as Page and Had live in the same folder, but I can see problems further down the line unless I get this clear in my head. So am I a - doing this wrong, should there be a special place or method of creating CF classes where they can reference each other with complete class paths? b - Just accept that the classes can only reference each other relatively? c - Go back to actionscript and stop pretending to be a server side coder? Thanks in advance Tim ~| 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:290864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
Also, as Matt said, this sort of thing screams ColdSpring: cfset page = CreateObject(component,core.valueObjects.Page).init() cfset head = CreateObject(component,core.valueObjects.Head).init(title:This is a new title) cfset page.setHead(head) Trust me, if you're serious about building OO CFC-based apps, this only going to get worse and worse. Save yourself a lot of pain and just learn ColdSpring right now. ;-) On 10/11/07, Brian Kotek [EMAIL PROTECTED] wrote: You can try clearing the template cache in the CF administrator. Sometimes the way CF stores CFCs in its cache can screw things up when it comes to typing if you have moved things around, changed names, or instantiated the same component from multiple folders. It thinks the type is pointing somewhere else. On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Thanks for the reply Matt, I have to confess I'm not particularly looking forward to learning a framework. I was sort of hoping that defining class paths to cfcs would be a setting somewhere.. I ColdSpring sounds cool tho, I'll check it out. Thanks again Tim ~| 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:290868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
You can try clearing the template cache in the CF administrator. Sometimes the way CF stores CFCs in its cache can screw things up when it comes to typing if you have moved things around, changed names, or instantiated the same component from multiple folders. It thinks the type is pointing somewhere else. On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Thanks for the reply Matt, I have to confess I'm not particularly looking forward to learning a framework. I was sort of hoping that defining class paths to cfcs would be a setting somewhere.. I ColdSpring sounds cool tho, I'll check it out. Thanks again Tim ~| 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:290867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
Tim Did you try and set up a mapping to the top level of your components directory? Frame works are a good thing, they take a lot of these types of questions away from you so you can concentrate on what it is you need to concentrate on, that being the solution to the problem. Whether its Mach-2, FuseBox, Model-Glue, ColdSpring or IrishSpring (just joking on this one) they all have their pros and cons. Asking which one is better will end up in a fire storm debate :) Try ColdSpring if you like how it works use it, otherwise try another and so on. Yes it takes time but you are the best person to judge which one best fits with how you think. Regards, -- Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:290869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OOP Coldfusion
Just to be clear though, ColdSpring is a dependency injection framework for your model and has nothing to do with the front controller frameworks like Mach-II or Fusebox. They do totally different things (ColdSpring works with any of the front-controller frameworks, or with no framework at all). On 10/11/07, gary gilbert [EMAIL PROTECTED] wrote: Whether its Mach-2, FuseBox, Model-Glue, ColdSpring or IrishSpring (just joking on this one) they all have their pros and cons. Asking which one is better will end up in a fire storm debate :) Try ColdSpring if you like how it works use it, otherwise try another and so on. ~| 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:290870 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?
#replace(replace(get_events.event_description, #chr(13)#, br, All), #chr(32)#, nbsp;, All)# You are using unnecessary # in this expression, use instead: #replace(replace(get_events.event_description, chr(13), br, All), chr(32), nbsp;, All)# But it is not the source of your problem Anyway, the code above works fine, but it disables my b style=color:red;/b code. No bold and no red. Of course, you are also replacing the space in b style=color:red; by bnbsp;style=color:red; which is an illegal tag. -- ___ 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:290871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OOP Coldfusion
Hi Gary et al, Thanks for everyone's help. I managed to solve the problem, I assumed my mapping was working when it wasn't :( After changing the mapping all sorted. I'm going to look into Coldspring and the other frameworks in more detail, but as I'm still nowhere near being a CF nerd yet, and as the app I'm creating isn't too involved, I'm going to continue as I am as a learning exercise in CF. Once I've got my head a bit more round that then I should be able to relate what I've learnt across to the frameworks. It's sort of the way my brain works.. Having said that tho - which is the best framework? *ducks* Only joking ;) -Original Message- From: gary gilbert [mailto:[EMAIL PROTECTED] Sent: 11 October 2007 16:15 To: CF-Talk Subject: Re: OOP Coldfusion Tim Did you try and set up a mapping to the top level of your components directory? Frame works are a good thing, they take a lot of these types of questions away from you so you can concentrate on what it is you need to concentrate on, that being the solution to the problem. Whether its Mach-2, FuseBox, Model-Glue, ColdSpring or IrishSpring (just joking on this one) they all have their pros and cons. Asking which one is better will end up in a fire storm debate :) Try ColdSpring if you like how it works use it, otherwise try another and so on. Yes it takes time but you are the best person to judge which one best fits with how you think. Regards, -- Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:290872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: flash form and spry tabs
Ah. There we go. Thanks Gary, worked a treat. will -Original Message- From: gary gilbert [mailto:[EMAIL PROTECTED] Sent: 11 October 2007 15:32 To: CF-Talk Subject: Re: flash form and spry tabs Will, Did you set the timeout value on the cfform tag? It defaults to 0 which would probably result in you receiving that error. cfform name=myform format=flash timeout=300 Regards, -- Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:290873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8 Dev running very slow
Hi Bill, You could also consider using Server Monitoring feature to track down your requests, especially sort of things like, which part of your code taking what amount of time. Is it the case that your requests are slow only for the first request to the template and then it runs smoother? If yes, it is because of the compilation of templates on the first request. Once all your templates are compiled and cached, you will see a faster serving. Jayesh Viradiya Adobe CF Team ~| 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:290875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Splitting UI and Data
Yes, I'm glad that all of you convinced me to carry on with Fusebox. I have just seen the light. it was a hard start. Maybe because I had install Fusebox 5.1 and the tutorial was written for Fusebox4. But when I got it to work it was very nice. I very much like the way that the fuse action is setup and the exit parameter is defined. Top nice. Iâm about to run a tutorial about database and later on the MVC. ~| 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:290874 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?
Of course, you are also replacing the space in b style=color:red; by bnbsp;style=color:red; which is an illegal tag. Yeah, I figured that out after reviewing source. Azadi suggested I need an regex to change all the spaces to nbsp; except those within the and so the code is untouched. Know how to regex that, Claude? If so, care to whip one out for me? If I have to choose, I'll just leave out the styling code. Maintaining space integrity is more important. Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 11:55 AM To: CF-Talk Subject: Re: Why does this code disable styling? #replace(replace(get_events.event_description, #chr(13)#, br, All), #chr(32)#, nbsp;, All)# You are using unnecessary # in this expression, use instead: #replace(replace(get_events.event_description, chr(13), br, All), chr(32), nbsp;, All)# But it is not the source of your problem Anyway, the code above works fine, but it disables my b style=color:red;/b code. No bold and no red. Of course, you are also replacing the space in b style=color:red; by bnbsp;style=color:red; which is an illegal tag. ~| 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:290876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dates with Query of Query
I am trying to do a query of a SQL Server query with ColdFusion 8 but I am having trouble getting it to filter on dates. I have tried a few different things, but nothing seems to work. It doesn't throw an error, it just doesn't select records that I think it should find. I want it to get records that have a date/time of a given day. My latest iteration is using BETWEEN, but its not working either: CFQUERY name=getTaskQuery dbtype=query SELECT * FROM toDoQuery WHERE reminderDate between cfqueryparam cfsqltype=cf_sql_date value=#createodbcdatetime(createDateTime(year(now()),month(now()),day(now()),0,0,0))# and cfqueryparam cfsqltype=cf_sql_date value=#createodbcdatetime(createDateTime(year(now()),month(now()),day(now()),11,59,59))# /CFQUERY Thank you - Don't let your dream ride pass you by.Make it a reality with Yahoo! Autos. ~| 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:290877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OOP Coldfusion
On 10/11/07, Matt Williams [EMAIL PROTECTED] wrote: On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Having said that tho - which is the best framework? ColdMachTransfer-ReactorFuseGlue But be sure to get the BER from SVN or CVS or Walgreens, or something. :P -- Matt Williams It's the question that drives us. ~| 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:290879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Having said that tho - which is the best framework? ColdMachTransfer-ReactorFuseGlue -- Matt Williams It's the question that drives us. ~| 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:290878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Returns the value, 16,16?? Please help!
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 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:290880 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!
honestly, I haven't read the code posted, but I can say with certainty that you get a comma-delimited list in a single form field if you are submitting it twice. You'll get smarter answers if you say some words in your post. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.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:290881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 ~| 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:290882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Question about getHttpRequestData() function
Does anyone know the underlying Java functions used for this? I've got someone asking me how they can get Java to do the same thing CF does when it receives a 'form' submission. How could I execute this same functionality for example if I created a java object? Thanks, Dave ~| 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:290883 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?
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. ~| 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:290884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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:290885 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
Maybe replace the cfset fileOutput.delete(0,fileOutput.length()) With: cfset fileOutput.setLength(0) It would probably take less processing. Mark On 10/11/07, Rick Root [EMAIL PROTECTED] wrote: I'm trying to discover why a piece of code that I run causes my JVM memory usage to go up about 400MB. I'm using CF8... I'm not sure how to debug this. Basically I've got an event gateway request that generates an excel file (via HTML tables). I do a lot of string appends and i'm using the java stringbuffer method. Some of the memory usage is the query - in my test case, the CF8 server monitor says the query is about 50 megabytes. But obviously, something I'm doing in the looping through that query is sucking up memory. Here's a simplified example of the code in the loop... fileOutput is a java StringBuffer object.. the purpose of using the StringBuffer is because string concatenation in CF is very slow when done in high quantities. cfloop query=resultSet cfset fileOutput.append(START_ROW) cfloop list=#fields# index=ThisCol cfset fileOutput.append(replace(START_FIELD,___COLNAME___,ThisCol,ALL)) cfset fileOutput.append( resultSet[ThisCol][resultSet.currentRow] ) cfset fileOutput.append(END_FIELD) /cfloop cfset fileOutput.append(END_ROW) cfif currentRow MOD 500 is 0 cflog log=APPLICATION text=Looping, currentrow = #currentRow# cflog log=APPLICATION text=Writing data to file, length: #fileOutput.length()# cfset fileWrite(fh, fileOutput.toString()) cfset fileOutput.delete(0,fileOutput.length()) /cfif /cfloop The total file size, when the job is complete, is about 84 megabytes. At the time the fileWrite() call takes place, the fileOutput variable contains about 3,000,000 characters (3mb) Anyone got any ideas here? -- 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:290886 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?
CF4.5 compatible 4.5... who still uses that? ;o) I'm on CF 8 now! :o) I saw the CF_REextract tag... I didn't work with it much because I couldn't see how to use it. I'll check it out again. 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. ~| 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:290887 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
You can't really. Your DB is badly designed if you have one field called hierarchy that contains multiple elements. Its not normalised. Normally the hierarchy would be in a different table. But if you want to persist with this and you can change the hierarchy field you would need to store it like. 001 001~007 001~008 001~009 001~010 001~012 001~012~013 001~012~014 Then when sorting this string, it will come out as you expect. I'm assuming you wouldn't have more than 999 items, but if you do, then you need to pad with more 0's. Regards Dale Fraser http://learncf.com -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Friday, 12 October 2007 8:04 AM 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 ~| 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:290888 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
Thanks, That seems to select, but not highlight the row. 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:290889 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
I think the problem is that I'm doing a refresh followed by a grid. And perhaps the grid hasn't finished refreshing when i'm doing the select. Is there some event that you can add to the refresh such as an onSuccess or onComplete to then select the row. 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:290890 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. 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. ~| 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:290891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Fire and forget CFTHREADs / CF8
So here's a question. I execute a cfthread on application startup, and it finishes its work. There is no terminate because the page context it was called from is long gone, and I've just discovered that a thread can't terminate itself. it leaves the thread running, basically forever. Not doing anything, but sitting there and identifiable in the server monitor. Has anyone looked at the impact of having lots of these lying around doing nothing? Any serious resource impact? ~| 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:290892 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
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 ~| 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:290893 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
Yeah, I see what you are talking about. I think that I need to look at redoing this table for sure. This was my first stab at a CMS and I am discovering some issues with it. This band-aid solution will work for the interim though. Thanks, Bruce -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 5:01 PM To: CF-Talk Subject: RE: Query Question You can't really. Your DB is badly designed if you have one field called hierarchy that contains multiple elements. Its not normalised. Normally the hierarchy would be in a different table. But if you want to persist with this and you can change the hierarchy field you would need to store it like. 001 001~007 001~008 001~009 001~010 001~012 001~012~013 001~012~014 Then when sorting this string, it will come out as you expect. I'm assuming you wouldn't have more than 999 items, but if you do, then you need to pad with more 0's. 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:290894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 ~| 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:290895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 ~| 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:290896 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
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 ~| 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:290897 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fire and forget CFTHREADs / CF8
Charles, What makes you think that a Thread doesn't end when the code stops processing? Mark On 10/12/07, Charles Sheehan-Miles [EMAIL PROTECTED] wrote: So here's a question. I execute a cfthread on application startup, and it finishes its work. There is no terminate because the page context it was called from is long gone, and I've just discovered that a thread can't terminate itself. it leaves the thread running, basically forever. Not doing anything, but sitting there and identifiable in the server monitor. Has anyone looked at the impact of having lots of these lying around doing nothing? Any serious resource impact? ~| 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:290899 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
I'm pretty sure that's not actually the case. I'd wager that CF has an internal thread pool, so that thread, once it's finished with it's assigned task, just remains in the pool to be reused as needed. This is similar to how CF page requests work: there is a pool of sleeping request processing threads waiting for a request to come in. At the end of the request, the thread is released, but it's not killed off, it gets reused by a subsequent request. Granted, I can't say that with any sort of empirical backing, but I'd wager that it's correct at least at a high level. One way to tell would be to create a page that fires off a thread, and load that page in the browser. Check the server monitor. Repeat a few more times, and compare what happens to the thread count in the monitor. I bet once you get up to 5 or 10 threads, you stop seeing new threads being created. And actually, I think there's a setting in the CF admin that controls this, now that I think about it. Don't have an instance in front of me to check, however. cheers, barneyb On 10/11/07, Charles Sheehan-Miles [EMAIL PROTECTED] wrote: So here's a question. I execute a cfthread on application startup, and it finishes its work. There is no terminate because the page context it was called from is long gone, and I've just discovered that a thread can't terminate itself. it leaves the thread running, basically forever. Not doing anything, but sitting there and identifiable in the server monitor. Has anyone looked at the impact of having lots of these lying around doing nothing? Any serious resource impact? -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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:290898 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
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 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:290900 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
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:290901 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
@Jerry - I have been trying that way but I am getting an error when the file opens. It says The file you are trying to open, 'dataFile.xls' is in a different format than specified by the file extension. For some reason it is trying to use the .cfm file. @Ben - Thanks for the help. I did not realize that excel was an option for cfreport. I will check that out. __ 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: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:43 PM 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 ~| 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:290902 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
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 ~| 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:290903 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?
have a look at cfschedule http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0328.htm On 10/11/07, Robert Mack [EMAIL PROTECTED] wrote: 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 ~| 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:290904 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
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)) On 10/11/07, Mark Mandel [EMAIL PROTECTED] wrote: Maybe replace the cfset fileOutput.delete(0,fileOutput.length()) With: cfset fileOutput.setLength(0) It would probably take less processing. Mark On 10/11/07, Rick Root [EMAIL PROTECTED] wrote: I'm trying to discover why a piece of code that I run causes my JVM memory usage to go up about 400MB. I'm using CF8... I'm not sure how to debug this. Basically I've got an event gateway request that generates an excel file (via HTML tables). I do a lot of string appends and i'm using the java stringbuffer method. Some of the memory usage is the query - in my test case, the CF8 server monitor says the query is about 50 megabytes. But obviously, something I'm doing in the looping through that query is sucking up memory. Here's a simplified example of the code in the loop... fileOutput is a java StringBuffer object.. the purpose of using the StringBuffer is because string concatenation in CF is very slow when done in high quantities. cfloop query=resultSet cfset fileOutput.append(START_ROW) cfloop list=#fields# index=ThisCol cfset fileOutput.append (replace(START_FIELD,___COLNAME___,ThisCol,ALL)) cfset fileOutput.append( resultSet[ThisCol][ resultSet.currentRow] ) cfset fileOutput.append(END_FIELD) /cfloop cfset fileOutput.append(END_ROW) cfif currentRow MOD 500 is 0 cflog log=APPLICATION text=Looping, currentrow = #currentRow# cflog log=APPLICATION text=Writing data to file, length: #fileOutput.length()# cfset fileWrite(fh, fileOutput.toString()) cfset fileOutput.delete(0,fileOutput.length()) /cfif /cfloop The total file size, when the job is complete, is about 84 megabytes. At the time the fileWrite() call takes place, the fileOutput variable contains about 3,000,000 characters (3mb) Anyone got any ideas here? -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| 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:290905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dates with Query of Query
Have you tried ...? cfset today = createODBCDate(now()) cfset tomorrow = createODBCDate(dateAdd('d', 1, now())) WHERE reminderDate = cfqueryparam cfsqltype=cf_sql_date value=#today# AND reminderDate cfqueryparam cfsqltype=cf_sql_date value=#tomorrow# You might also try CAST'ing the reminderDate column to either date or timestamp. ~| 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:290906 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, quot;16,16quot;?? Please help!
You'll get smarter answers if you say some words in your post. While I have to agree, I suspect you problem is your form uses method=get and you're appending #CGI.QUERY_STRING# to the action page. That will duplicate your parameter values. cfform action=../docs/docActionLog.cfm?#CGI.QUERY_STRING# ~| 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:290907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
I seek PT/FT CF developer Bethesda MD
I need someone to help me out with a health care related application that is really unique. Has a MS SQL database behind the CF. Will Pay $35/hr and need you PT or FT or temp, flexi hrs but need at least two days a week. 301-332-2686 or [EMAIL PROTECTED] call me we'll talk. Good English language skills useful. ~| 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-Jobs-Talk/message.cfm/messageid:3454 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11