[cfaussie] Re: CFbuilder2 thoughts?
Zac, CFBuilder takes some time to index the CFCs (depending on the number of files in the webroot, mappings etc,.). It uses these to provide code assist (for datasources, resolve CFC names). There is a preference option is CFBuilder to turn this on\off. Please refer to my blog post: http://www.sagarganatra.com/2010/05/coldfusion-builder-few-tweaks.html Also, I was not able to reproduce the CFBuilder hang with my project on a network location. Can you share the project, so that I can reproduce the issue? Thanks, Sagar. Adobe ColdFusion QE. Fusioned with ColdFusion - www.sagarganatra.com On Jul 1, 1:23 pm, Zac Spitzer zac.spit...@gmail.com wrote: I'm working over a network drive on the lan, I guess that might be the problem. All of the files I'm editing are only are small, most like 5-10k a few approaching 20k, which is just mostly some chunky sql gateways cfc's I have the console open, see what happens, maybe I will see the heisenberg effect I tried the progress window, but it locked up with everything else BTW thanks everyone for taking the time to help out :) On Fri, Jul 1, 2011 at 6:14 PM, Steve Onnis st...@cfcentral.com.au wrote: Do you have any projects setup that were pointed to files across a network and if so do you know if those projects are currently open? I know i have had issues with projects across a network opening slowly and seemingly crashing cfbuilder. I would suggest just opening it and leaving it it trying to open for a little bit rather than thinking it has crashed and forcing it to close -Original Message- From: Kai Koenig [mailto:k...@koeni.de] Sent: Friday, 1 July 2011 6:03 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: CFbuilder2 thoughts? Zac, maybe try Sagar's suggestion to start with consolelog and see if it tells you what the error/problem is. Cheers Kai On 1/07/2011, at 7:44 PM, Zac Spitzer wrote: so i even tried a new workspace, same issues, the it hung again, now it won't even start, I'm fed up - I just want to cut code now I'm in a total quandry on whether to fork out money to buy the software as my trial expires today and I've had so much grief On Fri, Jul 1, 2011 at 4:35 PM, Kai Koenig k...@koeni.de wrote: Hey all, Sagar, thanks so much for responding to this thread. Just to let everyone else on the list know, Sagar is part of the CF and CF Builder engineering team based in Bangalore. Cheers Kai A few of you are facing some performance related issues, here are my suggestions: After installing CFBuilder please read the Post_Install_Readme.txt file located under the CFBuilder install directory. Can you start CFBuilder (standalone) or Eclipse (plugin install) from the command line with an option -consolelog to see if any error messages are shown. When the workbench is launched Eclipse asks the user to specify a workspace location, the default workspace location is specified in the textbox (this is eclipse behavior). As Charlie pointed out the progress view can come handy and tasks which are running in the IDE can be observed. Thanks, Sagar Ganatra. Fusioned with ColdFusion -www.sagarganatra.com -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 263 414 web:http://www.ventego-creative.co.nz blog:http://www.bloginblack.de twitter:http://www.twitter.com/agentK -- -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 263 414 web:http://www.ventego-creative.co.nz blog:http://www.bloginblack.de twitter:http://www.twitter.com/agentK -- -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email
Re: [cfaussie] Re: Creating A Fast Dropdown List Lookup
Might be a stupid question, but are you sure the bottleneck is at the CF level? i.e. is the unit number column indexed in the database? On Thu, Jun 30, 2011 at 1:06 AM, charlie arehart charlie_li...@carehart.org wrote: Not knocking jQuery, but to be clear, the CFInput autosuggest is just as capable of generating its data from a remote call (ajax or otherwise). You can see an example in the CF Developer Guide (I show the CF9 one, but the feature worked essentially the same in CF8): http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172 e0811cbec22c24-7a01.html#WSc3ff6d0ea77859461172e0811cbec22c24-720chttp://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172%0Ae0811cbec22c24-7a01.html#WSc3ff6d0ea77859461172e0811cbec22c24-720c See also the related topic: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172 e0811cbec22c24-7a0a.htmlhttp://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172%0Ae0811cbec22c24-7a0a.html Of course, you can also just google coldfusion autosuggest to find many other resources where people show using this feature, including pros/cons, tips/traps. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of goldcoast_nerd Sent: Tuesday, June 28, 2011 11:03 PM To: cfaussie Subject: [cfaussie] Re: Creating A Fast Dropdown List Lookup yep jquery is the way to go here, cfinput autosuggest embeds all the values in the HTML, not ideal. here's the plugin i use -- http://docs.jquery.com/Plugins/autocomplete i would also suggest loading the contents via an ajax request which in turn returns values from a structure or an array if it doesnt change that often, so you dont have to run a query in the background on every keyup. all the best. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Formatting spreadsheet cell issues
I posted this a few days back but no responses. Anyone have any thoughts or comments? From: Steve Onnis [mailto:st...@cfcentral.com.au] Sent: Thursday, 30 June 2011 3:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Formatting spreadsheet cell issues Does anyone know how SpreadsheetFormatCellRange() actually works? I am having issues with a large spreadsheet which i am trying to format. When i open it in Office 2003 i get an error saying Too many cell formats and it opens the file stripping out a lot of the cell formatting to compensate. From what i have read, this message comes up if you have more than 4000 different cell formats. I am guessing that the SpreadsheetFormatCellRange() function is just a simple way of applying formatting to cell ranges but it seems that it still applies the formatting to individual cells rather than applying them in ranges. Is this correct? Is there another way to do this? The spread sheet only has 1600 rows and 4 columns so its not massive though seems to be big enough to cause this error. Regards Steve Onnis -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Formatting spreadsheet cell issues
this may be of no help, or I could be completely wrong, but I though coldfusion uses apache poi for excel stuff..? http://poi.apache.org/ maybe you could drop down into java and run some test, or post some questions on their forums / stackoverflow.com On Tue, Jul 5, 2011 at 12:32 PM, Steve Onnis st...@cfcentral.com.au wrote: I posted this a few days back but no responses. Anyone have any thoughts or comments? ** ** *From:* Steve Onnis [mailto:st...@cfcentral.com.au] *Sent:* Thursday, 30 June 2011 3:14 PM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Formatting spreadsheet cell issues ** ** Does anyone know how SpreadsheetFormatCellRange() actually works? ** ** I am having issues with a large spreadsheet which i am trying to format. When i open it in Office 2003 i get an error saying “Too many cell formats” and it opens the file stripping out a lot of the cell formatting to compensate. ** ** From what i have read, this message comes up if you have more than 4000 different cell formats. I am guessing that the SpreadsheetFormatCellRange() function is just a simple way of applying formatting to cell ranges but it seems that it still applies the formatting to individual cells rather than applying them in ranges. Is this correct? Is there another way to do this? The spread sheet only has 1600 rows and 4 columns so its not massive though seems to be big enough to cause this error. ** ** Regards Steve Onnis -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Formatting spreadsheet cell issues
and just to add, from microsoft site looks like a microsoft limit, not a coldfusion limit http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx http://support.microsoft.com/kb/213904 so use a later version of office? b On Tue, Jul 5, 2011 at 12:48 PM, Brett Herford-Fell brettsk...@gmail.comwrote: this may be of no help, or I could be completely wrong, but I though coldfusion uses apache poi for excel stuff..? http://poi.apache.org/ maybe you could drop down into java and run some test, or post some questions on their forums / stackoverflow.com On Tue, Jul 5, 2011 at 12:32 PM, Steve Onnis st...@cfcentral.com.auwrote: I posted this a few days back but no responses. Anyone have any thoughts or comments? ** ** *From:* Steve Onnis [mailto:st...@cfcentral.com.au] *Sent:* Thursday, 30 June 2011 3:14 PM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Formatting spreadsheet cell issues ** ** Does anyone know how SpreadsheetFormatCellRange() actually works? ** ** I am having issues with a large spreadsheet which i am trying to format. When i open it in Office 2003 i get an error saying “Too many cell formats” and it opens the file stripping out a lot of the cell formatting to compensate. ** ** From what i have read, this message comes up if you have more than 4000 different cell formats. I am guessing that the SpreadsheetFormatCellRange() function is just a simple way of applying formatting to cell ranges but it seems that it still applies the formatting to individual cells rather than applying them in ranges. Is this correct? Is there another way to do this? The spread sheet only has 1600 rows and 4 columns so its not massive though seems to be big enough to cause this error. ** ** Regards Steve Onnis -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: CFbuilder2 thoughts?
If any of you are still facing performance issues with CFBuilder2, please let me know asap. I'm not able to reproduce the issue that Zac has mentioned. Few suggestions: 1. Please read Post_Install_Readme.txt (under CFBuilder installation directory) for post installation steps. 2. The progress view will show current tasks being performed by the IDE, such as indexing CFCs etc,. You can stop the tasks by clicking the stop button in the progress view. 3. Start the IDE with a -consolelog option to see any errors or exceptions thrown while the IDE is starting. Please ignore the warning messages. 4. Restart the IDE by selecting a different workspace. The current workspace might have got corrupted for some reason. If possible, share the project or files so that I can reproduce the issue at my end. Thanks, Sagar. Adobe ColdFusion QE. Fusioned with ColdFusion - www.sagarganatra.com On Jul 4, 3:38 pm, Sagar Ganatra sa...@sagarganatra.com wrote: Zac, CFBuilder takes some time to index the CFCs (depending on the number of files in the webroot, mappings etc,.). It uses these to provide code assist (for datasources, resolve CFC names). There is a preference option is CFBuilder to turn this on\off. Please refer to my blog post:http://www.sagarganatra.com/2010/05/coldfusion-builder-few-tweaks.html Also, I was not able to reproduce the CFBuilder hang with my project on a network location. Can you share the project, so that I can reproduce the issue? Thanks, Sagar. Adobe ColdFusion QE. Fusioned with ColdFusion -www.sagarganatra.com On Jul 1, 1:23 pm, Zac Spitzer zac.spit...@gmail.com wrote: I'm working over a network drive on the lan, I guess that might be the problem. All of the files I'm editing are only are small, most like 5-10k a few approaching 20k, which is just mostly some chunky sql gateways cfc's I have the console open, see what happens, maybe I will see the heisenberg effect I tried the progress window, but it locked up with everything else BTW thanks everyone for taking the time to help out :) On Fri, Jul 1, 2011 at 6:14 PM, Steve Onnis st...@cfcentral.com.au wrote: Do you have any projects setup that were pointed to files across a network and if so do you know if those projects are currently open? I know i have had issues with projects across a network opening slowly and seemingly crashing cfbuilder. I would suggest just opening it and leaving it it trying to open for a little bit rather than thinking it has crashed and forcing it to close -Original Message- From: Kai Koenig [mailto:k...@koeni.de] Sent: Friday, 1 July 2011 6:03 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: CFbuilder2 thoughts? Zac, maybe try Sagar's suggestion to start with consolelog and see if it tells you what the error/problem is. Cheers Kai On 1/07/2011, at 7:44 PM, Zac Spitzer wrote: so i even tried a new workspace, same issues, the it hung again, now it won't even start, I'm fed up - I just want to cut code now I'm in a total quandry on whether to fork out money to buy the software as my trial expires today and I've had so much grief On Fri, Jul 1, 2011 at 4:35 PM, Kai Koenig k...@koeni.de wrote: Hey all, Sagar, thanks so much for responding to this thread. Just to let everyone else on the list know, Sagar is part of the CF and CF Builder engineering team based in Bangalore. Cheers Kai A few of you are facing some performance related issues, here are my suggestions: After installing CFBuilder please read the Post_Install_Readme.txt file located under the CFBuilder install directory. Can you start CFBuilder (standalone) or Eclipse (plugin install) from the command line with an option -consolelog to see if any error messages are shown. When the workbench is launched Eclipse asks the user to specify a workspace location, the default workspace location is specified in the textbox (this is eclipse behavior). As Charlie pointed out the progress view can come handy and tasks which are running in the IDE can be observed. Thanks, Sagar Ganatra. Fusioned with ColdFusion -www.sagarganatra.com -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 263 414 web:http://www.ventego-creative.co.nz blog:http://www.bloginblack.de twitter:http://www.twitter.com/agentK -- -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847
RE: [cfaussie] Formatting spreadsheet cell issues
Microsoft does format groups. Coldfusion seems to add the format to individual cells which is where the limit comes into it. If i format cells within excel i can format anything i want. From: Brett Herford-Fell [mailto:brettsk...@gmail.com] Sent: Tuesday, 5 July 2011 12:56 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Formatting spreadsheet cell issues and just to add, from microsoft site looks like a microsoft limit, not a coldfusion limit http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits -HP005199291.aspx http://support.microsoft.com/kb/213904 so use a later version of office? b On Tue, Jul 5, 2011 at 12:48 PM, Brett Herford-Fell brettsk...@gmail.com wrote: this may be of no help, or I could be completely wrong, but I though coldfusion uses apache poi for excel stuff..? http://poi.apache.org/ maybe you could drop down into java and run some test, or post some questions on their forums / stackoverflow.com On Tue, Jul 5, 2011 at 12:32 PM, Steve Onnis st...@cfcentral.com.au wrote: I posted this a few days back but no responses. Anyone have any thoughts or comments? From: Steve Onnis [mailto:st...@cfcentral.com.au] Sent: Thursday, 30 June 2011 3:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Formatting spreadsheet cell issues Does anyone know how SpreadsheetFormatCellRange() actually works? I am having issues with a large spreadsheet which i am trying to format. When i open it in Office 2003 i get an error saying Too many cell formats and it opens the file stripping out a lot of the cell formatting to compensate. From what i have read, this message comes up if you have more than 4000 different cell formats. I am guessing that the SpreadsheetFormatCellRange() function is just a simple way of applying formatting to cell ranges but it seems that it still applies the formatting to individual cells rather than applying them in ranges. Is this correct? Is there another way to do this? The spread sheet only has 1600 rows and 4 columns so its not massive though seems to be big enough to cause this error. Regards Steve Onnis -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.